Survey HR Results table missing value in database view table

Jess4
Giga Contributor

Wednesday

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?

Jess4_0-1761722703641.png



Regards,
Anushka Mahajan

0 Helpfuls
  • 163 Views
6 REPLIES 6

Jess4
Giga Contributor
In response to brunoandrade

Thursday

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:

Jess4_0-1761824837517.png

 


Can you please suggest any other way to this?

0 Helpfuls

Jess4
Giga Contributor

Thursday

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

 

0 Helpfuls