ListGrid Sort, Enum field raise error.

[ppratik]

Hello Folks,

I have XML datasource where my field define as enum. But when I sort them from column header -> Sort Ascending , It raise error. "INVALID INPUT SYNTAX FOR INTEGER"


<dataSource>
<fields>
<field width="100" type="enum" name="state" title="state" align="center">
<valueMap>
<value ID="0">Delete</value>
<value ID="1">Suspend</value>
<value ID="2">Modified</value>
<value ID="3">Running</value>
<value ID="4">Added</value>
<value ID="5">None</value>
</valueMap>
</field>
</fields>
</dataSource>


Any idea??

I ma using SmartClient
Version v10.0p_2015-01-14/PowerEdition Development Only (2015-01-14)
Browser firefox 44.0, chrome Version 48.0.2564.103 m

Thank you

[Isomorphic]

See the FAQ for the information you need to include when posting. Your version is incomplete, and since this error appears to come from the server-side, we need the server-side logs and contents of the RPC tab.

[ppratik]

Server-side datatype is integer but I display its string value using Enum type, and Listgrid loads data on scroll like paging.

If I change type="integer" instead of enum, and remove <valueMap> It works completely ok, without any error.


<field width="100" type="integer" name="state" title="state" align="center">
</field>


Am I missing any property to specify ?? Say something like original type or datatype information for field??

I am using SmartClient Licenced version
Version v10.0p_2015-01-14/PowerEdition Development Only (2015-01-14)

Thanking you.