Changes between Version 15 and Version 16 of S3/S3ResourceFilter

Timestamp:

02/03/12 14:25:31 (13 years ago)

Author:

Dominic König

Comment:

--

S3/S3ResourceFilter

@@ -47 +47 @@
 
 {{{
-alias.{foreign key$}field
+alias.{fkey$}field
 }}}
 
   - '''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.
-  - '''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).
+  - '''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).
   - '''field''' is the name of the field or a virtual field in the table addressed by ''alias'' (plus ''foreign key'' where present).
 
-With this syntax, it is possible to address fields in the primary table, in component tables and in directly referenced tables.
+To 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:
+{{{
+alias.{{lkey:}linktable{:rkey}$}field
+}}}
 
-It is not yet possible to address fields in tables linked by link tables - this is though subject to change in the near future.
 
+  - '''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)
+  - '''linktable''' is the name of the linktable
+  - '''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)
 == URL queries ==