Hi,
there is a collection “invoices” with following fields:
id, invoice_date, lot_id (M2O-Relationship: lots.id)
and there is a collection “lots”:
id, member_id (M2O-Relationship: org_unit.id)
Is it possibly to set a GetData-Query with a filter by “invoice_date” and “member_id”?
like: Get invoices data
“filter”: {
“_and”: [
{
“invoice_date”: {
“_eq”: “{{run_script_read_data_invoice_selection.invoice_date}}”
}
},
{
“deep?”: {
“lots”: {
“member_id”: {
“_eq”: “{{run_script_read_data_invoice_selection.member_id}}”
}
}
}
}
]
}