Update Workflow repository Bug?

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

Your condition is wrong. You don’t need to specify a lookup() in there, you simply need to specify a SQL-like statement. In your case, it would be:

Type='abc'

Thank you for the clarification. You’re right , that did the trick .