Sorting functionality

pavanik

Certified Associate Developer

over 7 years ago

Hi,
I have created a paging grid with some columns.

For Ex: Employee Id , Experience and Department.

Requirement is like sorting based on Employee Id and Experience. So In department the logic is

a!gridTextColumn(
label: "Department",
field: "noSort",
data: index(
local!dataForCurrentPage,
"department",
null
)
),

I faced following error when I click on department column.

Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error: An error occurred while executing a save: Expression evaluation error in rule 'kp_ial_fetchfiltereddata' at function a!queryEntity: The field [noSort] does not exist.

Any suggestions to get this to work?

Thanks in advance

Discussion posts and replies are publicly visible

Parents

0 chandu
A Score Level 2
over 7 years ago

In the a!gridTextColumn(
label:/* this field will be displayed in the Sail Interface to the User*/
field:/* refers to the field that we will get the data from the DB, this field must be the CDT field */
)
a!pagingInfo(
          startIndex:1,
          batchSize:10,
          sort:a!sortInfo(
                    field:/* The feild name that sort to be applied. again this field must be the CDT field*/,
                    ascending:true()/* depends on the requirement we can give true() or false()*/
          )
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chandu
A Score Level 2
over 7 years ago

In the a!gridTextColumn(
label:/* this field will be displayed in the Sail Interface to the User*/
field:/* refers to the field that we will get the data from the DB, this field must be the CDT field */
)
a!pagingInfo(
          startIndex:1,
          batchSize:10,
          sort:a!sortInfo(
                    field:/* The feild name that sort to be applied. again this field must be the CDT field*/,
                    ascending:true()/* depends on the requirement we can give true() or false()*/
          )
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data