Help with advanced list dropdown in Admin

3 posts by 1 authors in: Forums > CMS Builder
Last Post: January 15, 2013   (RSS)

By weblm - January 9, 2013

I have a section in my admin that pulls Pricing Seasons from another table.  I do this in the list field as it's set to a dropdown using:

Get options from database (advanced)
Section Tablename: pricing_seasons
Use this field for option values: value
Use this field for option labels: title

The pricing_seasons seciton is a multi record section that has entires like this:

Title: Low Season
Value low_season
Dates:  a wysiwyg field listing the dates for this season

Title: Christmas
Value: christmas
Dates:  a wysiwyg field listing the dates for this season

This is working perfectly to add pricing to my properties.....the only issue is.....we might have a property that has it's own Christmas season, but the dates are different.

What I thought about doing is, in the pricing_seasons section, adding a Note field to the admin.  This would allow someone to create a new section like this:

Title: Christmas
Value: christmas_propertytwo
Dates:  a wysiwyg field listing the dates for this season
Note: Only used for Property 2

The only issue with this is.....in the actual Pricing section, the dropdown shown shows 2 Christmas entries (because they are supposed to be the same name)....but I can't tell which is which.

Is is possible through the advanced Get options from MySQL query....to be able to have the dropdown in the Pricing section show the Title - Note?

So the dropdown would look like this:

Low Season
Christmas
Christmas - Only used for Property 2

Thanks for any help!

-Kevin

LM

By weblm - January 9, 2013

Figured it out....well actually Deborah did  ;-)  I referenced this thread:

http://www.interactivetools.com/forum/forum-posts.php?postNum=2210978#post2210978

I had to change it from CONCAT to CONCAT_WS to handle the null value of my note field.  

Here's my final query:

SELECT value, CONCAT_WS(" - ",title,note)
FROM `<?php echo $TABLE_PREFIX ?>pricing_seasons`

Hope this can help others.

-Kevin

LM

By weblm - January 15, 2013

Just an update....I change the code a bit because what was happening was.....if I edited a season record....and didn't have a note, it would still add the separator.  So a season would look like this:   Low Season - 

To change that I modified the code to this:

SELECT value, CONCAT_WS(" - ",title,NULLIF(note, ''))
FROM `<?php echo $TABLE_PREFIX ?>pricing_seasons`

-Kevin

LM