I have the following SQL query called new_matter_claim stored in the resource library:
INSERT INTO claim(claim_id) VALUES({{uuid_var}});
When I go to the query instance and manually type in a value to pass into uuid_var, it works fine. I then created this JS query:
new_matter_claim.trigger({additionalScope: {uuid_var: '123456'}})
When I run it, it says the query ran successfully but it did not write to the database.