Changes between Version 15 and Version 16 of S3/S3ResourceFilter


Ignore:
Timestamp:
02/03/12 14:25:31 (10 years ago)
Author:
Dominic König
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • S3/S3ResourceFilter

    v15 v16  
    4747
    4848{{{
    49 alias.{foreign key$}field
     49alias.{fkey$}field
    5050}}}
    5151
    5252  - '''alias''' is the alias of the component without prefix, e.g. "contact" for the pr_contact component (note that components may use aliases different from their table name). For the primary table of a resource (master table), "alias" is just the tablename without prefix.
    53   - '''foreign key''' is the name of a foreign key field in the table specified by ''alias'', both together addressing the table referenced by this foreign key. It is possible to chain foreign key selectors to address tables which are more than one reference level away. Note that only real foreign key fields can be used (i.e. neither integer fields nor virtual fields).
     53  - '''fkey''' is the name of a foreign key field in the table specified by ''alias'', both together addressing the table referenced by this foreign key. It is possible to chain foreign key selectors to address tables which are more than one reference level away. Note that only real foreign key fields can be used (i.e. neither integer fields nor virtual fields).
    5454  - '''field''' is the name of the field or a virtual field in the table addressed by ''alias'' (plus ''foreign key'' where present).
    5555
    56 With this syntax, it is possible to address fields in the primary table, in component tables and in directly referenced tables.
     56To access fields in a table which is linked via a link table, replace the fkey by the link table name and add left and right key if needed:
     57{{{
     58alias.{{lkey:}linktable{:rkey}$}field
     59}}}
    5760
    58 It is not yet possible to address fields in tables linked by link tables - this is though subject to change in the near future.
    5961
     62  - '''lkey''' is the name of the left foreign key in the linktable (can be omitted if not ambiguous, i.e. only one fk in the linktable pointing to this resource/component)
     63  - '''linktable''' is the name of the linktable
     64  - '''rkey''' is the name of the right foreign key in the linktable (can be omitted if not ambiguous, i.e. only one other fk in the linktable)
    6065== URL queries ==
    6166