Comparing fields values with other field values while creating queries in MKS Integrity 2009

[dkhosla]

Hi,

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.

[jgorsline]

Deepika,

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.

[jsummers]

Could you provide an example of this option in a report environment

[mrump]

Hi Joe,

<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.

</copy>

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

HTH Matthias