Posted: 26 Apr 2019 11:59 EDT Last activity: 14 May 2019 5:25 EDT
pxIndexPurpose in List view query for join Declare Index
We got an issue from a deprecated list view where the application is recently upgraded from v6 to v7.14 and then to 7.4. The list view is joined with a Declare Index named "AccountList" with prefix as "Acc". During the investigation we found as the declare index name ("Acc.pxIndexPurpose = 'AccountList'") also added newly after upgrade in where clause in the sql query generating by list view. Since the column 'pxIndexPurpose' is not available in pr_Index_Account table it fails to fetch the expected records.
select * from pca_work PC0 LEFT OUTER JOIN pr_Index_Account Acc where PC0.pxcreatedatetime>='01-02-2019' and PC0.pxcreatedatetime <='03-02-2019' and "Acc"."pxIndexPurpose" = 'AccountDetails'
Any idea why this reference "Acc"."pxIndexPurpose" = 'AccountDetails' is generating in v7.4 list view query and how to get rid of this?
I know the list view is deprecated but we can't change the list view's to RD in upgrade project due to the limited timeline. So any solution for this issue is appreciated.