Skip to Main Content

Apex AB: Extract value of Number-Field and use the value as condition for another query

User_UN2PHJan 23 2021

I am new to the Apex AB and currently trying to solve the following problem:
Scenario: table employee with columns: staff_no ; name; salary; department_name
I want to create an input field where I write down an employee number, e.g. 124561 and as an output, I receive a hardcoded text with three variables, like the following: Employee [name] has a salary of [salary] € and works in the department [department_name]. (Procedure is visualized in the following picture)
My First Board - Frame 1.jpgThe problems I am facing now are:
How can I extract the value out of a number_field element?
How can I insert this value as a parameter for an SQL-condition, like:
SELECT name, salary, department_name
FROM employee
WHERE staff_no = input_field_value
The last step is how can I extract these three columns (name, salary, department_name) out of this SQL-Statement and insert them as parameters into a hardcoded text?
I would be happy if you could give me concrete tips on how to do it or guide me to the right resources that I have to understand to solve this problem!
Thank you and best regards

Post Details
Added on Jan 23 2021
1 comment