Select nodes where a property exactly matches a string SELECT * FROM As node WHERE node. Select all sites where the site name has a length of 8 SELECT * FROM as site where LENGTH(site.) = 8 Select * from as node where upper(node.) = 'HOME' Select all pages where the title matches a string without considering the case select * from as node where lower(node.) = 'home' Select nodes where a property partially matches a string SELECT * FROM As node WHERE node. Select all pages with a null title SELECT * FROM As page WHERE page. Select all the content nodes of two different typesįor this query to work, the main selector ( jnt:content) must be inherited by all searched types. Most of the time, jnt:content or jmix:searchable is the right selector to use. SELECT * FROM As node WHERE contains(node.*, 'digital') Querying templates Select all the content nodes that have a property containing the String "digital". Select all the pages with a specific template SELECT * FROM As page WHERE page. The DESC keyword at the end of the query reverses the order of the result set. Select all the pages published after January 1st, 2017 select * from as page where page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |