submit a catalog request by accessing and getting data from two different tables

[Aswanth Suraj]

Hello Community, 

I would like to access two different tables (both tables would have one column say 'name' in common).

Table 1 would have name and few other columns, Table 2 would have name and Application name.
I would like to get the name from Table1 and match it with Table2 and get the Application name from Table2 corresponding to the same name as of Table1 and then submit a catalog request via a flow designer, kindly suggest me a best method to do it.

Thanks in Advance!

[DrewW]

This is just a simple process of querying one table and then using the name from that table to get a record from the other.  Then you have to create a new Action that uses that data and the CartJS API to order the catalog item.

[Aswanth Suraj]

Can you please help me like what query to use and where it needs to be used

[Community Alums]

Hi Aswath,

How about you write on before Business rule on sc_req_item & condition for that catalog item and then get value of Table2 and update. 

If client needs to see before they submit the form, then you can use GlideAjax.

Hope this helped you. 

[Aswanth Suraj]

@Ankur Bawiskar can you please help.