Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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?
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689966000/18c433f8-1e18-4340-81ce-2be99ef4528f.jpg?itok=rBmW0AVs)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689966000/18c433f8-1e18-4340-81ce-2be99ef4528f.jpg?itok=rBmW0AVs)
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)?
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Accenture
JP
This issue is for both old and new data.
All value in the colum is blank.
![](/themes/custom/pegacc_theme/images/user-icon.png)
![](/themes/custom/pegacc_theme/images/user-icon.png)
To expose the column ,did you use optimization wizard or by running DB script ?
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
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.