Qrew LegendIt seems to me that this would be pretty straightforward with a Pipeline. He would figure out what your trigger is and that would be a on new event type trigger.
Then you would search the tags. Where is the tag number is between the starting tag in the ending tag
then you would have a For Each loop to create the join table records.
In theory, it is more efficient to create a bulk upsert right after the trigger step and then add rows to the bulk upsert and then at the end of the process commit the upsert, but if you're adding say 10 or 20 records, it will be fine be to do the for each loop to create the join table records.
Thanks Mark. I thought it was something like that, but I've been having trouble with the start and end tag search working properly. I will dig into it more and see if I can get it to work. Glad to know I'm on the right track at least.
@MarkShnier I'm trying both methods but the problem I'm having is the search for the tags. I obviously don't have the conditions set properly because the loop just keeps running. Should I be using an advanced query of some sort?
Qrew LegendCan you post a screen shot if your Search filters?
I seem to have stopped stopped the endless looping but am still stuck. As requested, I've attached a couple of screenshots of the advanced queries I've tried. They produce little to no results.
If I use an advanced query that utilizes the 'EX' function I can get one record to create with the [starting_tag] like I want to but I can't get more than one record created.
If I have one condition set in a normal query I can get one record to be created. The only multiple conditions that work are in the image below but because the conditions are start with and end with, I only create the starting tag and he ending tag. I just cant seem to get the conditions right to run from the starting tag to the ending tag and create records for the starting tag, ending tag, and all tags in-between the two.
