I have a list and the associated data items not having data.I would like to display "No data available" message ,have tried selecting no data content text since the data items having null value the message didn't get displayed. Could you please help with a solution
Maybe you can create a case-statement ?
case
when([Data item] = null)
then('No data available')
else([Data item]
end
and also, are you sure that Null is not '' i.e blank because if its an empty string the No data Available text property will not work.
You can try by:
case
when([Data item] = '')
then(null)
else([Data item]
end
To convert empty string to null values and then apply the NO data Available text property.
Best regards,
Oscar
You can specify No Data Contents option.
I just checked: in the CA v.11.1 R4 it is enabled by default.
If your query for the list does not return any data then No Data Available should be displayed
You always can set a specific content
See attached
Thank you for the response. My list value appearing as null values though No data message is not visible. I have tried implementing Oscarca's suggestion.
Direct no data available option is also not working
Does your underlying query for the list return rows with null values?
E.g. your list looks like this:
| Row Number | Column 1 | Column 2 | Column 3 |
| 1 | Value 1 1 | Value 1 2 | NULL |
| 2 | Value 2 1 | NULL | Value 2 3 |
And you want to replace NULL with "No data available" ?
Thank you again!
My data is like below:
Row Number Column 1 Column 2 Column 3 column(which is not using in lis)
1 NULL NULL NULL VALUE1
2 NULL NULL NULL Value2
I would like to completely replace the list with "No data available " message
try to add a detail filter:
not(
[Column 1] is null
and
[Column 2] is null
... add all visible columns in the list
)
Essentially this will output any rows ONLY if at least one visible column is not null.
Therefore if for all rows all visible columns are NULL then query will NOT return any rows. And default No Data processing should kick in...