troubleshooting Question

Oracle HTML DB - Multi Select filter region (form with report)

Avatar of ImraneA
ImraneA asked on
Oracle Database
6 Comments1 Solution498 ViewsLast Modified:
Hi there

I'm new to this area...

problem :- No data shown...after clicking on button

Details:
Table --> Equipment field --> Data appears as --> 1:2:3:5

2 regions (html, form with report)

region 1 (P12_EQUIPMENT --> multi-select object)
SELECT description a, EQUIPMENT_ID   FROM obe.cis_equipment

Chemicals,1
Electrical,2
Evaporator,3
Fabrication,4

region 2
Source -
'select CIP_NUMBER, To_Char(CIP_NUMBER,'0000') "CIS NUMBER" ,
TITLE,
FEEDBACK_TYPE,
FORM_NUMBER,
PROJECT_NUMBER,
DESCRIPTION,
equipment
from obe.CIS_DETAILS A
WHERE instr(':'||:P12_EQUIPMENT||':',':'||a.EQUIPMENT||':') > 0'

welcome any  comment....



ASKER CERTIFIED SOLUTION
Naveen Kumar
Production Manager / Application Support Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros