I am adding parameters to my SQL query.
When adding parameters, I use NVL.
NVL (Null Value) is a function used in the Oracle database. This function checks whether a value is NULL and returns a specified alternate value if the value is NULL.
Although my parameters are not empty, I have entered values that the system will return in case they are empty.
- Parameters
AND NVL (PAPF.PERSON_NUMBER, '1') =
NVL ( :P_PersonNumber, NVL (PAPF.PERSON_NUMBER, '1'))
AND NVL (HOUFL.NAME, 'x') =
NVL ( :P_Department_Name, NVL (HOUFL.NAME, 'x'))
AND NVL (PPNF.FULL_NAME, 'x') =
NVL ( :P_FullName, NVL (PPNF.FULL_NAME, 'X'))
AND NVL (HAPTL.NAME, 'X') =
NVL ( :P_PositionName, NVL (HAPTL.NAME, 'X'))
AND NVL (PLFL.LOCATION_NAME, 'X') = NVL (:P_LOCATIONNAME, NVL(PLFL.LOCATION_NAME, 'X') )
After adding to the query, my parameters have arrived. We check them all and proceed to the next step
Then pressed here
We are modifying the text displayed here.
In List of Values we are adding new column
I am entering my lists here. When writing my SQL query, I ensured that duplicate data does not appear by using DISTINCT
Then, from the Parameters tab, I selected the menu from the Parameter Type.
I choosed the Departmant list which I created
It is on my Data View Screen now.
It appears like this in my report
No Comments