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

[supriyabehe]

I checked with different type still its showing empty

[supriyabehe]

yes, I tried but showing same as empty

[Ankur Bawiskar]

@supriyabehe 

please answer my earlier question

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

can you share what happens when you click Try it in database view?

Does it show correctly?

[supriyabehe]

those values tr, teet, Global Services Division are values from department field. After clicking tryit, apart from hiring an employee hr service other hr services also coming. But i want only from hiring an employee hr service