Date renders other search filters ineffective
Permalink Browser Info Environment
As soon as I add the date select filter all of the other filters stop working except the date filter. If I remove the date filter the others start working.
Type: | Discussion |
---|---|
Status: | In Progress |
And here is a demo with the date deactivated...so other filters work.
http://westernpainsociety.org/events/community-events/1105-2/...
http://westernpainsociety.org/events/community-events/1105-2/...
Can you turn on the debugging on the 'view' tab for both? It will then output the generated sql. Usually, we can figure out what the issue is quickly from there.
Ok...I just setup the debugging on both the search and the page lists on both pages.
Thank you so much!
Thank you so much!
If you run the date page athttp://westernpainsociety.org/events/community-events/... and then fill out the date field, you'll notice something like this about half way down:
which means it is looking for pages with a 'start date' of 'December 1, 2016'.
If you fill out the date field with 1/3/2017, it will return one event.
Is there an option such as 'is after search value'? I believe this is what you will need.
ak_date_start LIKE '%2016-12-01%'
which means it is looking for pages with a 'start date' of 'December 1, 2016'.
If you fill out the date field with 1/3/2017, it will return one event.
Is there an option such as 'is after search value'? I believe this is what you will need.
Ok, I set the date to 'is after' and its still working as it was. Though the formatting of the date in the debugging info is different.
It hasn't fixed the issue of the other search fields not working though.
If its of any importantce, I've changed my custom page list date formatting to
It hasn't fixed the issue of the other search fields not working though.
If its of any importantce, I've changed my custom page list date formatting to
So, I'm wondering if you are clear on the issue I'm having.
The date search works, but to the detriment of all the other search fields...as you can see on this page:
http://westernpainsociety.org/events/community-events/...
On this page, the other search fields work when I remove the date search:
http://westernpainsociety.org/events/community-events/1105-2/...
I'm hoping that all the fields can work congruently.
Thanks, again.
The date search works, but to the detriment of all the other search fields...as you can see on this page:
http://westernpainsociety.org/events/community-events/...
On this page, the other search fields work when I remove the date search:
http://westernpainsociety.org/events/community-events/1105-2/...
I'm hoping that all the fields can work congruently.
Thanks, again.
Here's the page I'm reviewing (with it's search):http://westernpainsociety.org/events/community-events/?query=&s...
You'll notice on the left side the date is and on the right, it is
You'll need to update the block on the left to match the settings for the block on the right, using the 'is after' functionality.
You'll notice on the left side the date is
ak_date_start LIKE '%2016-12-23%'
((CONVERT(ak_date_start, DECIMAL)>'2016-12-23') OR (ak_date_start>'2016-12-23'))
You'll need to update the block on the left to match the settings for the block on the right, using the 'is after' functionality.
Ok, they're the same now, and now the date query doesn't work at all, while the other fields do.
Would it help if I pm'd you with login access to C5?
Would it help if I pm'd you with login access to C5?
It seems the only way I can get the filters to work congruently is to set the date to 'matches current entry' (in fact, that's the only way the date works).
Go ahead and do a date search for 2/2/17 for an initial query. Then select 'family' under categories for a second query. You will see it narrow the results.
Unfortunately it won't work if you don't select a date.
Forgive me for being so high maintenance.
Go ahead and do a date search for 2/2/17 for an initial query. Then select 'family' under categories for a second query. You will see it narrow the results.
Unfortunately it won't work if you don't select a date.
Forgive me for being so high maintenance.
So, I changed my tactic and came up with a better solution. I created select questions for the day, month, and year which accommodate the filtering I'm looking for.
I appreciate your efforts immensely though, and think its easily one of the best add ons in the market place.
Happy Holidays and 2017!!
Thank again,
Kim
I appreciate your efforts immensely though, and think its easily one of the best add ons in the market place.
Happy Holidays and 2017!!
Thank again,
Kim
http://westernpainsociety.org/events/community-events/...
Eugene and Portland are cities you can enter, and Lecture & Family are categories.