Re: [Virtuoso-users] Trouble writing a query filter

[Kingsley Idehen]

On 7/25/14 4:26 PM, Legault, Phillip [ITSUS] wrote:

Tried this and I'm unable to get it to work.

Sent from my iPhone

On Jul 25, 2014, at 2:39 PM, "Rumi" <rtsek...@openlinksw.com> wrote:

Hi Phillip,

On 25-Jul-14 4:00 PM, Legault, Phillip [ITSUS] wrote:
I'm trying to write a query  filter, to filter ?support_status = Obsolete and 
?start_date is <= NOW

What about if you added:

FILTER ( datatype (?start_date) in (xsd:dateTime, xsd:date)  ) ;
FILTER ( xsd:dateTime(str(?start_date)) <= xsd:dateTime( str(bif:now () ) )) ;


Best Regards,
Rumi Kocis

This works with the first part with ?support_status =Obsolete, however I'm 
stuck trying to figure out the second part. Any help is greatly appreciated.

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX swivt:<http://semantic-mediawiki.org/swivt/1.0#>
PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
SELECT ?supported_by ?category ?name ?version ?technology_name ?owner ?contact 
?publication_date ?publication_status ?manufactured_by ?license_type 
?support_status ?start_date ?end_date
WHERE
{
   ?s ?p ?cat .
   ?cat rdfs:label ?category .
   FILTER(CONTAINS(STR(?cat), "Category") && regex(?category, 
"^(?!Technology)")) .
   ?s property:Has_Name ?name .
   OPTIONAL {
   ?s swivt:specialProperty_SOBJ ?subobject .
   ?subobject property:Has_Version ?version .
   ?subobject property:Technology_Name ?technology_name .
   ?subobject property:Has_Support_Status ?support_status .
   ?subobject property:Has_Start_Date ?start_date .
    }
   OPTIONAL {
    ?s swivt:specialProperty_SOBJ ?subobject .
    ?subobject property:Has_End_Date ?end_date .
   }
   OPTIONAL {
    ?s swivt:specialProperty_SOBJ ?subobject .
    ?subobject property:Supported_By ?supported_by .
   }
   OPTIONAL {
     ?s property:OwnedBy ?owner.
   }
   OPTIONAL {
     ?s property:Contact ?contact.
   }
   OPTIONAL {
     ?s property:PublicationDate ?publication_date .
   }
   OPTIONAL {
     ?s property:PublicationStatus ?publication_status .
   }
   OPTIONAL {
     ?s property:ManufacturedBy ?mb .
     ?mb rdfs:label ?manufactured_by .
   }
   OPTIONAL {
     ?s property:LicenseType ?lt .
     ?lt rdfs:label ?license_type .
   }
    FILTER( regex(STR(?support_status), "Obsolete", "i"))
}
ORDER BY ?category ?name ?version
LIMIT 1000000



Thank You!
Phil

Links:

[1] http://linkeddata.uriburner.com/sparql

[2] http://lod.openlinksw.com/sparql

Are you able to make a rendition of this query on one of our live instances [1][2]? If you could, simply repeat and then share a query results URL. Note, if there's a public MediaWiki with similar content, you can sponge it, using the special export URL [3]. [3] http://linkeddata.uriburner.com -- paste in the Semantic MediaWiki RDF export URL and then use that URL as the Named Graph IRI in your SPARQL query .

--
Regards,

Kingsley Idehen 
Founder & CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog 1: http://kidehen.blogspot.com
Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
Twitter Profile: https://twitter.com/kidehen
Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this

smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users