How Can I Insert STRING_LIST in nsql Query

[Bryan Alvarado]

Hi I'm Bryan from peru and i have to use STRING_LIST in nsql query to use multiselector filter
SELECT
@SELECT:DIM:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:row_number() over():unique_key@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:fac.code:N_INVOICE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:fac.bns_valor_factura:USD@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:fac.bns_afiscal:FISCAL_YEAR@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:fac.bns_mes:MONTH_KEY@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:fac.bns_pais_facturante:COUNTRY_INVOICING@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:CASE
WHEN CAST(fac.bns_mes as INTEGER) = 10 THEN 1
WHEN CAST(fac.bns_mes as INTEGER) < 10 THEN CAST(fac.bns_mes as INTEGER) - 10 + 1 + 12
ELSE CAST(fac.bns_mes as INTEGER) - 10 + 1 END:ORDEN@
FROM odf_ca_bns_factura fac
WHERE fac.bns_afiscal LIKE '2020'
AND fac.bns_estado IN ('E', 'P')
AND fac.bns_tipo IN @WHERE:PARAM:USER_DEF:STRING_LIST:SERVICE_LIST@
AND @FILTER@
I know that only way with it is with the porlet filter but when i execute in "query" show me that
ERROR: syntax error at or near "null" Position: 525 SQL Text: SELECT row_number() over() AS unique_key, fac.code AS N_INVOICE, fac.bns_valor_factura AS USD, fac.bns_afiscal AS FISCAL_YEAR, fac.bns_mes AS MONTH_KEY, fac.bns_pais_facturante AS COUNTRY_INVOICING, CASE WHEN CAST(fac.bns_mes as INTEGER) = 10 THEN 1 WHEN CAST(fac.bns_mes as INTEGER) < 10 THEN CAST(fac.bns_mes as INTEGER) - 10 + 1 + 12 ELSE CAST(fac.bns_mes as INTEGER) - 10 + 1 END AS ORDEN FROM odf_ca_bns_factura fac WHERE fac.bns_afiscal LIKE '2020' AND fac.bns_estado IN ('E', 'P') AND fac.bns_tipo IN null AND 1=? and 1=1 and 2 = 2 .

Please can help me

[Okan Turay]

Hello Bryan,

Try this:
AND fac.bns_tipo IN (@WHERE:PARAM:USER_DEF:STRING_LIST:SERVICE_LIST@)
instead of this:
AND fac.bns_tipo IN @WHERE:PARAM:USER_DEF:STRING_LIST:SERVICE_LIST@

[Kathryn Ellis]

This is an incorrect construct. The documentation has been updated to reflect the correct construct 'STRING_INLINE_LIST'. 

The following constructs can be used for different data types: STRING_INLINE_LIST, FLOAT_INLINE_LIST, and INTEGER_INLINE_LIST. 

Refer to online documentation for examples. 

or reference Article ID: 202342:  STRING_LIST NSQL Construct doesn't pass multiple values to the portlet.