In this step you choose how you want your read only field to get its data.
Choose one of the types Reference, Select and Expression.
Type | Description |
---|---|
Reference | Select a path of foreign keys to the attribute you want to display. |
Select | Enter a select statement that selects the value you want to display. |
Expression | Enter a PL/SQL expression that fetches the value you want to display. |
Actions
Name | Description |
---|---|
Reference Path | Select a tree node in the reference browser to the attribute you want to display. |
Actions
Name | Description | Comment |
---|---|---|
Arguments | Enter the arguments that should be passed to the method generated for the select statement. |
Arguments will be passed to the method in runtime, and must be
separated with a comma. Arguments can be fetched from:
|
Select Statement | Enter a select statement that selects the value you want to display. | The select statement must have the same number of bind variables as the number of arguments. Bind variables are prefixed with a colon. |
Method Signature | Read-only value that displays the signature of the generated method | You can use this signature if you want to call this Custom Attribute from another Custom Attribute. |
Note. Only arguments from underlying table, prefixed with "t.", can be used when creating a read-only field on a Custom Logical Unit.
Actions
Name | Description | Comment |
---|---|---|
Expression Statement | Enter a PL/SQL expression that fetches the value you want to display. | You can use valid PL/SQL expressions with predefined PL/SQL methods, computations and IFS Application methods. To use values from the current record in the expression, reference the attributes in the view. Using the "v." prefix is optional. |
Method Signature | Read-only value that displays the signature of the generated method. | This is the signature of the generated method, you can use this signature if you want to call this Custom Attribute from another Custom Attribute. |