Remove checkbox from top level category when 'get options for database'

5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 16, 2014   (RSS)

By pixelMIGHT(Josh) - April 17, 2014

I have one section that creates a categories menu that allows a user to generate tags and create a category list. This menu is then brought into a section through 'Get options from database (advanced)' and the user checks-off appropriate tags. Is there a way, in the CMS editor, to remove the check box from the top level category and make it bold. Basically, creating a category menu within the CMS. There is not need to check the top level options and it looks confusing to a user.

Any suggestions?

Thank you,


By Chris - April 21, 2014

Hi Josh,

Can you post the query you've set forĀ 'Get options from database (advanced)' and a screenshot showing the offending checkbox?

All the best,

By Chris - April 29, 2014

Hi Josh,

It's not possible to make the fields bold without developing a custom plugin, but what you can do is use a custom Mysql query to add a hyphen and a space (for example) before the labels of checkbox items with a depth > 0 (top-level categories have a depth of 0).

List Options:

Get options from MySQL query (advanced)

SELECT `name`, CONCAT(IF(`depth`, '- ', ''), `name`)
FROM `<?php echo $TABLE_PREFIX ?>portfolio_tags`

(Or see the attached screenshot)

I hope this helps. If you still need bold items, we can build a custom plugin for you through our paid consulting service -- please let me know if that's something you're interested in.

All the best,

portfolio_tags.png 14K

By pixelMIGHT(Josh) - May 16, 2014

Thanks, Chris. I like the solution of having the > 0 items with a "-" and it almost does it, but creates a second issue: The items with a depth of 0 are all at the top of the list and those with a depth > 0 are below. If it's not possible to easily have the list stay in depth order using this advanced query, then no problem. I'll consider a custom plug-in if my client has an issue with what is otherwise achievable.