Why do I receive empty or blank data in my report but should receive concatenated string data?
Oracle Service Cloud, All supported versions
CONCAT is a standard SQL function that concatenates two strings to return a concatenated string. When creating report it is very important to remember that concatenating a NULL value to a string results in a NULL value.
For example we need a contact information to be returned in one string:
If even one of those fields is empty then a blank record will be displayed because the concatenated string will be nulled.
This is the industry-wide SQL standard.
For additional information, refer to the 'Functions' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.