Home > Software engineering >  Return a value based on a function in placeholder in oracle Apex
Return a value based on a function in placeholder in oracle Apex

Time:06-17

Sorry if this is a "stupid" question, but I am new to Apex.

I made 2 processes on the create button: one is to insert into the department table and the other one to send an email with some info, among them the department too. I made an email template and I want to display the department name, not the id which is inserted into the table. So I thought, that maybe I can do that with a function, like in the picture attached(get_department_by_id - returns the name of a department).

[example][1] [1]: https://i.stack.imgur.com/bjBag.png

CodePudding user response:

The help function in the builder usually gives enough info. Here is the help for "Placeholder values"

enter image description here

So only Application, Page Items and System Variables are allowed.

Note: There are multiple places in APEX where you can pass a number of arguments (links, branches, etc) but nowhere the use of functions is allowed.

CodePudding user response:

This is how it worked for me. I created a computation, with the computation of type "Expression" with source get_department_by_id(:P7_ID_DEPARTMENT) and Condition Type "Request = Expresion 1" with source the name of the button(ex.create). Thank you Koen Lostrie for the guidance!

  • Related