Skip to Content
0
Sep 06, 2023 at 04:09 AM

Could you say generate the query to link those two tables in FSM with an array

93 Views

I have two tables in FSM called :

Table 1 is that of Person per

Table 2 is the Warehouse wh

Table 1 is the one for "Person per" I need to connect it with table 2 which is "Warehouse wh" with a JOIN and key is in the following field

per.refId = wh.owners[0]

As shown in the picture :

Table 1:

image.png

Table 2:

image.png

The problem is that since the "wh.owners[0]" field is an array, when executing the query, it does not allow the key to be generated in the query.


image.png

Could you say generate the query to link those two tables in FSM if that is your only link key?

Attachments

image.png (69.6 kB)
image.png (59.7 kB)
image.png (49.8 kB)