AnsweredAssumed Answered

Portlet suppressing empty spaces from NSQL

Question asked by Jack on Sep 30, 2010
Latest reply on Sep 30, 2010 by Dave
Hi,
I'm trying to add several space between hard-coded value and query output data on the same row of a portlet. However, Clarity suppressing the blank spaces. I'm using the below NSQL query in my portlet.
select 
@SELECT:DIM_PROP:USER_DEF:IMPLIED:TASK:rname:qoutput@, 
from
(
SELECT 'Resource Name:'||[color=#E90505]CHR(9)[/color]||p.resource_name rname
FROM TEST_RESOURCE T, PROD_RESOURCE P
WHERE T.RES_ID = P.RESOURCE_ID
)
and @FILTER@
I'm expecting the following output

Portlet Heading
Resource Name: (tab) Edward, Alan => (tab) represents 5 blank spaces, this is a data row

Outcomes