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

chrisc834 over 9 years ago

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

Discussion posts and replies are publicly visible

Parents

0 pavithrac over 9 years ago

yes you are right. we cannot convert to text if its a primary key and I don't think that we can handle this on Appian side, but still i will check if we have any other way and let you know if i achieve it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 pavithrac over 9 years ago

yes you are right. we cannot convert to text if its a primary key and I don't think that we can handle this on Appian side, but still i will check if we have any other way and let you know if i achieve it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data