two tables in list collector variable

[Hafsa1]

I have a list collector variable which fetch values from "cmdb_sam_sw_install" table. Can we have another table(samp_sw_subscription) added to this list collector variable? In "install" table "user" field is available and in "subscription" table "assigned to" field is available. Purpose is to show the software +software license for user/assigned to person in one of the catalog item .

[Ankur Bawiskar]

@Hafsa1 

not possible

List collector or reference variable always point to single table

You can try this, I never tried this

-> create database view by joining both the tables based on common fields

-> then make your list collector point to that database view table

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