How to query .nt files in Apache Jena Server

mandeepsingh

Hi,

Sorry if this question is already answered on the forum. Please redirect me to the right page.

I have uploaded the organization file (OpenPermID-bulk-organization-20210307_112038.nt ) on the apache jena server.

Result: success. 57832465 triples

I am now on the query window but my queries don't return a response. Can someone share sample queries for organization files? sorry for the limited knowledge on this query language.

Few use cases I want to build :

1. Count of PermIds in the file

2. List of PermId having LEI associated with it

Jirapongse

@mandeepsingh

I am new to SPARQL too. I think the query could be:

1. Count of PermIds in the file

SELECT (count(distinct ?s) as ?count)
WHERE { ?s ?p ?o }

2. List of PermId having LEI associated with it

SELECT ?permID ?object
WHERE {  
  ?permID <http://permid.org/ontology/organization/hasLEI&gt; ?object .
}

mandeepsingh

Thanks for the response @jirapongse.phuriphanvichai. Not sure why I can't see the results while executing the above two queries.

Jirapongse

From my test, it returns the following.

Can you check with this query?

SELECT ?permID 
WHERE {  
  ?permID <http://permid.org/ontology/organization/hasLEI&gt; "5493000BPC9ZTGJKQW88" .
}