Posted: 24 Nov 2019 12:30 EST Last activity: 26 Nov 2019 15:27 EST
Does Listview Malfunctioning the query - Caused Slowness
Listview rule is defined with two filters to fetch data from DB table and display the results in UI. This list view was generating a query that was missing the indexed column “pxCoverInsKey” in the select query and only considering the non-indexed parameter “pyStatusWork” resulting in slower response.
WHERE "PC0".pxObjClass = ? AND ( ( "PC0".PYSTATUSWORK LIKE ? ) )
Suspecting that Listview rule is malfunctioning the query and caused the issue. what are the possibilities caused the issue?
Planning to introduce Report definition rule with Listview rule, is there any chance the same situation will arise with report definition rule?
Compared to Listview rule Is there any performance improvement with report definition rule?
Just to confirm, you had a list view with an OOTB getContent activity, where even though the filter conditions included pxCoverInsKey, it was not included in the WHERE clause? If this is the case, it sounds like a bug.
The query generation code has changed substantially for report definitions relative to list views. There is no longer a getContent activity involved. All query generation has moved into the engine code. While I can't predict whether a specific report will have a bug in its query generation, I would be very surprised if the same bug showed up.