Question
Accenture
JP
Last activity: 16 Mar 2016 1:13 EDT
Exposed column value is missing
This is a question about exposed column.
I exposed a column to use values in Report.
We can get values from BLOB( We can see them in Clipboard), but we can get only blank from exposed column.
I think that BLOB and Exposed column should have same value.
Can anyone tell me how to solve this problem?
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Accenture
JP
We had same name column like following. If we save same value for both column, we can get value.
<example>
ExampleA.aaa
ExampleB.aaa
We decided to save same values to two column.
Thank you for your help, but I hope that we will find root cause and right solution.
Pegasystems
IN
Did you use optimize for reporting to expose the column?
Can you try using this utility? - https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm
Accenture
JP
I tried that utility, but it didn't work. Process ended without error, but values are still blank.
Does anyone have a idea to solve this problem?
JPMC
IN
Hi,
How about the new data , are they getting saved in the exposed column and only issue is with old data (for existing WOs)?
Accenture
JP
This issue is for both old and new data.
All value in the colum is blank.
To expose the column ,did you use optimization wizard or by running DB script ?
Accenture
SG
hi Sato,
Is the value coming blank in Report definition outcome ? or the data saving as blank into the new column exposed ? In these cases try below thing as exposed column might not be reflected to the database Table Class
Try Rebuilding the class mapping through Sysmgmt---->Advanced----->ClassManagement--------->RebuildClassMap.
-
Geeta Shalini Bezawada
Accenture
JP
Value blank coming from Report definition. we can see value in BLOB, but we can only see blank in report and table.
I tried Rebuilding class mpping , but reports still have blank.
Accepted Solution
Accenture
JP
We had same name column like following. If we save same value for both column, we can get value.
<example>
ExampleA.aaa
ExampleB.aaa
We decided to save same values to two column.
Thank you for your help, but I hope that we will find root cause and right solution.