User-Defined Formula
User-defined formulas make it possible assign or derive quality results values. Values can be derived from user-defined formulas that are simple arithmetic expressions which use simple operators (+, -, *, /), specified values (3, 2, 4000, 'FAIL', 50), complex operators (square root, sin, cosine and so on), functions (SORT), and/or output variable tokens (&DEFECTIVE).
For example:
&D + SQRT(&DISCREPANCY)/SQRT(&E)
Values can also be derived from user-defined SQL scripts which read values from Oracle database tables.
For example:
select assigned_to from customer_reps
where customer_name = &CUSTOMER
and organization_id=:parameter.org_id
Attention: To constrain the SQL Statement to the current organization, you can use the variable ':parameter.org_id' for the current organization id. To constrain the SQL Statement to the current user's id, you can use the variable ':parameter.user_id' for the current user's id.
See Also