SQL JCR Sample Queries

-stub article

This page contains some example SQL*** queries that can be used in the JCR browser:

• All templates:

• Template with ID = X:

•  Siteworks object with ID = X:

• All objecttypes:

• Webpage item with Siteworks name 'Queries':

• Webpage item with reference to node Siteworks object of objecttype itemtype and name '370eea2b4dcbba2700212ab636f5':

• JCR item with UUID '8d38de7b-cec9-4fd6-a714-65e1a61b5bba':

• All SiteWorks tasks (per webinitiatif):

  select * from wo:wm_taskmanager
  

• All pages, in descending name order

• All objects for given objecttype

• All paragraph elements with text 'XX'

• If you wish to find all elements - that use wo:text to save their data (rich text, paragraph, etc.) - containing 'XX'

• To see a list of WebManager language labels in the edit environment use the following query:

• To see a list of all webinitiatives

  select * from wo:wm_webinitiatif
  

• To see a list of ss_element_external_content where "last X days" > 100 use the following query:

• When comparing date properties, use the xs:dateTime function. Caution: JackRabbit only accepts a fully specified date, including the time in milliseconds:

*** Please note that Jackrabbit supports ...