Hi all, I'm displaying some records from a database. The data is d

phanibabuk over 10 years ago

Hi all,
I'm displaying some records from a database.
The data is displayed properly on the grid. However, whenever I try to sort using any column, I get the following error:
Error Evaluating UI Expression:
Expression evaluation error in rule: Error evaluating function 'todatasubset': sort should not have blank sort fields.
How can I fix this?
Please provide your inputs....

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

1. You are using the todatasubset in two places:

local!employeeDataSubset: todatasubset(local!employees,local!pagingInfo)

and

local!userGroupsDataSubset: todatasubset(local!userGroups,local!pagingInfo)

byt the todatasubset expects an array of CDTs.

2. Therefore what you need to check is the definition of the following rules:

rule!IM_getGroupDetails(local!selectedEmployeeId),

rule!IM_getAllCIPUsers()
rule!IM_getCIPUsersCreatedWithinMonths(local!StartDate,local!EndDate)

what are they returning? Are they expression rules or query rules? if they are expression rules are you returning a CDT array? or returning ".data" or index(,"data")?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

1. You are using the todatasubset in two places:

local!employeeDataSubset: todatasubset(local!employees,local!pagingInfo)

and

local!userGroupsDataSubset: todatasubset(local!userGroups,local!pagingInfo)

byt the todatasubset expects an array of CDTs.

2. Therefore what you need to check is the definition of the following rules:

rule!IM_getGroupDetails(local!selectedEmployeeId),

rule!IM_getAllCIPUsers()
rule!IM_getCIPUsersCreatedWithinMonths(local!StartDate,local!EndDate)

what are they returning? Are they expression rules or query rules? if they are expression rules are you returning a CDT array? or returning ".data" or index(,"data")?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data