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! 🙏

[Ankur Bawiskar]

@Hafsa1 

Hope you are doing good.

Did my reply answer your question?

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

[Hafsa1]

@Ankur Bawiskar 

is it possible in database view that it will show all values of install table where user field is notNULL and all values from subscription table where assigned_to is notNULL. It is asking to join both table with common value. It is possible without that?

[Ankur Bawiskar]

@Hafsa1 

database view means you are joining 2 or more tables based on some common value.

Without this it's not possible to create Database view

In your case if nothing is common then database view won't help

You can discuss your requirement with customer and have 2 variables.

1 pointing to install and other pointing to subscription table

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