I am trying to create a query in MKS Integrity 2009 and i want to put a filter which says that modified by=assigned resource.
I can achieve this in triggers but how can i achieve the same while creating a query?
Also, can i add rules to the scheduled triggers in mks integrity 2009.
It is not really possible to do a field to field compare in a query. This is done in a report where you can set up computed fields to do advanced data manipulations like computed fields and compares.
Could you provide an example of this option in a report environment
<copy from the client help sites>
You can compare two user fields in a computed expression, for example, “Assigned User” = “Created By”. A logical value or true or false is returned.
so as Jeremy already said you create a query, or if this "filter-rule" is used often your design you could create a computed field and add it to you type, like
fieldname : "was last modified by assigned User ?"
description: "contains a 1 if the last mdification to this item was performed by the asigned user"
computation : isEmpty ( ("modified by"="assigned resource")?1:0, 0);
computation type : dynamic
Then you can query on all items having value 1 in this field