Hey @kaykydebrito,
Happy to hear this looks useful :slightly_smiling_face:
Let’s say you have a table named orders with a lookup field containing the products in the order. Your Sync Inc database will also have a table called orders with a column, products . products will be a text[] type in Postgres - a Postgres array of record IDs.
In your Sync Inc Postgres database, it will look like this:
products
-------------------------------
{rec8Uizjiakjx, rec98akjdiZUZj}
That’s just what text arrays look like in Postgres. In JSON, this would be: [ "rec8Uizjiakjx", "rec98akjdiZUZj"]
So, to find all orders containing a particular product, you would do this:
SELECT * FROM orders WHERE 'rec98akjdiZUZj' = ANY(product);
Or to get the first product in every order you could do something like this:
SELECT product[1] FROM purchase_orders;
We have a complete example in our our docs that you can use to get going quickly:
I am here so let me know if you need anything!
