"No data contents" for a prompt

[vovanenok]

Hi all, I have a prompt (check box group). The prompt values are populated by the query.
When this query doesn't return any data I want to display custom test like "No data available" instead of the empty prompt (without values).
I know that such option exists in data containers ("No data contents"), but how to realize it with prompt?

Many thanks in advance

[kattaviz]

Hi,

You can use a variable to display "No data available" when the prompt query did not return any records.


HTH

[vovanenok]

Thanks, but I found a better way (using combination of List and Prompt )

[PRIT AMRIT]

Thanks, but I found a better way (using combination of List and Prompt )

What's that? Would you mind to share the idea? It may help others having similar scenario?

Thanks

[vovanenok]

The main idea is to place a prompt into the list column title, set the same query for this list as for your prompt and enable "No data contents" for your list.
As soon as I have some free time I will post this approach with screenshots.