Repeater Unrecognized symbol

[Segi]

I am running into an issue with a nested repeater

Repeater 1 loads a list of categories
Repeater 2 loads a list of permissions for the category with all users who have that permission. There is a virtual column selected in SQL like this: 1 as HasAccess which is defined as a bit type

My form is organized like this in the tree:

Code: Select all

Repeater (This is repeater 1)
   Repeater Row
        Permission

        Repeater (This is repeater 2)
           Repeater Row       
              Name
              Checkbox

The filter expression is "ADMIN_MANAGE_PERMISSIONS-PermissionSectionID=ADMIN_MANAGE_PERMISSIONS_NAMES-PermissionSectionID AND ADMIN_MANAGE_PERMISSIONS-HasAccess = 1"
and is causing my application to crash with the error

Code: Select all

com.ebasetech.ufs.kernel.FormException: Error processing expression ADMIN_MANAGE_PERMISSIONS-PermissionSectionID=ADMIN_MANAGE_PERMISSIONS_NAMES-PermissionSectionID AND ADMIN_MANAGE_PERMISSIONS-HasAccess = 1 in TableFilterEvaluator - Invalid parameter type

Removing AND ADMIN_MANAGE_PERMISSIONS-HasAccess = 1 from the filter expression causes the data to load but it is not filtered.[/code]

Update: I'm still playing around with this and noticed that Ebase does not like that I'm using the number 1 in the fitler expression. If I change =1 to ='1', Ebase doesnt crash but filters everything so no data gets loaded

[Jon]

If the HasAccess column is type BOOLEAN, it should be..

Code: Select all

..HasAccess = 'Y'

Filter expressions use FPL syntax and are evaluated using FPL.