In the Repository i've got one group Called 'archive'.
I've added two keys: 'number' and 'Type'
The two key-sets i've made are as followed
Id number Type
1 100 abc
2 200 xyz
In the workflow a mathematical operation
expression:
lookup(archive, number, Type, 'abc') + 1
and store this in a local variable %{number}
next step in Workflow: Push to repository
Group = 'archive'
in the keyset
Key = number
value = %{number}
update checkbox = marked
Update based on checkbox = marked
condition = lookup(archive, ID, Type, 'abc')
When i run this workflow the log contains
- %{number} set to value 101
- Update values in group 'archive' where "1"
Opening the repository, i see that field 'number' in record with id 1 is set to 101
also field 'number' in record with id 2 is set to 101
any suggestions