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.

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.

Thank you Josh. I have put a tostring before the first line of my rule to cast the result as a string whatever the result is. It is working fine now.

My rule is a composition of if and else condition with multiple if classes. The weird thing (and why I think it was working fine for a particular user group) is, if the first if condition is true, the rule is returning a Text object, if it is false, for any subsequent if condition becoming true, the rule is returning a type 103.

My rule:

if(ismemberof(loggedInUser(), "Group 1"),
tostring(tointeger(groupname("Group 1"))),
{
if(ismemberof(loggedInUser(), "Group 2"),
tostring(tointeger(groupname("Group 2"))),
{
if(ismemberof(loggedInUser(), "Group 3"),
tostring(tointeger(groupname("Group 3"))),
},
loggedInUser()
},loggedInUser()
)

If the logged in user is from Group 1, I am getting the correct value as a Text type. But if the user belongs to any other group (2 or 3 or 4 and so on), I am getting a List of Text (type 103). I tried to fix it but couldn't do anything. So I have changed my rule slightly to return string value for whatever the outcome of the if condition is. And it is working fine.

The rule, I have written from my memory so is absolutely wrong. I just wanted to show the representation of the rule.

tostring(
if(ismemberof(loggedInUser(), "Group 1"),
tostring(tointeger(groupname("Group 1"))),
{
if(ismemberof(loggedInUser(), "Group 2"),
tostring(tointeger(groupname("Group 2"))),
{
if(ismemberof(loggedInUser(), "Group 3"),
tostring(tointeger(groupname("Group 3"))),
},
loggedInUser()
},loggedInUser()
)
)

Thanks,
Adi

Try updating the rule to be

if(ismemberof(loggedInUser(), "Group 1"),
tostring(tointeger(groupname("Group 1"))),
if(ismemberof(loggedInUser(), "Group 2"),
tostring(tointeger(groupname("Group 2"))),
if(ismemberof(loggedInUser(), "Group 3"),
tostring(tointeger(groupname("Group 3"))),
loggedInUser()
)
)
)