select field with sql query to select joomla menu item

Hi,

I was wondering if it was possible to create a select list of all menu items.
I need to create a field for a specific content type where one will be able to add a link to an internal page. I know i can create a simple link field and have user copy paste the link, but I wanted to see if I could make that more user friendly.

Thanks in advance.

i think you can use select list field and use sql request inside to list all link in menu

Hello there,

I'm trying the above, but my select-list shows a seeminlgy random sub-set only.

I tried several possible sql statements.
All of them work in phpMyAdmin.

But in my field-config (editing > values > value creation > use sql=Yes; field elements) they all yield a too short result.

Can I use a pure, unaltered SELECT-statement, or can I get all list of frontend-menu-items for my backend-user on a different way?
Thanks!

can you put your sql request here ?

Sure! I tried for example successfully in phpMyAdmin:

• SELECT link as value, path as text FROM #__menu WHERE type='component' AND published=1 AND client_id=0;
• SELECT link as value, title as text FROM #__menu WHERE type='component' AND published=1 AND client_id=0;

and several other similar once. They all work in phpMyAdmin. But my flexicontent-field-config just throws me less then 100 % of the values.
(Is there some LIMIT doing it's job maybe?)

hello not sure but request is
SELECT link AS value, path AS text FROM #__menu WHERE type='component' AND published=1 AND client_id=0
=> without ; at end