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.

Joelie allows you to quickly define your website's data rules without writing any SQL. The Joelie Data Def can be thought of as similar to a database's schema.

Data Defs are stored in your Joelie site's .datadef and .datadef_protected fields. Rules about general data on your site should be stored in .datadef, while rules about private data should be stored in .datadef_protected. Only your site's administrative users and their code will be able to access data as described in .datadef_protected.