%META:TOPICPARENT{name="VirtuosoFacetsWebService"}% ---+Virtuoso Facet Browser Featured Queries %TOC% The Virtuoso Facet Browser UI allows users to save Faceted View and iSPARQL queries as "Featured" queries for future reference. This requires the installation of the Virtuoso [[https://virtuoso.openlinksw.com/download/][Facet Browser]] and [[https://virtuoso.openlinksw.com/download/][iSPARQL]] VAD packages. ---++Usage 1 If not already done, install the [[VirtFacetBrowserInstallConfig][Facet Browser]] VAD application. 1 Load the Virtuoso Facted Browser UI http://cname:port/fct %BR%%BR% %BR%%BR% 1 Click on the Feature link in the top right of the page to load the Featured Queries page %BR%%BR% %BR%%BR% There are two form of queries that can be saved as detailed below. ---+++Faceted Views This allows the saving of the results from faceted searches in the Browser, to save such results: 1 Search for some sample text, ski resorts for example. %BR%%BR% %BR%%BR% 1 Select the save link in the right frame of the results page %BR%%BR% %BR%%BR% 1 Provide a Title and Description for the results page to be saved as %BR%%BR% %BR%%BR% 1 Once saved click the continue button to save to a table called fct_stored_qry %BR%%BR% %BR%%BR% 1 This table then needs to be queried to determine the fsq_id of the item added and its fsq_featured value set to 1 for it to be visible as a Featured query. SQL> select * from fct_stored_qry; fsq_id fsq_created fsq_title fsq_expln fsq_state fsq_featured INTEGER NOT NULL BINARY VARCHAR VARCHAR LONG NVARCHAR INTEGER _______________________________________________________________________________ 1 2011-05-05 10:59:24.000001 Ski Resorts Ski Resort Search Results Ski resorts NULL 1 Rows. -- 7 msec. SQL> update fct_stored_qry set fsq_featured=1 where fsq_id=1; Done. -- 3 msec. SQL> 1 The saved Facet View query is now visible in the Featured Queries page. %BR%%BR% %BR%%BR% ---++SPARQL Queries Queries from the Virtuoso Interactive SPARQL Query Builder (iSPARQL) application can be saved in the Facet Browser Feature Queries page and re-executed either from iSPARQL or the SPARQL endpoint, as follows: 1 If not already done, install the [[https://virtuoso.openlinksw.com/download/][iSPARQL VAD]] application from the System Admin -> Packages" tab of the Conductor. 1 Run iSPARQL application from the URL http://cname:port/isparql , login as the dav user and from the Advanced tab enter a SPARQL query of the form select * where {?s ?p ?o . ?o bif:contains '(SKI AND RESORTS)'}. %BR%%BR% %BR%%BR% 1 In the Query Metadata drop down frame of Advanced tab for the query, enter a Title, Description and Creator for the query to be saved. %BR%%BR% %BR%%BR% 1 Click on the Save icon button and navigate to the /DAV/home/dav/sparql_ demo_ queries/ folder and save the query to filename with a .isqarql extension. *Note*, if the /DAV/home/dav/sparql_ demo_ queries/ folder does not already exist, manually create if using the Web Application Server -> Content Management tab of the Conductor. %BR%%BR% %BR%%BR% 1 Navigate to the Feature query link of the Facet Browser where the saved iSPARQL query is now visble. %BR%%BR% %BR%%BR% 1 Click on the ...iSPARQL Query link to execute the query in iSPARQL. %BR%%BR% %BR%%BR% 1 Click on the Run in SPARQL endpoint link to execute the query in iSPARQL. %BR%%BR% %BR%%BR% ---++Related * [[http://wikis.openlinksw.com/dataspace/owiki/wiki/OATWikiWeb/InteractiveSparqlQueryBuilderOverview][Virtuoso Interactive SPARQL Query Builder]] * Facets Web Service: * [[VirtuosoFacetsWebService][Virtuoso Facets Web Service]] * Linked Data: * [[VirtuosoFacetsViewsLinkedData][Faceted Views over Large-Scale Linked Data]] * Facet Browser Installation and configuration: * [[VirtFacetBrowserInstallConfig][Virtuoso Facet Browser Installation and configuration]] * Facet APIs: * [[VirtFacetBrowserAPIs][Virtuoso APIs for FCT REST services]] * [[VirtFacetBrowserAPIsFCTEXEC][fct_exec API Example]] * Pivot Viewer and CXML: * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSparqlCxmlFacetPivotBridge#AncSparqlCxmlFacetPivotBridge][Facet Pivot Bridge - A bridge to PivotViewer from Virtuoso's Faceted query service for RDF]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtSparqlCxml#AncFacetTypeAutoDetection][Auto-Detection of Facet Type]] * Tutorials: * [[VirtuosoLODSampleTutorial][Faceted Browsing Sample using LOD Cloud Cache data space]] * [[VirtuosoFacetsWebServiceSOAPExample][SOAP Facets Example]] * [[VirtFacetBrowserInstallConfigQueried][Querying The Facet Browser Web Service endpoint]] * [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtVisualizeWithPivotViewer#GenFCT][Visualizing Your Data With PivotViewer Using The Facet Browser]] * [[VirtTipsAndTricksCustomControlLabelsURI][Custom Controlling Virtuoso Labels for URI functionality Example]] * [[VirtuosoFacetsWebServiceCustmExamples][Facets Web Service: Examples for customizing different types]] * [[VirtuosoFacetsWebServiceChoiceExample][Facets Web Service: Choice of Labels Example]] * Downloads: * [[http://shop.openlinksw.com/license_generator/virtuoso-download/][Latest Virtuoso]] * [[https://virtuoso.openlinksw.com/download/][Virtuoso Facet Browser VAD package]]