Question
Lantiqx Systems India Private Limited
IN
Last activity: 5 Jul 2024 9:16 EDT
Postgressql query code
Hi All,
I have a case with Unoptimized property of .ABC and I want to fetch the list of case (case ID ) which is having the value of "Test" on the .ABC property. By using the postgressql query code in postgressql. How to frame the query code for this requirement?
Regards,
Prasad
Accepted Solution
Updated: 5 Jul 2024 9:16 EDT
Pegasystems Inc.
GB
@Prasad Reddy Muddam In PostgreSQL, unoptimized properties are stored in the BLOB column. Retrieving any property field value from the BLOB column is a costly DB operation and not recommended. However, if you still want to proceed, you would need to use a function to extract the value from the BLOB. Please note that this is complex and can lead to performance issues. It's recommended to optimize the property for such requirements.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
How to add unoptimized property in Report definition query tab