PL-400 · Question #390
You are creating a FetchXML query. The query must return data from a table and return filtered data from a related table. You need to configure the FetchXML query. Which two elements should you use?…
The correct answer is B. link-entity D. condition. FetchXML uses link-entity (B) to perform a JOIN to a related table, equivalent to a SQL JOIN - it specifies the related table name, the linking attributes, and the join type. The condition element (D) is used inside either the main entity or the link-entity to apply filter…
Question
Options
- Aattribute
- Blink-entity
- Calias
- Dcondition
How the community answered
(49 responses)- A14% (7)
- B80% (39)
- C6% (3)
Explanation
FetchXML uses link-entity (B) to perform a JOIN to a related table, equivalent to a SQL JOIN - it specifies the related table name, the linking attributes, and the join type. The condition element (D) is used inside either the main entity or the link-entity to apply filter criteria (equivalent to a SQL WHERE clause), which is what 'filtered data from a related table' requires. The attribute element (A) specifies which columns to return but does not handle filtering. The alias element (C) renames output columns and is optional. Together, link-entity and condition are the two structural elements needed to join and filter a related table in FetchXML.
Community Discussion
No community discussion yet for this question.