Difference between revisions of "QREL"
From SDU
(QREL) |
(reverting vandalism) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | __NOTOC__ | |
| + | [[Category:r6]] | ||
| + | [[Category:r11]] | ||
| + | {{Global Header}} | ||
| + | {{Global Announcement}} | ||
| + | == Overview == | ||
| + | A QREL attribute is a "Query RELation". A QREL attribute is also a list of objects defined by a where clause. | ||
| − | QREL Syntax | + | '''QREL Syntax''' |
| − | children QREL chg DYNAMIC { | + | <source lang="javascript">children QREL chg DYNAMIC { |
WHERE "parent = ? " ; | WHERE "parent = ? " ; | ||
PARAM_NAMES { id } ; | PARAM_NAMES { id } ; | ||
DOMSET chg_list ; | DOMSET chg_list ; | ||
| − | } ; | + | } ;</source> |
Used to access a list of objects related to the current object using where clause | Used to access a list of objects related to the current object using where clause | ||
| − | Many to One Relationship | + | Many to One Relationship<br> |
| − | Example: The relationship of many Child Requests to Parent Request | + | '''Example:''' The relationship of many Child Requests to Parent Request |
Indicates a virtual column representing a set of objects selected by the | Indicates a virtual column representing a set of objects selected by the | ||
where clause on the Advanced tab. It exists only in the Object Engine | where clause on the Advanced tab. It exists only in the Object Engine | ||
and is not physically stored in the database. | and is not physically stored in the database. | ||
Latest revision as of 12:28, 18 November 2010
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
To discuss or ask questions about this article, select the discussion tab above.
Overview
A QREL attribute is a "Query RELation". A QREL attribute is also a list of objects defined by a where clause.
QREL Syntax <source lang="javascript">children QREL chg DYNAMIC { WHERE "parent = ? " ; PARAM_NAMES { id } ; DOMSET chg_list ; } ;</source>
Used to access a list of objects related to the current object using where clause
Many to One Relationship
Example: The relationship of many Child Requests to Parent Request
Indicates a virtual column representing a set of objects selected by the where clause on the Advanced tab. It exists only in the Object Engine and is not physically stored in the database.
