Event Action Condition True/False

Hello.

DOM_TYPE=’M’ instead of ‘Manufactured’

In your tests, don’t consider tests such as ‘Manufactured’, ‘Released’ and such as they change according to the user language, eg, ‘Manufactured’ in french becomes ‘Fabriqué’, ‘Released’ becomes ‘Libéré’, …

About checkboxes values, they are always set in upper cases and their values are generally either (null), TRUE or FALSE.

To know their exact values, don’t run queries on the view but on the table

Note that events are triggered on tables and therefore, the columns contain the db value, not the client decoded language as @romsar indicated.

You can probably look up the API documentation for the enumerations if you’re not sure what the db values are, or of course you can just do a select statement for say dom_type_db from the view itself to see the equivalent table values for said enums :)

Also note that Oracle SQL as used by IFS does not have True Booleans in Columns, they have a varchar2 interpretation of TRUE/FALSE (as strings), so in tables where you expect a true or false, the column will be set to varchar2, the value in the table will be recorded as TRUE or FALSE, and the Client Value will be decoded through enumeration FndBoolean, which (in english) will translate to “True” or “False”, and for instance in French to “Vrai” and “Faux”

As events are always triggered from table value, your condition would be “= TRUE” for instance.