8/28/2025 5:27:10 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Picklist table
Posted: 22 Apr 09 7:59 AM
|
Hi,
I have a pretty good understanding of how the picklist table works, but I am confused about two details, both in regards to the title rows (picklistid = 'picklistlist').
Is there any meaning behind the IDs of these rows? It looks like all of the picklists in the 'Custom' category have an ID of -1, while some of the 'Saleslogix' picklists have a unique ID and others have -1. How does SLX know which category each picklist is in? Is it hardcoded?
Finally, does anyone know how the DefaultIndex works for the picklist title rows? I played around with it a little and it seems like the index is based on the picklist being sorted by create date. Can anyone verify that this is the case?
Thanks for any help!
-Mike |
|
|
|
Re: Picklist table
Posted: 22 Apr 09 10:57 AM
|
Hi Mike,
ItemIDs beginning kSYST are the SalesLogix or Plugin Families. I think that the category is hardcoded - you can only add "Custom" Pick Lists through the Pick List Manager.
DefaultIndex stores the default value for the Pick List Item selected in Set Default in Pick List Manager and stores the ID field for the selected Pick List Item.
Beware of the ID field for the pick list item it is incremental but if an item is deleted the ID will be reused. The Order of Pick List Items can also be been altered in the Pick List Manager which is the ID field in SQL.
What are you trying to do?
Why not just use the Pick List Manager?
Cheers,
Steve |
|
|
|
Re: Picklist table
Posted: 22 Apr 09 12:36 PM
|
Steve, thanks for the reply.
I am in the process of adding a new utility that will input an excel file, edit the contents and then create/append a picklist automatically. This will save us a great deal of time as we currently have to edit the excel files by hand, create a .plf and import each picklist through the Manager. We have a great deal of picklist changes/additions coming soon.
I have the majority of this done, but as I mentioned, I was confused on these two points. The ID field isn't too important to me, as every picklist that we create will of course be custom, so they will all go in as -1.
However I am still unsure of the DefaultIndex field. It does not seem to store the 'ID' value of the picklist item. Instead, it seems to me that it stores the zero-based index of the picklist items if you were to query them from the database sorted by createdate.
I am just wondering if anyone else has found this to be the case, or has any information otherwise.
Thanks!
-Mike |
|
|
|
Re: Picklist table
Posted: 23 Apr 09 3:14 AM
|
Hi Mike,
DefaultIndex is set on the Pick List field is null or -1 for a Pick List without a "Set Default" option selected. If "Set Default" item has been set it will store the ID field of the Pick List Item and not the ITEMID of the Pick List Item. The ID is a 0 based index, n.b. if a Pick List Item is deleted the number is reused on the next addition of a Pick List Item, so is not based on createdate.
If you are creating Pick Lists you may also need to take into account the SHORTTEXT field for the Pick List Attributes.
Cheers,
Steve |
|
|
|
Re: Picklist table
Posted: 23 Apr 09 2:53 PM
|
Hi Steve,
I am still unsure of this DefaultIndex field and further testing seems to defy the idea that it holds the 'ID' field of the item set as default.
Here is an example of why I think this:
I took a Global Zone picklist with ID/Text as follows: 0/Geo, 1/Region, 2/Area, 3/Territory. The DefaultIndex field was originally 3. This seemed to make sense.
I then changed the ID of the region field to 4. Closed out of the app to make sure everything saved and loaded it back up. I confirmed everything changed in the database through SQL. I changed the Default field to Region. Again closed out to ensure it saved. Now when I look in the DB, the DefaultIndex field is set to 1.
This is not the ID of the Region pick. It is not the index of the Region pick if I were to sort the list by Text. It is also not the index of the Region pick if i were to sort the list by ID. The only thing that seems to fit is that if I sort the list by CreateDate, it is the second item in the list (index = 1 in a zero based list).
The more I have tested this, the more it makes sense. The ID field can be changed by the admin at any time, so that value is not consistent. Same with the index based on alphabetical order, since they can add more items. The only thing that will always remain consistent is the createdate.
I plan to continue testing with this, but any further input would again be appreciated.
Thanks!
-Mike |
|
|
|
Re: Picklist table
Posted: 24 Apr 09 4:05 AM
|
Hi Mike,
I altered all the ID fields 10/Geo, 20/Region, 30/Area and 40/Territory, the ID it stores is the 0 based ID on some sort in this case it returns 3.
However if you alter the CREATEDATE or MODIFYDATE of the pick list item in SQL it does not alter the DEFAULTINDEX when you select the Territory pick list item. I have also looked at ITEMID this too does not alter the DEFAULTINDEX field it always stores 3.
Cheers,
Steve |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|