Question

3
Replies
751
Views
Aleksei Zorin (AlekseiZ)
I.T.Co.

I.T.Co.
RU
AlekseiZ Member since 2015 2 posts
I.T.Co.
Posted: December 6, 2016
Last activity: July 28, 2017
Posted: 6 Dec 2016 14:41 EST
Last activity: 28 Jul 2017 11:08 EDT
Closed

Incorrect sql query. How do I get Pega to generate correct SQL query using function alias in a report?

Hello!
1. I have a simple function alias which takes 2 parameters.

2. I have a report definition. One of the columns uses my function alias, and one of the parameters is a value from a joined table (using Declare-Index)

3. In generated SQL I see that Pega tries to read the blob of the joined table trying to retrieve the 1st parameter, which it doesn't have to do, because the value is exposed (it hasn't been exposed via Pega though, I manually mapped the columns in the Class Advanced tab)

How do I get Pega not to read values from a blob?

***Updated by moderator: Marissa to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Data Integration
Moderation Team has archived post, 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.