Hi,

There is a field aaa. I just want to fire a filter on modify with the condition that if there is a change in the value as well as is the same value is retyped an action should fire.

Is the run if qualification correct?

(('TR.aaa' = 'DB.aaa') OR ('TR.aaa'!= $NULL$))

Regards,
VANI.

use (('TR.aaa' = 'DB.aaa') AND ('TR.aaa' != $NULL$)) - to check value change.
or just ('aaa' != 'DB.aaa') will do.

to check for same value (no change in the value) you can use
('TR.aaa' != $NULL$ AND 'aaa' != $NULL$), the second condition is required coz if value changes and value is NULL your first condition is still true.

Jst out of curiosity...

A field value can either change or remain the same (There is no third possiblity)... So why wud u wnt 2 write a filter for this?
No qualification required, if you are performing same operation for both cases ...

Consider a scenario, that i have a menu in the field site,
whenever the value changes by selecting a value in the menu, site name should be populated through sql in field NAME. If i delete the values in NAME, and reselect the same value in site, i should get the names again. what could be the qualification given in filter to make this condition work?

('Site' != $NULL$ AND 'NAME' != $NULL$) should b d qual for Filter to set the field by SQL.

I would suggest U use Active Link for the same (Menu/Row Choice) and use the same SQL to set the field (Direct SQL is not recommended unless u r sure of the query)

I just need the basic run if qualification.
I have a sql query to set the site name.
I need to use only filters.
Is 'TR.SITE' != $NULL$ is enough?

'TR.SITE' != $NULL$, will work fine, unless the transactional value of 'SITE' is null.