New column in Assignment table does not appear in Reports

General
, , , ,
1

Hello there,

We added and exposed a property in Assign-Workbasket class. This property is updated every time pxDeadline is changed using a Declare Expression. However, when we run reports on Assign-WorkBasket class we don’t see this new column populated in the report. We do see the data in Assign-WorkBasket table though.

Thanks in advance for your time.

Regards

Nadeem

2

Hi @NadeemM8116 , I faced a similar issue before for a different table. Re saving the database class mapping(Records–> SysAdmin–>Database Table) helped resolve this issue. kindly try it once if already haven’t.

3

Thanks @RADHAKRISHNA-1 for your reply.

I tried it but it didn’t work. The only option I see now is to recycle the server and see if it works.

Regards

4

@NadeemM8116

Can you please clarify whether the value is not stored in the column or the new column doesn’t exist in the report?

5

@RameshSangili thanks for your query.

I can see the value when I open the instance in XML. However, I don’t see the value when I run the query using query runner. The column is there in the report but it comes out blank. One more piece of information. The issue is happening in our QA region, it is working fine in Dev environment. While deploying the code in QA region we initially deployed the property to QA and a couple of days later we deployed the DB Table instance to modify the schema. I wonder if the issue is due to this two-step deployment.

Regards

6

@RameshSangili, @RADHAKRISHNA-1 ,

Thanks for your time you took to respond to my query. The issue seems to be resolved after recycling the environment.

Regards

Nadeem