Hi, I have created a view as below. select column1, column2 from

prasadr875 over 9 years ago

Hi,

I have created a view as below.
select column1, column2 from table order by column2 desc, column1
In the Interface I have used query entity to get the data from the view. In phpmyadmin I can see the data in sorted format but in the grid the data is not sorted properly.
paginginfo is a!pagingInfo(startIndex: 1,batchSize: - 1)

what is the error?

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 9 years ago

1. Does your CDT has a field marked as @Id? (even if it's a view you need to mark a field as the primary key)
2. Does that column contain only unique values?
3. Your paging info doesn't have any sorting. See how sorting can be done at Appian:
forum.appian.com/.../Grid_Tutorial.html

local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20,
sort: a!sortInfo(
field: "expenseDate",
ascending: false
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

1. Does your CDT has a field marked as @Id? (even if it's a view you need to mark a field as the primary key)
2. Does that column contain only unique values?
3. Your paging info doesn't have any sorting. See how sorting can be done at Appian:
forum.appian.com/.../Grid_Tutorial.html

local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20,
sort: a!sortInfo(
field: "expenseDate",
ascending: false
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data