Padding NextNumberObj Numbers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2008 03:49 AM
Any idea how to pad out a field so that the numbers are
displayed PM005000 instead of PM5000 ? if the field is a STRING
The sys_number definition is set to PM and first number of 5000
I have added the digits to 6 so would expect 005000
I am only able to see PM5000. This will therefore cause issues with the ordering as othere records already exist in the table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2008 08:13 PM
You can use the default value of javascript:getNextObjNumberPadded(); on the number. You set the number of digits in the Number Maintenance module. If you are changing this value on the task table you should review the details of all task types before you make the change. You should set the 'number of digits' value appropriately on all task tables so you don't modify the current plans on the rest of the tables. Using 0 'number of digits' means don't pad.
You may have to enable the Number Maintenance module in System Definitions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-08-2008 01:53 AM
Many thanks John,
I was using getNextObjNumber(); with my expectation expecting the "Number of digits" field to determine the padding.
So there are 2 script types that call the same dictioanry entry to determine the next number. Each giving different results i.e PM05000 or PM5000
I guess thats a due diligence part that we need to be aware of.
Again many thanks