Hi All, I have a query entity rule ;one of the fields is defined as VARCHAR

georgej over 9 years ago

Hi All,
I have a query entity rule ;one of the fields is defined as VARCHAR but it actually contains only numeric data. Once the data is pulled to the Grid using the query entity rule ,we allow the user to sort by coloumns; but when the user is sorting on the coloumn which is actually VARCHAR but contains only numeric data ,the sorting happens in a weird manner.Actually sorting is correct ,but it is doing character based sorting.Sorting is not happening based on the actual numerical value in the fields.Is there any solution to this issue.

Discussion posts and replies are publicly visible

0 Conor Cahill
Certified Lead Developer
over 9 years ago

You could have a display CDT that has an integer type for that field instead of a string. Then save the results of the queryEntity() into a list of that CDT.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nathan.schmitz
Certified Associate Developer
over 9 years ago

I'd create a database view that casts the varchar column into a numeric/int type. I'd then create a CDT that maps to the database view that contains all of the relevant columns and defines a numeric type. I'd create a new query rule that references this new CDT and use it to populate the paging grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 9 years ago

Have you considered simply changing the CDT and database field to an integer? Ideally you should fix the source of the issue rather than working around it. You may need to script some sort of sweep of the data to make sure it is kept and is of valid numeric format.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel