Empty rows for .pystatuswork in a report definition
I have a report containinng 2 columns: .pyID and .pystatuswork of a defined class: MX-FW-CSFW-WORK-MODULEMAPTEMPLATE
In the database, both fields are well-populated. When running the report, I can only see records with pystatuswork = 'New' , the rest contain empty values of pystatuswork, I have run my trace, took the SQL generated behind this report and run it in DB, all values are well retrieved.
Can you please help?
***Updated by moderator: Lochan to add Category***