Project and Portfolio Management Practitioners Forum
cancel

PPM Center

Highlighted
BLE
New Member.

PPM Center

Hi,

I want to display the result of a SQL statement in a textfield in a request type.
How can I configure this, since the result of an SQL isn't text, but a table...

How can this be solved?

regards,
Bart
1 REPLY
Jim Esler
Acclaimed Contributor.

Re: PPM Center

In a rule, you can use something like the following:

select 'Your text [REQD.VP.YOUR_TOKEN]',
'Your text [REQD.VP.YOUR_TOKEN]'
from dual

You can select text based on a value with something like the following:

select decode('[REQD.VP.YOUR_TOKEN]','value1','text1','value2','text2','default text'),
decode('[REQD.VP.YOUR_TOKEN]','value1','text1','value2','text2','default text') from dual

You can even include html tags in the text field to modify the formatting of the text. For instance, color helps make warnings and errors stand out.