Create the database view for department field which is text field

[supriyabehe]

Create the database view for department field which is text field from question_answer table and sn_hr_core_case_talent_management.

Then create report where i can use this database view by showing hr cases by department field values which is text field. Please help me with clauses . Its not working what i used

[Ankur Bawiskar · Accepted solution]

@supriyabehe 

create a report with table name as that database view table

I believe I have answered your question.

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

[supriyabehe]

not working as expected

[supriyabehe]

Created but not working . Please see the attachment below