Why we get an error for selecting condition type as equals or starts with in Obj Browse for unoptimised property.
Why we get an error for selecting condition type as equals or starts with in Obj Browse activity method for unoptimised property. Whereas if we select condition type as Value Only we don't get an error for unoptimised property.
Please find the attachment for reference:
***Edited by Moderator Rupashree S. to add Capability tags***
OCBC
SG
Adding filter condition as "Equals" or "Contains" for an unoptimised property in obj-browse condition increases the performance as we have to look through all the results and filter based on the condition. whereas Value Only just fetches value of a specific record.
Cognizant
IN
@Priyanka_Konda so to fetch the value of a specific record also doesnt it should throw an error as its not optimised right?
Eclatprime Digital Private Limited
AU
Hi @TanyaS58, Obj-Browse can get the Blob data but it cannot execute conditions as there is no physical column. Thanks
Cognizant
IN
@KavyaKumariYegireddi for other conditions it throwed error but for value only it didnt why?
Updated: 7 Jun 2024 5:08 EDT
Rulesstack Private Limited
IN
Hi @TanyaS58,
An errors occur when using condition types like "equals" or "starts with" in the Obj-Browse activity method with unoptimized properties because these operations require the properties to be indexed in the database for efficient querying.
Key Points:
1. Unoptimized Property: - Stored in the BLOB column. - Not indexed, leading to inefficient full table scans for querying.
2. Condition Types - Equals and Starts With : Require properties to be indexed for efficient querying. - Value Only : Evaluates conditions in the application layer (in-memory), bypassing the need for database indexing.
Resolution : To use "equals" or "starts with" efficiently, optimize the property by exposing it as a column in the database table, allowing the database to perform efficient queries.
Thanks,
Mohd Qizer Uddin
Cognizant
IN
@Mohd Qizer Uddin so even if the property is unoptimised in that case also this value only will return a value right so for that it will not be searching from the database?
Accenture
GB
@TanyaS58 If you use Unoptimized Property as "Value Only" it will return the value from blob as long as it has a value as well as the entire blob content.
Regards,
Bharat
Updated: 14 Jun 2024 5:01 EDT
Rulesstack Private Limited
IN
@TanyaS58 for the optimised property search will be performed on that specific column instead of the BLOB column.
Cognizant
IN
@Mohd Qizer Uddin I didnt get this here,if its not optimised then how will a column be present for that property?
Rulesstack Private Limited
IN
Optimized Properties : Have dedicated columns in the database, allowing direct SQL queries and better reporting performance. - Non-Optimized Properties: Stored within a BLOB (Binary Large Object) in the database, requiring deserialization for access and not suitable for direct reporting.
Optimizing a property creates a new database column for it, improving query performance and reporting capabilities.
https://docs-previous.pega.com/system-administration/87/about-declare-index-rules
Cognizant
IN
@Mohd Qizer Uddin so for value only as a filter condition in obj browse how does pega stores that properties value in memory?which memory is it referring to?