Hello Again,
I have a (custom solution) with a header node (Customer Info) and a subnode for Contracts (with -From and -To date fields).
I have created an SADL query used in the Advanced filter with selection fields mapped to the -From and -To date fields.
When executed, the system correctly filters the header node and shows only the Customer lines where Contract -From and -To match the selection options. But I am unable to only show the relevant lines from the subnode (Contracts) at the same time.
The query can only point to the main overview table as the result list (sub node is not available to select)
How can I filter the header and subnode tables at the same time with only one advanced filter?
Sub node Contracts Advanced List pane should filter without the marked lines as follows:

The SADL query is as follows:

Hope someone can help!
Best Regards
Jay
Request clarification before answering.
| User | Count |
|---|---|
| 14 | |
| 12 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.