Adding a range on an enum field

6.4k views Asked by At

I am trying to add a range (which I believe functions as a filter, right?) on an Enum field. This data source table is used in a Web Report.

This is what I do in the init method of the Web Report:

this.query().dataSourceTable(tablenum(SupplProduct)).addRange(fieldnum(SupplProduct, ShowOnReport)).value(QueryValue(NoYesCombo::Yes));

ShowOnReport is a field of type NoYesCombo Enum.

The Web Report crashes with this error:

Invalid range

I've managed to find quite a few examples on the web and this seems to be the proper way to do it so it supports all languages.

Any ideas ?

Could it be the properties of the field I'm trying to add a range on ?

Right underneath the line of code above, there is another similar line doing exactly the same, on another field:

//this is at the beginning of the init method...
AppointmentTable    activeAppoint = element.args().record().data();
;

this.query().dataSourceTable(tablenum(AppointmentTable)).addRange(fieldnum(AppointmentTable, AppointmentId)).value(queryValue(activeAppoint.AppointmentId));

This range works fine.

Thanks.

1

There are 1 answers

0
Francis Ducharme On BEST ANSWER

Oh crap. The Enterprise Portal server and its Business Connector was still at version RTM while the AOS server it connects on is RU8. After I patched the EP server to RU8, this works.

Thanks.