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
  • 139 Views
6 REPLIES 6

jcmings
Mega Sage

Wednesday

First guess is an ACL issue. Use the Security Debugger and see what errors pop up.

0 Helpfuls

brunoandrade
Tera Contributor

Wednesday

This behavior usually occurs when the Database View is not joining the source tables correctly, or there’s an issue in the WHERE clause of the join.

 

Here are some points to check:

  1. Database View Relationships:

    • Verify that the tables are being joined correctly.

    • Make sure the fields used in the join actually exist in the source tables and have matching data types.

  2. WHERE Clause:

    • Check that the WHERE clause is written correctly, without unnecessary spaces or extra characters.

    • Incorrect spacing or slightly different field names can prevent certain columns from displaying properly.

  3. Included Columns:

    • Ensure that columns such as “Actual Value” and “Country” are properly configured and available in the Database View.

After adjusting the join or correcting the WHERE clause, save the Database View and test the report again to confirm that the fields appear correctly.

 

If this answer helped you, please mark it as Helpful ✅ so the community can easily identify it as the ideal solution. 

0 Helpfuls

Jess4
Giga Contributor
In response to brunoandrade

Thursday

Hello

Thanks for your response.

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:
hrc_sys_id=asmti_trigger_id and asmti_sys_id=asmtr_instance.

Can you please suggest any other way to this?

0 Helpfuls

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:
hrc_sys_id=asmti_trigger_id and asmti_sys_id=asmtr_instance.
Can you please suggest any other way to this?

0 Helpfuls