DATA base view

[Shabbir1]

HI team,

We have two ticket tables ( 1 HR and 2. payroll) requirement is to show two tables tickets into one list. Opened for is common field which is referring to user table in both tables can we use that ..?can anyone help to create data base view step by step process confused about "where clause" field in data base view or any other best solution

[Ankur Bawiskar]

@Shabbir1 

something like this

Order	Table	Prefix	Where clause
100	HR Ticket table	hr
200	Payroll Ticket table	pay	hr_openedFor = pay_openedFor

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Shabbir1]

Hey @Ankur Bawiskar , 

Thanks for your quick response i have tried this but i am getting only one hr table records by using this sharing screen shot for reference

[Ankur Bawiskar]

@Shabbir1 

field name is correct i.e. opened_for in both the tables?

try with small prefix upto 3 characters

[Shabbir1]

Now i am getting the both tables data @Ankur Bawiskar could you please give me some info on my below query

in the list view its mixed up with both tables data how can assignee know which is payroll related data and which is hr related data if they want to download the excel report..? sharing screen shot for reference