Question
HCL Technologies
IN
Last activity: 16 Feb 2018 6:21 EST
Expose value list property
I need to expose a valuelist property which is having more than 5 values in each row in table. How the values will retain after expose the property? Would it be retain by CSV or any other format? Is it right approach to expose a value list property from blob? Thanks in advance.
Pegasystems Inc.
US
Hi Arun,
As per my understanding it will create a different table and data need to be accessed in the same old way. No change at the app layer if its exposed or not, it is purely performance related thing.
If it is frequently used and stores large values then i would suggest you to expose it which improves the performance, otherwise it is not required to expose.
Hope this information might be helpful to you.
Regards
Mahesh
HCL Technologies
IN
Thanks for your suggestion Vijay. My query is not related to performance, it's about how the data's in value list retain/ display in exposed column after expose it from blob.
for eg,;
A value list of property .Prop
Prop(1) = One
Prop(2) = Two
Prop(3) = Three
Say currently it's in blob, after expose this property how it'll retain in exposed column? Hope you understand.
Pegasystems Inc.
US
As per my understanding it might be stored in the index table once you expose it.
S & P Global Inc
IN
If you expose the value list property, each value in the value list will become a row in the indexed table with different pxIndexCount value(if the value list contain 3 values then 0,1 and 2). Where pxInsIndexedKey, pxIndexCount and pxIndexPurpose are keys of your index inherited class. There should be at least one single value property in the index class mapped table to hold the each values of your value list property. The mapping of value list property to single value should done in declare index rule.
Pegasystems Inc.
IN
You cannot expose a value list property.
Pagelist property when exposed will be mapped to a index table.
Accepted Solution
de Volksbank
NL
Hi, - There is no option to expose value list property, you can expose the page list property - then it will create the index table.
Regards
Gouri Shankar K
HCL Technologies
IN
Got it, thanks all for your suggestion