Use the "/table" selector to describe Joelie records that must come from a certain table. For example, use "/image" to select records from the "image" table.
Get all images on Joelie.org: /image^joelie Get all routines on Joelie.org: /routine^joelie Get all images and routines on Joelie.org: /image/routine^joelie
Use the ".field" selector to describe certain fields within Joelie /tables. For example, ".title" means to use the "title" field.
Get photos and their titles: /photo.title Get photos with titles and notes /photo.title.notes Get photos with any custom field: /photo.title.notes.mycoolfield
Use the "-id" selector to describe records with an exact id number or globally unique title (".gutitle"). For example, the only routine with the globally unique title "slashes" is called /routine-slashes.
Get routine with id number 5962 /routine-5962 Get the only routine with .gutitle:slashes /routine-slashes Get only certain routines: /routine-slashes-redir-recoil_js
Use the "=stitle" selector to describe records that have a specific unique title within a certain Joelie site. "=stitle" statements are usually used alongside "^site" statements, because stitles are site-specific. For example, to select the "home" routine from a site called "mysite", use "/routine=home^mysite".
Get the logo from Recoil App Builder: /image=logo^ra Get the solo routine from "mysite" /routine=solo^mysite Get any image that is a logo /image=logo
Use the "^site" selector to describe records from a particular Joelie site. For example, records that belong to a /site-mysite can be selected with "^mysite".
Get all images from Joelie.org site /image^joelie Get all data from "mysite" ^mysite Get data from certain sites: ^joelie^mysite^myothersite
Use the "@user" selector to describe records that belong to a particular user of any Joelie website. For example, use "@123" to select records from the only user with id number 123.
Get all routines belonging to user 123 /routine@123 Get all data from larry, curly and moe @larry@curly@moe
Use the ":match" selector to describe records with significant fields containing certain text. By default, the ":match" selector searches the .title, .stitle and .gutitle fields. So, for example, to select any record with .title, .stitle or .gutitle matching "awesome", use ":awesome".
Search for "awesome" :awesome Search for routines that match "awesome" /routine:awesome Search for awesome routines on Joelie.org /routine:awesome^joelie
Use the ".field:match" selectors to describe records that have a specific field matching a specific value. For example, to select images with notes matching "zebra", use "/image.notes:zebra".
Search for "zebra" :zebra Search for "zebra", but only in notes .notes:zebra Search for title AND notes containing "zebra" .title:zebra.notes:zebra
Use the "~partialgutitle" selector to describe .gutitle naming patterns. The "~" selector tells Joelie to match only the beginning of gutitles, regardless of how they end. For example, if you've named several routines like -about_info, -about_location, -about_contact, you could select them all using "~about_".
Any unique record starting with "about_" ~about_ Only routines with gutitle beginning in "color" /routine~color Only sites that start with "f" /site~f
Use the "*partialstitle" selector to describe .stitle naming patterns. The "*" selector tells Joelie to match only the beginning of stitles, regardless of how they end. For example, if you've named several routines like =store_toys, =store_games, =store_books, you could select them all using "*store_".
Any image beginning with "logo" *logo Only Joelie.org routines with stitle beginning in "jnx" /routine*jnx^joelie
Use the ":1,10" pattern when searching numeric fields. For example, to select users with between 10 and 25 friends, use "/user.friends_unsignedint:10,25"
Find users with low id numbers /user:0,1000 Find transactions between $1 and $4.99 /otransaction.sum_double:"1.0,4.99"
Use the ":[1,2,4]" pattern when searching numeric fields. For example, to select stores with territory_id of either 5, 9 or 100, use "/store.territory_id:[5,9,100]"
Get three users by ID number: /user.id:[12315,47824,73834] Get workers from zones 3, 6, 9 and 11 /worker.zone_id:"[3,6,9,11]"