Hi, Our SQL Server business datastore table keys are setup as BIGINT

Hi,

Our SQL Server business datastore table keys are setup as BIGINT datatypes. The 'Defining Custom Data Types' article below states that BIGINT is supported and to map using xsd:long type in CDT's:

forum.appian.com/.../Defining_a_Custom_Data_Type.html

We have implemented on this recommendation, however it appears the native Appian 'Number(Integer)' datatype cannot handle numbers bigger than the standard INTEGER range?

For example, when querying a datastoreentity and the key is 110523001, results are returned but when using the key 20275908001 no results are returned, even though a row exists in the table.

Please help, thanks

OriginalPostID-193347

OriginalPostID-193347