Creating database view for sn_hr_core_case_talent_management table and question_answer table

[supriyabehe]

Creating database view for sn_hr_core_case_talent_management table and question_answer table. Added clause under question_answer table but its not fetching correct reports . Only i need department field value.

Please suggest with the correct condition

[Ankur Bawiskar]

@supriyabehe 

your where clause should be like this

&& qa_question == 'departmentVariableSysId'

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@supriyabehe 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[supriyabehe]

Its working fine with the records but in report it is showing empty

[Ankur Bawiskar]

@supriyabehe 

those values tr, teet, Global Services Division are values in that variable on record producer?

if yes then it's showing correctly

it might be showing empty because of the type of data visualization you added on workspace.

Did you try with other one?

If my response helped please mark it correct and close the thread so that it benefits future readers.