Example of Use a Multiselector in nsql query

[Bryan Alvarado]

Please can anyone say it me why me nsql doesnt work, i use the multiselector in porlet filter and doesnt work too
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:clv.name:SERVICIO@, @SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:l.name:PAIS@, @SELECT:DIM_PROP:USER_DEF:IMPLIED:INVOICES_SERVICES_COUNTRY_INVOICING:SUM(fac.bns_valor_factura):VALOR_USD@ FROM odf_ca_bns_factura fac LEFT JOIN CMN_LOOKUPS_V clv ON fac.bns_tipo = clv.LOOKUP_CODE AND clv.LOOKUP_TYPE = 'BNS_TIPO' AND clv.LANGUAGE_CODE = 'es' LEFT JOIN CMN_LOOKUPS_V L ON fac.bns_pais_facturante = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'BNS_PAISES_FACTURACION' AND L.LANGUAGE_CODE = 'es' WHERE bns_afiscal LIKE '2020' AND (fac.bns_tipo IN (@WHERE:PARAM:USER_DEF:STRING_LIST:services@)) AND @FILTER@ GROUP BY clv.name, l.name HAVING @HAVING_FILTER@​

[Albert Vincentpaul]

Try this - (@WHERE:PARAM:USER_DEF:STRING:fac.bns_tipo:services@)

[Bryan Alvarado]

that doesnt work but i use NSQL construct STRING LIST to use a Multiselector Filter, that needs to enable Multiselector on the porlet filter please can you share this topic