Support Article
Listview does not generate join
SA-2132
Summary
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.
Error Messages
No error message
Steps to Reproduce
attempt to use join in the BulkProcessList listview.
Root Cause
The root cause is that the BulkProcessList listview is not using the standard getContent activity which deals with the join.
Resolution
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
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.