Hi,
I have a problem with a left list. I want to add a field in a left list which consists of the BPADDRESS fields POSCOD and CITY. ([F:BPA]POSCOD-[F:BPA]CTY). Only the default address should be shown.
In order to only shown the default address I added a selection option:
I tried two things to add the mentioned field in the left list.
Attempt one:
In the environment section I added the BPADDRESS table to my object with the corresponding join expression:
In the selection section I added the expression to show the field:
Problem: The field was shown with this attempt, but no data is shown.
When I run a sql query with the same Join Condition I get records.
I found an object with a left list which has also linked multiple tables and which uses as a field combined of two DB attributes. There it works. I found no difference with my attempt.
Attempt two:
I added the mentioned field with a return value of a function:
The function looks like this:
Problem: Data (POSCOD - CTY) is returned, but the left list is not filterable with this attribute.
Can everybody help me? What do I wrong?
Thank you very much for your help.
Kind regards