Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Version: Available from runtime version 1.0.
Specifies links between fields in a query data item and fields in one or more data items above it.
Applies to
- Query data items
Property value
Field=AncestorDataItem.ReferenceField
Fieldis the name of the field in the table of the lower data item.AncestorDataItemis the name of an ancestor data item.ReferenceFieldis the name of a field in the table of the ancestor data item.
Note
You can link to more than one column. Separate multiple column links with a comma.
Remarks
The DataItemLink property works with the SqlJoinType property to combine records from tables into a dataset. It defines an equal-to (=) comparison between fields in the data item tables. The query combines records that have matching field values. Set DataItemLink on the lower data item in the query object.
Note
You can't set DataItemLink when SqlJoinType is set to CrossJoin. Learn more in Linking and joining data items to define the query dataset.
You can't use FlowField or FlowFilter fields in a query DataItemLink.
Example
A Salesperson data item and a Sales Header data item contain the Code and Salesperson Code fields, respectively. To link the data items, set the DataItemLink property on the Sales Header data item.
DataItemLink = "Salesperson Code" = Salesperson.Code;
Related information
Query object
SqlJoinType property
DataItemLink property for reports