Hi,
I would like to know what is the condition to enter for a field that is boolean betwen true or false.
No custom values I’ve used already existing parameteres like EXCLUDE_FROM_AS_BUILT in the product structure.
If the value is True I want to trigger the action. I tried with = or LIKE and also with ‘True’ ; True ; 1. But nothing seems to be working …
And the same thing for BOM_TYPE. I want to trigger the action while BOM_TYPE is equal to Manufactured.
Can you help me ?
Thank You
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.