I need to update values in a table according to DatabaseTags values. The values are on different rows but in the same database field.
One idea was to introduce in the database a field named tag_name and than update the values with a custom SQL expression able to check the tag’s name and compare it with the value in database field tag_name.
It doesn’t works because:
Standard Transaction Groups doesn’t allow to have multiple items that write in the same database field (even if are on different rows).
One solution would be to have different Transaction Groups for each Database Tag but looks too complicate.
I don’t know how to write an expression in custom update Where clause that returns Tag’s name. There is somewhere a documentation of all objects that may be referred in such an expression?