georges.barakeh

Is there a way to add the language_code parameter to an NSQL query in the select portion of the statement?

Discussion created by georges.barakeh on Mar 12, 2015
Latest reply on Mar 12, 2015 by nick_darlington

SELECT

       @SELECT:DIM:USER_DEF:IMPLIED:AUDIT:AUD.id:aud_id@,

       @SELECT:DIM_PROP:USER_DEF:IMPLIED:AUDIT:AUD.object_code:aud_object_code@,

       @SELECT:DIM_PROP:USER_DEF:IMPLIED:AUDIT: (decode (@where:param:language@ , 'en', 'English', 'fr', 'French')): language_code@

 

 

FROM

 

TABLENAME ;

 

 

I'm trying to pass the @where:param:language@ parameter to the decode function to determine the language selected by the user. It's not working. Any ideas?

 

Thanks,

-Georges

Outcomes