Listview does not generate join
In listview is defined join, but when it is executed we see that in SQL there is no join condition and we do not get required information.
Same listview in other application works fine.
No error message
Steps to Reproduce
attempt to use join in the BulkProcessList listview.
The root cause is that the BulkProcessList listview is not using the standard getContent activity which deals with the join.
You will need to do some customization in order to use join with your BulkProcessList listview.
In fact, the listview BulkProcessList relies on listview BulkProcessFeeder.
BulkProcessFeeder contains the following comment:
Override if you need to add an additional column for retrieval (and you will need to override BulkProcessList in order to display it).
I was able as a test to use the join using the following steps:
- Adding the join in BulkProcessFeeder and retrieve pyID property as a test.
- Adding the join also in BulkProcessList
- Display the field in BulkProcessList