Field type "menu item"?

Hi there,

how can I create a field, so that the user can select a menu item to be stored/rendered in his content item?
I am aware of the field typ "weblink", but I'm looking for something like JCE's button "menu" that offers a GUI to select an existing menu item.

Thanks!
B

hello you can create a select field with an sql request inside and create a sql to list menu link with value is link and text is name

Thanks, micker! I helped myself out with this sql:

SELECT link as value, title as text FROM #__menu WHERE client_id=0 AND published=1

- client_id stands for frontend.
- link holds the non-SEF url (see JRoute::_() for solution).
- to filter for a menu, add to the WHERE-clause e.g. "AND menutype=mainmenu".
- more columns of interest are alias, type, access, level, browserNav, template_style_id, language, ...

Best regards!

edit:
To build a link-list, use $f->item->fields->elements. It provides and Array like [ StdClass [value] => str non-sef-url, [text] => str label, ...]

thanks for return

thanks for this - very useful!