- This topic has 3 replies, 2 voices, and was last updated 4 years ago by
.
-
Posts
-
Hi,
I try to set in Frontend Search / Custom fields a time filter. The custom field value is in time format, and I select Text in the AjaxSearch Pro, and select the operator to more or equal and less or equal, but in the result is not showing properly. I not found wich logic was apllied in it.
(For example when I set the start time is 8:00, then show only 4 result, but the most time is after 8:00)
Can I set anyway this search type?Thanks forwardly,
Peter DerHi Peter,
I don’t think that is going to work at all. If the time is stored in that format, it is not comparable as a numeric value unfortunately. The SQL does some type casting to deal with non-numerical characters, but I hihgly doubt, that this will work either way.
Hi Ernest,
Thank you for your answer. I fear from that. Yesterday I tried search solution, and found the SQL Query string comparison is working with alphabetic order. (https://stackoverflow.com/questions/26080187/sql-string-comparison-greater-than-and-less-than-operators). But I don’t know, what happend with the value, when I select in AjaxSearch Pro Custom field filter to text and select one numeric operator. The plugin make any conversion in text value?
(I tried change custom field type to text, but it wouldn’t work same.)Thanks forwardly,
Peter Der
- You must be logged in to reply to this topic.