Problem filtering search with custom elements

ggppdk
Offline
Administrator

11 years 3 weeks ago #35809 by ggppdk

Replied by ggppdk on topic Problem filtering search with custom elements

Hello, found and fixed, to test fix:

Replace:
(in file components/classescom_flexicontent.fields.php)

Code:

$sql_mode = $filter_customize_options==2;

with

Code:

$sql_mode = $filter_customize_options==1;

-- 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.

jackdaniels
Topic Author
Offline
New Member

11 years 2 weeks ago #36089 by jackdaniels

Replied by jackdaniels on topic Problem filtering search with custom elements

After applying the fix, I no longer get the error FLEXI_FIELD_INVALID_QUERY when I set Custom Retrieval of Filter Values to "Use custom element" but my list is still empty tho...

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

ggppdk
Offline
Administrator

11 years 2 weeks ago #36091 by ggppdk

Replied by ggppdk on topic Problem filtering search with custom elements

Hello,

the bug was that parameter was reversed, so now the query will get executed,

Just note that this query is bad performance:

SELECT value, value as text FROM #__flexicontent_fields_item_relations WHERE field_id='15' AND value != '' GROUP BY value

It groups without need for grouping !!
Appropriate is:

SELECT DISTINCT value, value as text FROM #__flexicontent_fields_item_relations WHERE field_id='15' AND value != ''

(v2.0.2 fixes this in default queries)

About ZERO results ? did you rebuild the index ?
Do you get any errors there?

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