Use "/" to select records from a specific table.
Use "." to select a particular field from any /table
Use "-" to select records with an exact id number or globally unique title
Use "=" to refer to records that have a unique title within a certain site
Use "^" to select records from a specific Joelie site
Use "@" to select records that belong to a particular Joelie user
Use ":" to select records with titles matching a certain string
Use "." and ":" to select records where a certain field matches a value
Master all of the Joelie selectors to get the most out of Joelie.
Joelie makes it easy to work with dynamic data and use it on your website. You can easily use Joelie Selectors to output a set of photos, list all blog posts on a web site or just find data faster when you are using the Joelie.org website.
Joelie Selectors eliminate the need for writing SQL in most cases, which can speed up everyone from complete beginners to veteran programmers. Joelie Selectors allow you to describe data easily, whether you are describing it to a computer or another person.
For example, the Joelie Selector statement for "all photos by user bob" is just one line of text:
Here's the same basic statement in SQL, which is three lines at its simplest:
You can use Joelie Selectors to Define, Select, Insert, Update or Delete data from Joelie. You can also use Real SQL in your Joelie code when you aren't able to express a certain query using Joelie Selectors.