Relation field as a search filter [Solved]

ggppdk
Offline
Administrator

11 years 6 months ago #49144 by ggppdk

Replied by ggppdk on topic Relation field as a search filter [Solved]

Hello

you may try something like (please correct if it has errors)

Code:

SELECT i.title AS text, i.id AS value
 FROM #__content AS i
 JOIN #__flexicontent_items_ext AS e ON i.id=e.item_id
 WHERE e.typeid=NNNNN

-- 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 review. Thanks!

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

marc.light
Topic Author
Offline
Elite Member

11 years 6 months ago #49160 by marc.light

Replied by marc.light on topic Relation field as a search filter [Solved]

Thanks a million. Not the perfect solution but let's call it the perfect workaround.

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

micker
Offline
Administrator

11 years 5 months ago #49170 by micker

Replied by micker on topic Relation field as a search filter [Solved]

think to edit your title post to add [solved]

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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