Empty Record giving display Errors

Hi Adi,

Will you please post your filter code? The error appears to indicate you are passing your username into the filter.

Hi bradc,
I am indeed passing the value to the rule. It is working fine if the user has inserted the records. If the user has no records in the database, I am getting that error.

The requirement is to display a null record page with just User Filters if there are no records for the user.

Thanks,
Adi

Hi AdirajuB ,

I am not able to recreate your error in my instance. Can you provide a screenshot with how you've setup your filters?

Hi bradc,

Here you go. I should have included these in the original to avoid all the confusion.

1. This is my default filter. The database has records inserted by users from one of 4 different groups. So the below rule in the filter gets the groupname of the logged in user and gives it as input to the record list and gets the groupname.

 

2. When the fetched group name has records in the database (count > 0), I am able to successfully display the results.

 

3. When the group users have not inserted any records into the database, and the record set returns 0 records, I am getting the error.

And this is the error I want to fix. When the 3rd scenario occurs and the result set returns 0 records, i would like to display an empty page instead of this error.

 

Hello Chanakya Volam  bhanuprakashm I am able to fetch the user group without any issue by passing the loggedInUser() and I have no errors anywhere as long as the resultset has records for that user group. 

Thanks,!

I would suggest modifying your rule to return a single text field. Your filter is using the equals operator but your rule returns a list (Appian type 103) and you get the error shown above.

Your rule getUserGroup(loggedInUser()) is returning a List of Text String, which is type 103 as you see in the error. You cannot use the "=" operator for a list of values, which is why you're receiving the error. To fix this, make sure that rule will only ever return a single value and that the response is of the same type as "audience_txt". Also, depending on the format of that rule, it may be returning an empty array ({}) which is being treated like a list of text string even though it looks null.

Your rule getUserGroup(loggedInUser()) is returning a List of Text String, which is type 103 as you see in the error. You cannot use the "=" operator for a list of values, which is why you're receiving the error. To fix this, make sure that rule will only ever return a single value and that the response is of the same type as "audience_txt". Also, depending on the format of that rule, it may be returning an empty array ({}) which is being treated like a list of text string even though it looks null.