question Re: Order Field Value in Developer forum

Order Field Value

blaize — Mon, 07 Sep 2015 06:22:10 GMT

Hi,

I would like to ask if there is a certain max value in the Order field because we have tried using values around 1000 - 2000 but it seem to not be working with that values.

In this case, i would like to ask what is the maximum input value for Order field?

Moreover, what is the best practice in using this field?

Thanks for the help.

Re: Order Field Value

yetesh_ch — Mon, 07 Sep 2015 14:29:46 GMT

Hi,

I checked that Order field in Task table is of type INT of max length 11.

Moreover, it is given that max. value of 2147483647 is allowed. Check this link

http://stackoverflow.com/questions/7171312/what-is-the-max-number-if-i-store-int255-in-mysql

Re: Order Field Value

srinivasthelu — Mon, 07 Sep 2015 14:31:24 GMT

Hi Blaize,

Normally Integer fields maps to MYSQL Integers(11 digits)

so it should not impact the functionality with the values you have chosen. It might be that other conflicting Rules overriding the functionality.

As the Best Practice goes, Normally i never saw any implementations that require pretty huge values. 1-1000 should be fine enough.

Thanks

Srinivas

Re: Order Field Value

blaize — Tue, 08 Sep 2015 00:21:52 GMT

Hi Yetesh,

thanks for the response, but in our dev, we have tried using values for 21 variables ranging from 100- 2000 for value in order. When we go to the requested catalog item, some of the fields are not being displayed. not until we change the value of the order same as seen in the screenshot below:

Using the updated order value as seen above, all the fields are now visible. what could have been the problem with the order value?

Thanks for the help.

Re: Order Field Value

blaize — Tue, 08 Sep 2015 00:22:39 GMT

Hi Srinivas,

thanks for the response, you may also look at my response to Yetesh if you have any idea of the issue we encountered.

Thanks a lot.

Re: Order Field Value

paulmorris — Tue, 08 Sep 2015 01:05:27 GMT

What is the max length field on the dictionary entry?

Re: Order Field Value

blaize — Tue, 08 Sep 2015 01:16:06 GMT

Hi Paul,

There is no max length indicated in the dictionary as seen below:

Re: Order Field Value

paulmorris — Tue, 08 Sep 2015 01:22:04 GMT

Open the context menu (Right Click on banner) and navigate to 'Show XML'.

Browse down the XML tree until you find <max_length> as shown below.

If you want to change this value, open a list of records for the table in question.

Personalize the list and add the max length field and increase the value via a cell edit for the field in question.

I've seen Fuji do some weird things around defaulting the max length value to be lower than what is practical.

Re: Order Field Value

blaize — Tue, 08 Sep 2015 01:26:04 GMT

Hi Paul,

Max length is 40, what does this mean? is it 40 digit number? if it is 40 digit number then why does the 2000 values not being accepted?

Re: Order Field Value

Jim Coyne — Tue, 08 Sep 2015 01:41:07 GMT

You may have a Catalog Client Script or UI Policy that is hiding a container and some of your variables are numerically within that container.

As for numbering, I like to use large numbers because that gives you flexibility to add in variables without having to renumber a bunch of them. I'll usually number variables within a section/container within 1,000 or 10,000 intervals, so the first section would start at 1,000, the next 2,000 and so on (or 10,000 and 20,000). For the variables within the sections, depending on how many I already know I need, will be numbered in increments of 50 or 100.

Re: Order Field Value

Pradeep Sharma — Tue, 08 Sep 2015 01:42:05 GMT

Hi Blaize,

Try changing the Max length value to 256 first and then try to put it to the bigger value after.

Re: Order Field Value

Pradeep Sharma — Tue, 08 Sep 2015 01:43:23 GMT

Hi Blaize,

Thanks for the update. I don't see any issue with the UI policy. However I think there might be other client scripts on the form which might be conflicting. Can you please check for the same once.

Re: Order Field Value

blaize — Tue, 08 Sep 2015 06:42:20 GMT

Hi Pradeep,

We have deactivated all scripts that may be conflicting the form, so as all views, but still the issue is the same.

Re: Order Field Value

yetesh_ch — Tue, 08 Sep 2015 08:02:02 GMT

Hi Blaize,

I have tried and a value of 100,000 in order field is working for me.

There is difference between max length in ServiceNow and max length in MySQL. In ServiceNow, it defines a limit on value of a String field. But in MySQL, it is a limit on number of digits. Read the info displayed at top in the image below.