Support Article
List view not working after adding joining with table
SA-26665
Summary
User added join condition in list view when user runs the list view from a summary view to check the detailed view, incorrect SQL query is generated at report page.
Error Messages
There was a problem getting a list code:936 SQL State: 42000 Message: ORA-00936: missing expression.
Steps to Reproduce
Add join conditions in list view and run the list view from a summary view to view the detailed view.
Root Cause
Incorrect query generation when list view has multiple joins with the first one being an external class.
Resolution
Apply HFix-28484.
Published August 23, 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.