Brother this query fetched all child records of child entity but i want to fetch only child record of parent record not all records so cooperate me please.
I am also trying following but error occurs due to highlighted text
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="ci_audit">
<attribute name="ci_auditid" />
<attribute name="ci_name" />
<attribute name="createdon" />
<attribute name="ci_questionnaire" />
<attribute name="ci_officersignature" />
<attribute name="ci_auditdate" />
<attribute name="ci_asset" />
<order attribute="ci_name" descending="false" />
<link-entity name="ci_auditresponse" from="ci_audit" to="ci_auditid" link-type="inner" alias="aa">
<attribute name="ci_auditresponseid" />
<attribute name="ci_name" />
<attribute name="createdon" />
<attribute name="ci_questionnaire" />
<attribute name="ci_question" />
<attribute name="ci_compliance" />
<attribute name="ci_audit" />
<attribute name="ci_answer" />
<order attribute="ci_name" descending="false" />
<filter type="and">
<condition attribute="ci_audit" operator="eq" uiname="Audit 1" uitype="ci_audit" value="ci_auditid" />
</filter>
</link-entity>
</entity>
</fetch>
Error is Following:
"An exception System.FormatException was thrown while trying to convert input value 'ci_auditid' to attribute 'ci_auditresponse.ci_audit'. Expected type of attribute value: System.Guid.Exception raised: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx)"
