How can I show/hide many text item field from Table?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
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.
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;
Is :P13_DEPARTMENT_ID comment? or what?
In WHERE clause you use different quotation marks
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;
Item=Value, Item is Null is Not working here.
You can try with PL/SQL Expression
Try this code:
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