Hi All,
I have a page in my site pointing to a record. When I don't specify any default filters, I am able to fetch all the rows from the database table and display in the record. But when I am giving a filter on the user who inserted the record into the table, it is giving me error.
When the query "user_txt" is null, I am getting the error
"The Requested Record Type is Not Available: Cannot apply operator [EQUALS] to field [user_txt] when comparing to value [TypedValue[it=11, v={abanda}]].{APNX-1-4203-015}"
I was not able to find a solution in the forum except removing the UI on a whole with a showonly condition in case of a null set.
Please assist if anyone has worked on a fix on this.
Thanks,
Adi
Discussion posts and replies are publicly visible
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,!