My app has the three entities Pharmacy_Contact, Pharmacy_History, and Pharmacy_Action. When a history record has been created or updated I need to cycle through all history records for the contact, get the action record associated with the history record, then finally update a status in the contact record with a computed value. In list records I'm unable to construct the filter query correctly. The schema name for the field is dhs_Contact and the display name is Contact. It is a look up field. In the dynamic content list the history fields are enumerated. I assume I should choose Contact and have it place that in filter query, follow with eq, then whatever value is passed from the trigger event. I can't figure out how to get the value to put after eq. All history records returned will have the same contact value, and, it will be the same contact value of the history record changed by the user. See attached screen snapshot.
*This post is locked for comments