[correct replacement] custom SQL doesn't work in field setup

More
11 years 8 months ago #40206 by hede
reproduce:
- go into a radio field and choose for the label "Custom Retrieval of Filter Values": "Use custom
query"
- put this into the field below: SELECT value, value as text FROM #__flexicontent_fields_item_relations WHERE field_id='{field_id}' AND value != '' AND value != 'COM_FC_JM_UNKNOWN' AND value != 'COM_FC_JM_INFO_LOCATION' GROUP BY value
- now reindex
expected:
- all values assigned to an item are indexed
current:
- values of that field are only indexed when not using the "custom query"

Or did I mess up the query?

FF on Win10, FLEXIcontent version 3.0.10 on Joomla 3.4

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

More
11 years 8 months ago #40937 by ggppdk
Hello

your SQL query seems to have some errors:

please read popup description of the parameter

e.g.
this is wrong: {field_id}
it should be: {field->id}


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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.289 seconds
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save