Open menu

select field with sql query to select joomla menu item

kath
Offline
Platinum Member

3 years 10 months ago #79721 by kath

Replied by kath on topic select field with sql query to select joomla menu item

Hi Micker,
thanks, but no, doesn't make a difference.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

3 years 10 months ago #79730 by ggppdk

Replied by ggppdk on topic select field with sql query to select joomla menu item

Hello

that SQL query should show e.g. 200 values
and the select dropdown is showing only e.g. 180 values ?

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

kath
Offline
Platinum Member

3 years 10 months ago #79734 by kath

Replied by kath on topic select field with sql query to select joomla menu item

Yes, exactly. Seemlingy random items are left out.

[more details]

the numbers are lower than in your example: SHOULD ~140 , IS 33
website is bilingual (ger, eng)
some desired menu items are in a hidden, published menu, but are themselves published.
desired menu items have different menu item types, like fc-category, url, system-link, etc.

About list item 2.:
Question: does the i18n make some link-hrefs duplicate, and thus leaves them out of the result?
If that is the case, could you help out with the right sql to get all menu items, including e.g. both
<option value="[...]view=category&cid=44">/de/impressum</option> and
<option value="[...]view=category&cid=44">/en/imprint</option> ?
(above is just an example)

Thanks a lot!

Please Log in or Create an account to join the conversation.