All Joelie Selectors

Jump to:

 

/table

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
 

.field

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
 

-id

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
 

=stitle

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
 

^site

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
 

@user

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
 

:match

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
 

.field:match

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
 

~partialgutitle

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
 

*partialstitle

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
 

.number:1,10

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"
 

.number:[1,2,4]

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]"