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

[Rumi <rts...@op...>]

Hi Phillip,

On 25-Jul-14 10:26 PM, Legault, Phillip [ITSUS] wrote:
> Tried this and I'm unable to get it to work.

Re. unable to work, do you mean getting an error after executing the query?
Please share the result output if possible.

Also would be helpful if you give example of the data triples you are 
trying to query since
it is internal mediawiki etc.


Best Regards,
Rumi Kocis

>
> Sent from my iPhone
>
>> On Jul 25, 2014, at 2:39 PM, "Rumi" <rts...@op...> 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:&lt;http://www.w3.org/2000/01/rdf-schema#&gt;
>>> PREFIX swivt:&lt;http://semantic-mediawiki.org/swivt/1.0#&gt;
>>> PREFIX xsd:&lt;http://www.w3.org/2001/XMLSchema#&gt;
>>> 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
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> Vir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>