Morning all, Has anyone found a 'nice' way round this issue o

garethm over 9 years ago

Morning all,

Has anyone found a 'nice' way round this issue on a paging grid in Appian 7.8:

The dataset is expression backed via a webservice and often contains data that has a mix of 1 type (e.g. Boolean) and nulls.

When attempting to sort on the field an error is generated:

"The sort field must be a consistent type. Found two different types: 26 and 3, for sort expression <name>"
Type 26 = Boolean
Type 3 = Null.

Formatting the data in the a!textGridColumn has no effect as the sort is performed using the raw data from the expression, and we would like to avoid having to convert everything to text in the webservice and then back to the required dataType

Thanks in advance,

Gareth

Discussion posts and replies are publicly visible

Parents

0 garethm over 9 years ago

Hiya Tim,

The field is returning a value of null - as opposed to "null" or "".
Use case in this instance is to report whether an event has been completed.
Not all eventTypes have this field - hence the null and a yes / no is not appropriate.

However - this is not confined to Boolean fields. We have encountered it with a mix of number(interger) and null and also number(decimal) and null - where there has been no figure entered. Both of these cases we worked round the issue by converting all numbers to strings in the web service, and then back again in the SAIL - which is not ideal, but does the job.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 garethm over 9 years ago

Hiya Tim,

The field is returning a value of null - as opposed to "null" or "".
Use case in this instance is to report whether an event has been completed.
Not all eventTypes have this field - hence the null and a yes / no is not appropriate.

However - this is not confined to Boolean fields. We have encountered it with a mix of number(interger) and null and also number(decimal) and null - where there has been no figure entered. Both of these cases we worked round the issue by converting all numbers to strings in the web service, and then back again in the SAIL - which is not ideal, but does the job.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data