Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Replace SQL text with Parameter
Migrateduser
<p>Hi All,</p><p> </p><p>I have an SQL query like below in one of the sub dataset</p><p> </p><p>SELECT pmsequence.pmnum, pmsequence.jpnum, PMSEQUENCE.INTERVAL, jobplan.description, jobplan.pluscrevnum, jobplan.orgid jorgid, jobplan.siteid jsiteid, jobplan.status,
jobplan.jobplanid,pmsequence.orgid, pmsequence.siteid
FROM MAXIMO.pmsequence, MAXIMO.jobplan
WHERE pmsequence.jpnum = jobplan.jpnum
and pmsequence.siteid=jobplan.siteid
AND UPPER(jobplan2.status) = NVL(UPPER(<strong>:prmjpstatus</strong>), UPPER(jobplan2.status))
</p><p> </p><p>I created parameter prmjpstatus . What is the process to replace <strong>:prmjpstatus</strong> with parameter value at run time...</p><p> </p><p>Any help...</p><p> </p><p> </p><p>Thanks.</p>
Find more posts tagged with
Comments
There are no comments yet