I've created two nodes in the data model and here they are being mapped to the data source in the model mapping. The upper one, ProjectDocuments, contains filtering on attachments to projects, filtering out all attachments with a specific TypeId ("Referens"). The child node, Note, is connected to the attachment field Notes.
The problem here, I suspect, is that when binding to these objects in the format, the Note node is providing information that does not match the filtering done by the WHERE-function. I get the Notes-field values from a record with a different TypeId than I have filtered for. I suspect this might be because I couldn't use the relative path ("@") so the Note-node value isn't actually connected to the filtering in the record list in the parent node, ProjectDocuments.
Does anyone have any suggestion why the relative path ("@") won't be populated in the formula editor, or any other explanation why the Note-node doesn't follow the filtering I'm trying to do in the ProjectDocuments-node?
The two nodes visible in the model mapping's data model area.
ProjectDocuments-node: formula used for filtering out attachments with certain TypeId-value:
WHERE(ProjInvoiceJour.'<Relations'.'ProjInvoiceLinesUnion.ProjInvoiceId'.'>Relations'.ProjId.'<Relations'.'<Documents', ProjInvoiceJour.'<Relations'.'ProjInvoiceLinesUnion.ProjInvoiceId'.'>Relations'.ProjId.'<Relations'.'<Documents'.TypeID = "Referens")
Note-node: formula used in child node for presenting Notes-value from project attachments from the above filtering:
ProjInvoiceJour.'<Relations'.'ProjInvoiceLinesUnion.ProjInvoiceId'.'>Relations'.ProjId.'<Relations'.'<Documents'.Notes
Formula editor for the Note-node with empty relative path field:
I would expect the relative path to be filled in from the parent node. Maybe the Where-filtering is inactivating the relative path? If so, how can I perform filtering of subnodes to the node with a record list using a Where-call?
