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 Client (Pre-7.2)
Forum to discuss using & developing the legacy SalesLogix Web Client (For versions 7.0 and earlier). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Client (Pre-7.2) | New Thread

View: Search:

Author

Thread: Converting picklist to static combo box

Kent Matthew
Posts: 33

Converting picklist to static combo box Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 May 06 2:35 PM

I'm trying to convert the City picklist on the Accounts Advanced Lookup page to a static combo box. I was hoping that the 'list' parameter of the #PL tag would reference a query so that I could just convert the #PL tag to a #QT tag, but I can't find any query named "City". Any ideas?

Also, I've bought the DevLogix III book, but it has less than 40 pages about the web client. Is there another publication that goes into more detail?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Converting picklist to static combo box Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 May 06 2:55 PM

To be honest I really never work with the web client. The query you would need to return the items for a picklist is as follows:

select p1.text from picklist p1 left outer join picklist p2 on (p1.picklistid = p2.itemid) 
where p2.picklistid = 'PICKLISTLIST' and p2.text = 'My Picklist Name'

Now, how exactly you use that in the web client to fill a dropdown, I'm not sure.

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Converting picklist to static combo box Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 May 06 5:15 PM

Quote:

Originally posted by Kent Matthew

I'm trying to convert the City picklist on the Accounts Advanced Lookup page to a static combo box.

What do you mean by static? The user can only choose from the existing list?

If so, just change your picklist control in the web template to have an option name value pair such as option="R"

<#PL name=whatever list=City option="R">

In the SalesLogix Web Developer's Reference (provided on the install cds I believe) there is a bookmark for "Custom SalesLogix Tags". This will show what properties you can set for a picklist. You will also find the "Tag Options" list which explains what "R" means. And finally, note that you can combine multiple tag options when applicable.

Timmus

[Reply][Quote]

Kent Matthew
Posts: 33

Re: Converting picklist to static combo box Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 May 06 10:47 AM

effexor

effexor open

Timmus, you rock! options="R" works like a charm to convert an editable picklist into a uneditable combo box. I see now that this is documented in the PDF version of the Web Developer's Reference. Thanks for helping me make this connection!

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/7/2024 1:39:12 PM