Database view with a LIST collector variable

[Meenakshi Rajes]

Hi Team,

I've a query regarding creating the data base view by referencing a list collector variable.

I have created a list collector variable (by referencing the incident table) in the change table. 

It will contain more than one incident in the list type variable,

in this case is it possible to create a data base view by clubbing change and incident table to fetch the incident created time?

the variable I have created in the change table is below:

Thanks!

[Danish Bhairag2]

Hi @Meenakshi Rajes ,

I don't think so it will be possible because while creating database view & adding a where clause it expects a single record from 1 table should be present on another table.

But in ur case it can have more than 1 entry due to which it will be difficult to find that record n hence the view cannot be created.

Thanks,

Danish