Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, July 5, 2025 
 
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!
 Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New ThreadView:  Search:  
 Author  Thread: Picklist has multiples of same values after deployment
chez
Posts: 44
 
Picklist has multiples of same values after deploymentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Sep 09 5:23 AM
Hi
I previously had an account tab with picklists on it,
i updated the form and so created new bundle with this new form in and included the picklists as altered some items in them.
When deployed the picklists now have multiple values for each item?
i.e. picklist had values Yes, No, Amended now has Yes,Yes,No,No,Amended,Amended
and seems to add an extra multiple when i close down the application and rebuilt everything!!
(Within architect picklist values correct, just viewing webpage incorrect)
Rebundled just the form (no picklists) and just applied this, still same prob.

Any ideas how to stop this so the picklist items only show once?
Many Thanks
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Picklist has multiples of same values after deploymentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Sep 09 1:17 PM
Picklists are not generated from the Web Client, they are read from a separate Table on the Database (called Picklist).

I would suggest that you open the Archited (or Administrator) go into the Manage Picklist window, find the affected picklist and review its value. You are bound to have duplicate items, so just remove the duplicate values and you should be set to go.

The problem is more than likely caused by the way that the Picklist was bundled, which is probably why it is creating duplicate values. Once you have the duplicate values on the DB, the only way to correct it would be by fixing the Picklist definition (as described above).
[Reply][Quote]
chez
Posts: 44
 
Re: Picklist has multiples of same values after deploymentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 09 Sep 09 3:09 AM
alas no
Thought this might be the case so since posting question bundled the picklists seperated in a sxb bundle and applied that, then bundled the form seperately and applied and rebuilt everything.
same problem though, have looked at the picklists and values are fine -no multiple items there!
it appeaars that everytime rebuild everything another multiple of the item appears too- just on this web form?
[Reply][Quote]
RJ Samp
Posts: 973
Top 10 forum poster: 973 posts
 
Re: Picklist has multiples of same values after deploymentYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 10 Sep 09 10:11 AM
Make sure that when you Bundle a Picklist you REPLACE the target picklist....that prevents dupes.

Look at the picklist items through SQL to display your multiple values....I've got the idea that you actually have two or more values for each item....and different USERID's for each value..... if you don't control who can add a picklist item you get individual user picklist lists
[Reply][Quote]
 Page 1 of 1 
  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!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 7/5/2025 3:27:06 AM