All Joelie Selectors

  • /table

    Use "/" to select records from a specific table.

  • .field

    Use "." to select a particular field from any /table

  • -id

    Use "-" to select records with an exact id number or globally unique title

  • =stitle

    Use "=" to refer to records that have a unique title within a certain site

  • ^site

    Use "^" to select records from a specific Joelie site

  • @user

    Use "@" to select records that belong to a particular Joelie user

  • :match

    Use ":" to select records with titles matching a certain string

  • .field:match

    Use "." and ":" to select records where a certain field matches a value

  • More Selectors...

    Master all of the Joelie selectors to get the most out of Joelie.

Introducing Joelie Selectors

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:

/photo@bob

Here's the same basic statement in SQL, which is three lines at its simplest:

SELECT *
FROM photo
WHERE photo.user_id = [bob's user id]

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.