This content has been marked as final. Show 4 replies
I know you already tried below method but it is working for me, could you please cross check.
Can you edit your dashboard prompt prompt and find show option then select SQL Result please modify statement like below.
Go--> Edit your prompt--> Show Option--> Select Choice List Values as --> Select Sql result---> change statement like above.
SELECT "tablename"."columnname" FROM "table" where "tablename"."columnname" is not null
Refer this thread might be helpful for you.
NULL Value in the prompt