valuelist usage

Hi there,

I am trying to use the same valuelist for two fields of type number and integer. But I get the following error message. Is there any reason I cannot use it this way?

The valuelist was already created for type: NUMBER
for the dataproviders: globals.mod_reportmaker_srch_fld_1_number
So it can’t be uses also for type: INTEGER for the dataprovider: globals.mod_reportmaker_srch_fld_1_integer
Please check these dataproviders of this valuelist: mod_reportmaker_srch_9

Thanks!

Integers and Numbers are a different kind of fields. Integer data type stores whole numbers while Number stores decimal numbers (in float format). They are not stored in the same way in the db and I think that’s the reason why you cannot use it as you are trying to do.