Close popover
Arun kumar (Arunk138)
HCL Technologies

HCL Technologies
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: April 26, 2019
Last activity: May 14, 2019

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.

sample query:
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.

Thanks in advance..

Reporting System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.