How can I show/hide many text item field from Table?
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
pavlos
Hi!
You can use Server-side Condition to hide item based on condition.
Click on your item, then in right pane (Property Editor) you can find Server-side Condition section.
Also in the right pane, in the Identification section, you can choose the item Type: Hidden. This way the item will not be displayed.
If that doesn't solve your problem, please add more details.
Shimul
Can't get the job done by Server Side Condition.
declare
v_last_name varchar2(1);
begin
select last_name
into v_last_name
from employees
where DEPARTMENT_ID ='2';-- :P13_DEPARTMENT_ID;
if v_last_name = 1 then
return true;
else
return false;
end if;
end;
pavlos
Is :P13_DEPARTMENT_ID comment? or what?
In WHERE clause you use different quotation marks
Shimul
i want to create a employee entry screen.Which will be filtered by the department.Department Id 1 Will Show Employee_id,Last_name,Hire_date, Department_id 2 will show Employee_id,First_name,Salary,Commission_pct. At First I created a setup table (Employees1). If the value of the column is 1 then the Item will show and if the value of the column is 0 then the Item will not show.
By SQL I create a form:
Select employee_id,last_name,hire_date,salary,DEPARTMENT_ID from employees1
WHERE DEPARTMENT_ID=:P13_DEPARTMENT_ID;
THEN Column Server Side Condition :
declare
v_last_name varchar2(1);
begin
select last_name
into v_last_name
from employees
where DEPARTMENT_ID ='2';-- :P13_DEPARTMENT_ID;
if v_last_name = 1 then
return true;
else
return false;
end if;
end;
Shimul
Item=Value, Item is Null is Not working here.
pavlos
You can try with PL/SQL Expression
Try this code:
najeeb Alikhel
you can just simply use DA and change event and use client side action
item =yes, or no
for yes true action should be created to hide all items you have to specify