Cursor Flags
Here you can learn about the cursor flags.
Flags to be used with the flags attribute:
|
Flag |
Flag (dec) |
Meaning |
|---|---|---|
|
0x00000020 |
32 |
do not check rights for records of this table |
|
0x00000040 |
64 |
No longer supported. See 0x00004000 below! |
|
0x00000080 |
128 |
return records of this table as "summed" (only applicable for 1:N relations) |
|
0x00000100 |
256 |
WITH: parent record is only returned when at least one record exists |
|
0x00000200 |
512 |
EXISTS: records of this table are not returned (used in combination with WITH) |
|
0x00000400 |
1024 |
NOT EXISTS: like above |
|
0x00000800 |
2048 |
OPTIONAL |
|
0x00004000 |
16384 |
also read records marked as deleted. Please note: for Aurea CRM interface Service Pack 6 and older this flag (allowing for reading also records marked as deleted) is 0x00000040 (64)! CRM.interface0x00004000 Aurea CRM interface SP7+ 0x00004000 Aurea CRM interface SP6 0x00000040 |
Example: companies and persons are read, companies without persons are not returned
<request>
<query>
<tables>
<table tablename="Company">
<table tablename="Person" flags="256"/>
</table>
</tables>
<fields tablename="Company" fields="Company"/>
<fields tablename="Person" fieldname="LastName,FirstName"/>
<condition>
<cond tablename="Company" fieldname="Company" op="=" value="update*"/>
</condition>
</query>
</request>Example: return the sum of a field (e.g. costs) for all contact records for one company
<request>
<query>
<tables>
<table tablename="Company">
<table tablename="Contact" flags="128"/>
</table>
</tables>
<fields tablename="Company" fields="Company"/>
<fields tablename="Contact" fields="Costs"/>
<condition>
<cond tablename="Company" fieldname="Company" op="=" value="update software AG"/>
</condition>
</query>
</request>