Price Field - Advanced Filter

More
10 years 7 months ago #50575 by mauriestate
Hi,

I am having some issue to make a price field available within the advanced filter and we are getting the error 'FLEXI_FIELD_INVALID_QUERY', please see screenshot below:

[attachment=1:1eh39h4m]<!-- ia1 -->list-filter.jpg<!-- ia1 -->[/attachment:1eh39h4m]

You may see this error live on the link www.sjkestate.com/mauritius-properties-f...land/36-agricultural

Additionally, you may find a screenshot of the field configuration in the backend just in case we have made any misconfiguration.

[attachment=0:1eh39h4m]<!-- ia0 -->backend-configuration.png<!-- ia0 -->[/attachment:1eh39h4m]

What we want to achieve is that, when creating a new item, we'll put the price of the property, for example, 1, 000, 000 and make an advanced filter option shown for the price field as a range selection from let say x amount to xxxx amount so that the site visitor can make a selection and search within specific price range.

Can you please help us on this issue?

Thanks,

Tomy

Offering professional real estate and investment services in Mauritius. Visit us at www.sjkestate.com to also see the power of Flexicontent with Joomla to promote our services.
Attachments:

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

More
10 years 7 months ago #50576 by ggppdk
Hello

you have entered an SQL query

but the parameter above it says "Custom Elements" please change to "SQL query"


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

More
10 years 7 months ago #50577 by mauriestate
Hi,

I did not enter any SQL query, this was added by default in the configuration!

Offering professional real estate and investment services in Mauritius. Visit us at www.sjkestate.com to also see the power of Flexicontent with Joomla to promote our services.

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

More
10 years 7 months ago #50579 by micker
in drop down change use query bellow ;)

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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.664 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