Question
Infosys
US
Last activity: 29 Dec 2024 6:28 EST
When I try to retrieve the property, it is resulting in no value as output in report Definition
When I try to retrieve a value through a query runner, I am getting results, but when I try to retrieve the same property, it is resulting in no value as output in report Definition.
To verify that same property, I have added filters and added a condition with not null. I am receiving records, but the same property, when I added it in the query, is showing no values.
How to fix the issue?
Updated: 26 Dec 2024 2:45 EST
Pegasystems Inc.
IN
@roshanalibabas Can you please share the query you ran in the Query runner ?
Also please fetch the DB query using the tracer while running the RD and compare it with the query ran using runner?
Infosys
US
@bathv SQL Query:
SELECT pyUserIdentifier, pyUserName, ProducerGLNString FROM pegadata.pr_operators WHERE ProducerGLNString IS NOT Null;
DB query:
SELECT "PC0"."pyuseridentifier" AS "pyUserIdentifier" , "PC0"."pyusername" AS "pyUserName" , "PC0"."producerglnstring" AS "ProducerGLNString" , "PC0"."pzinskey" AS "pzInsKey" FROM pegadata.pr_operators "PC0" WHERE ( "PC0"."producerglnstring" IS NOT NULL ) AND "PC0"."pxobjclass" = ? ORDER BY 1 ASC
Maantic Inc
IN
Can you trace the report and check what are the value getting passed in the SQL query filter params?
Pegasystems Inc.
IN
Both SQL looks same and it should work. Please try revalidate and save of RD and then check the outcome.
Tata Consultancy Services
IN
Infosys
US
@Bhumireddy Hi,
With OBJ-Browse ==>I am getting values. no issue with Obj-Browse. With RD ==> Same issue, resulting no values.
Thanks,
Roshan
Accenture
IN
Hi @roshanalibabas, Can you check whether you are receiving values if you remove the filter condition.
Infosys
US
@GiridharanVenkat I have checked with no filter condition as well, but no luck. It is not working
Accenture
IN
Is this property recently optimized?
Infosys
US
@GiridharanVenkat Yes, but after optimization, I have tried to update value for couple of records.
Accenture
IN
Assuming that this and all are old cases, since you optimized now . A new column is created in the table and it doesn't hold any value. you would need to execute recreateindex activity for that. After that you try to run the report , this time it will be bring the data from db.
Updated: 29 Dec 2024 6:28 EST
Tata Consultancy Services
IN
---> When I try to retrieve a value through a query runner, I am getting results, but when I try to retrieve the same property, it is resulting in no value as output in report Definition.
--> To verify that same property, I have added filters and added a condition with not null. I am receiving records, but the same property, when I added it in the query, is showing no values.
@roshanalibabas He mentioned above that he was able to get the results/values while executing the query in the query runner. That means values available in the DB, Query Runner will bring the values from the DB, not from the BLOB. If aer you using the Stream Function, then only values will come from the BLOB, otherwise it will bring the DB Table.
Thanks,
Ashok