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!
|
|
Pick List items
Posted: 07 Oct 09 3:11 AM
|
| Something has been noticed by our users: when a user adds an item to a picklist it can only been seen by them and not all other users. Is there a way around this? if i add an item in the picklist logged on as administrator (in the client not admin or arch) everyone can see it. |
|
|
|
Re: Pick List items
Posted: 07 Oct 09 12:24 PM
|
I believe that this is working as designed.
If you need certain Items to be visible to all users, add them as the Admin.
Otherwise, each user would have to add the values that they want on their picklists. |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 1:57 AM
|
Hi Raul,
Thanks for your reply. I understand this is how they are supposed to work but is there any way to make it so users can see items added by each other?
I only need this functionality of one picklist and since it is possible new items may be added daily it wouild be a but incovenient for users to have to contact me every time to add the items as admin.
Is there any way to populate a picklist with SQL? Since the items added, whether by users or admin, all appear in the sysdba.PICKLIST table. |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 2:55 AM
|
| Andrew, no - you can't populate via SQL [well, you can - different story!]. However, you're on the right track. Dispense with the use of the picklist (as you've found - odd behaviour, but correct). Simply create your own table, have a manage form (same size/shape as picklist control) and have the users use this - then use a LookupEdit instead. Essentially, mimic the picklist - but have it in your control and be able to work with a normal table. |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 4:16 AM
|
Im curious now about your [well, you can - different story!].  can you elaborate on this? |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 4:29 AM
|
| You have the unique picklist ID (i,e. the header item for the picklist itself). You can drop/re-create the rows on itemid and then re-create as many as you need auto-magically through code. It's just a table at the end of the day. But, you do need the right picklistid etc. |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 5:00 AM
|
The only thing that controls who can see a picklist item is the contents of the USERID field in the picklist table.
If User = ADMIN, then everyone can see it.
If not, then it is restricted to that user.
If you don't have remotes, you could set up a trigger or automated script on a schedule that looks for these.
Otherwise - if you have either KnowledgeSync or TaskCentre - it would be easy to do.
FWIW - I've spent a lot of time dealing with Picklist Issues - particularly after imports.
The result is this:
http://www.radishtools.com/picklist.html
ws |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 8:04 AM
|
Andrew:
Unless you need to build a very advanced way to handle your Picklist, you could use a Combo Box instead and indeed populate it via SQL.
However, then you lose the Add/Edit functionaliy.
The Lookup Edit is indeed a good Option. You set a filter on it based on the Picklist ID and it will return you all Items for the picklist. And, unless you are using it as a MultiSelect picklist, you wouldn't need to modify your schema (assuming your current field is longer than 12 chars). |
|
|
|
Re: Pick List items
Posted: 08 Oct 09 8:58 AM
|
Thanks very much for your help all. That sounds like a good way to do it but i have already solved the problem a different. Its not the best way of doing it but my managers happy so im happy. When the picklist goes live the list will be empty. Ive added code so as soon as an item is added i update the related record in the picklist table so userid is ADMIN.
Its the same as Walter suggested earlier. Ive tested it and it works great.
Thanks again all. |
|
|
|