Survey HR Results table missing value in database view table

[Jess4]

Hello team,

We have encountered an issue where we have a report which is having a database view table where users are unable to see report columns such as "Actual Value," "Country," etc.

However, they can view those values in normal tables but not in the database view table, which is "u_survey_results_related_to_hr_case."

I have attached a snapshot for your reference. Could anyone please assist with this matter?

Regards,
Anushka Mahajan

[Jess4]

We have checked for all the pointers mentioned.
The tables are joined correctly and also the fields are present in the source table.
We also checked for the WHERE clause and WHERE clause is written correctly, without unnecessary spaces or extra characters.
This is the clause for your reference:

Can you please suggest any other way to this?

[Jess4]

Hello,

Thanks for your response.

We have checked with the pointers you have mentioned.

We have checked and found that the tables are joined correctly and also the fields are present in the source table

WHERE clause is also written correctly, without unnecessary spaces or extra characters.
This is the where clause for your reference:
hrc_sys_id=asmti_trigger_id and asmti_sys_id=asmtr_instance

Can you please suggest any other option for the Same

[Agarwal_Vartul]

@Jess4  - Wanted to check if you got solution to this? The same is happening with me too as soon as I add HR Case table to the database view, the survey results fields go blank.