AnsweredAssumed Answered

NSQL - Parameter option

Question asked by hwk on May 24, 2013
Latest reply on May 27, 2013 by navzjoshi00
Hello CA community,

I am new to CA and just started with creating portlets.
I want to use the following SQL in portlet query. Please guide me how to convert this to NSQL.

select 'Assignment' slice_object, count(*) slice_count, slice_status
when slice_status=1 then ' slice may need to be updated'
when slice_status =2 then 'in process'
end time_slice_status_desc
from prassignment
where slice_status in (1,2)
group by slice_status

I read about Parameter option in the Developers Guide. But I am not sure if Parameter can eb used in this case and how to use it. There are no examples as such to follow.
Appreciate immediate guidance.