I’m trying to traverse a lookup field to display that lookup’s Attachments in a table. Is this possible? Here’s a bit more detail:
I have object ConsultationMedRec with lookup to object MedRec. I have a ConsultationMedRec table. I would like to display MedRec Attachments within the ConsultationMedRec table.
It looks like I can’t “trick” the XML to query the child of a lookup, so I’m wondering if this is possible using a custom renderer.
Thanks for the help!
Question
Display Child Records (Attachments) of Lookup within Table
+8This topic has been closed for replies.
+17- Nintex Employee
I don’t think you are going to be able to retrieve “Children of the parent” fields within a single model. I’m not a DBA but I’m thinking this is a limitation in SOQL, rather than just somthing that Skuid can’t do.
But what you can do is create a drawer under your ConsultatinMedRec rows. In that drawer you can include components bound to other models. The “before load actions” can be used to limit the attachments model to the ones associated with the parent of the MedRec rows. (see our drawer tutorials for more information).
Not exactly what you asked for, but perhaps satisfactory…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.