How to add list collector of location in the approver table for if approver is the Contact

[Samiksha2]

Hi All,

I have a catalog item in which a variable is a list collector (cmn_location). 
In the location table I have added the contact for each location.
The flow is approver will go based on selected location's contact. (This is working).
The requirement is in the approver table that location should be populate for which contact is approving.

For example,
In the location table
Location 1 has User 1 contact

Location 2 has User 2 contact

Location 3 has User 1 contact

Location 4 has User 1 contact

And in the catalog item end user has selected Location 2, Location 3,Location4

In the Approver table, in the string value for User 1 Location 3 and Location 4 should populate and for User 2 Location 2 should populate.

The reason behind doing this is they want a report where stakeholder can see who approves which location.
I have created a database view for requested item and approver table.
But I am unbale to get the list collector values separately. 

If any other way to to do this, please let me know.

Thanks,
Sam
 

[Ankur Bawiskar]

@Samiksha2 

Hope you are doing good.

Did my reply answer your question?

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

[Samiksha2]

Hi @Ankur Bawiskar ,
No Ankur. Still that where clause is not giving the correct data.

Thanks,
Sam

[Ankur Bawiskar]

@Samiksha2 

As already informed I won't be able to spend much time.

You will have to check somehow how the indexof or search can be applied in where clause in database view.

I hope I was able to guide you and you can take it from here.

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

[xonox6]

any custom field to hold reference to cmn_location?

[Samiksha2]

Hi @xonox6 ,

I have created a custom string field in the approver table.