Forum Discussion

Qrew Member

3 years ago

Pipeline to Pre-fill a many to many table triggered by the addition of Parent Records

I have a many to many table that includes a distance value between 2 related parent table records. When either a Parent 1 or Parent 2 record is added I want to create a record in the many to many tabl...

Pipelines

MarkShnier__You

Qrew Legend

It will be two separate pipelines.

Pipeline 1
Trigger on Parent 1 Created.
Create a bulk upsert
Search all Table B Records.
For each loop - add upsert row (creating those middle join records)
Then outside the loop .. commit upsert.

Then similar but opposite for Parent 2 created.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

GeorgeBramhall2

Qrew Cadet

3 years ago

Worked like a charm! Pretty powerful stuff. Thanks

------------------------------
George Bramhall
------------------------------