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

chrisc834 over 8 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 ChristineH
Certified Lead Developer
over 8 years ago

If you create a view on the table, you can cast/convert the PK column to text. Just one idea on a work around. You can then use a cdt mapped to the view for reads and a cdt to the table for writes. Maybe?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 8 years ago

If you create a view on the table, you can cast/convert the PK column to text. Just one idea on a work around. You can then use a cdt mapped to the view for reads and a cdt to the table for writes. Maybe?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data