Question

1
Replies
42
Views
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: 1 year ago
Last activity: 1 year 4 months ago
Closed

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 Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn