This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| ref:b_i:undefined_with_multiple_references [2026/08/13 00:42] – ↷ Page moved from b_i:undefined_with_multiple_references to ref:b_i:undefined_with_multiple_references localdev | ref:b_i:undefined_with_multiple_references [2026/08/13 07:11] (current) – external edit 127.0.0.1 |
|---|
| |
| ==== Undefined With Multiple References ==== | ==== Undefined With Multiple References ==== |
| <grid> | <row> |
| <col sm="1"><invisible> This is a spacer column</invisible></col> | <col size="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Problem/Limitation Description=== | <col size="5">===Problem/Limitation Description=== |
| Checking for ''UNDEFINED'' value of a multiple reference attribute (see [[docs:2000_concepts:0200_basics:0400_reference_attributes|Reference Attributes]]) in queries does not work correctly. For example, the following will not work:<code aim>FIND Account WHERE Account.Transactions IS UNDEFINED </code> | Checking for ''UNDEFINED'' value of a multiple reference attribute (see [[2000_concepts:0200_basics:0400_reference_attributes|Reference Attributes]]) in queries does not work correctly. For example, the following will not work:<code aim>FIND Account WHERE Account.Transactions IS UNDEFINED </code> |
| </col> | </col> |
| |
| <col sm="1"><invisible> This is a spacer column</invisible></col> | <col size="1"><invisible> This is a spacer column</invisible></col> |
| |
| <col sm="5">===Work Around=== | <col size="5">===Work Around=== |
| Use ''EXISTS'' or ''COUNT'' expressions, for example<code aim>FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0 </code> | Use ''EXISTS'' or ''COUNT'' expressions, for example<code aim>FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0 </code> |
| |
| </col> | </col> |
| </grid> | </row> |
| |
| |