Not logged in : Login

About: VirtTipsAndTricksGuideInsensSearch     Goto   Sponge   Distinct   Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

AttributesValues
type
Date Created
Date Modified
label
  • VirtTipsAndTricksGuideInsensSearch
maker
Title
  • VirtTipsAndTricksGuideInsensSearch
isDescribedUsing
has creator
content
  • %META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---++How Can I Perform Case Insensitive Search across multiple Literal values with Virtuoso? If you use contains, it will make an approximate filtering of results, its is therefore best to use FILTER with bif:lower. For example with the following RDF triples loaded in Virtuoso: "An?lisis" . "Aut?nomas" . "Autonom?a de gobierno" . "Autonom?a" . "Auton?mica" . "Com?n" . "Comunidades" . "Cr?tico" . The following query is case sensitive, thus no data is returned as is expected: SQL> SPARQL PREFIX sioc_t: SELECT DISTINCT ?s FROM WHERE { ?s sioc_t:Tag ?Tag. FILTER ( ?Tag in ('analisi', 'autonomas', 'autonomia de gobierno', 'autonomia', 'autonomica', 'comun', 'comunidades', 'critico' ) ) } -- Query result: s ANY No. of rows in result: 0 Changing the query to use the Virtuoso bif:lower function a case insensitive filter is performed returning one distinct row: SQL>SPARQL PREFIX sioc_t: SELECT DISTINCT ?s FROM WHERE { ?s sioc_t:Tag ?Tag. FILTER ( bif:lower(str(?Tag)) in ('analisi', 'autonomas', 'autonomia de gobierno', 'autonomia', 'autonomica', 'comun', 'comunidades', 'critico' ) ) } -- Query result: s ANY http://gnoss/000066A5-E5C4-4317-AC9F-4A226E65AE4D No. of rows in result: 1 ---+++Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparqlrulefulltext][Using Full Text Search in SPARQL]]
id
  • 7efacad24b1a4c72849a1fd3d311733d
link
has container
http://rdfs.org/si...ices#has_services
atom:title
  • VirtTipsAndTricksGuideInsensSearch
links to
atom:source
atom:author
atom:published
  • 2017-06-13T05:36:12Z
atom:updated
  • 2017-06-13T05:36:12Z
topic
is made of
is container of of
is link of
is http://rdfs.org/si...vices#services_of of
is links to of
is creator of of
is atom:entry of
is atom:contains of
Faceted Search & Find service v1.17_git132 as of May 12 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3332 as of Sep 11 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 2 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software