Search for time of a DateTime-field with SimpleSearch-API

[rph]

Hi

Just another wish from one of our customers concerning the SimpleSearch-API:

We store usually DateTime-stuff in the database as one DateTime-Field (so the date and the time are in the same field). Now our customer wish to search for entries that have for example starttime "08:15". Is there a way to achieve this with the SimpleSearch-API. I know that you can add there alternative date-formats, but it is not possible to add only the time-portion.

Thanks for any suggestions.

Best
Roland

[sean]

Hi Roland,

Thanks for using the SvySearch extension.

What would the user actually expect in this case? For example, if they enter "8:15" ?

Any date but with exactly the time "8:15"
or today's date with that time
or some specified date which is already known somehow?

What about special operators? i.e. ">8:15"
should it be limited to entries after that time but for a single day ? or really anytime afterward ?

The expectation would be ambiguous. What is your exact use case ?

Best,
Sean

[rph]

Hi Sean

Thanks for your reply.

The expectation of the user, if he enters "8:15" would be to find every record that has time-portion "08:15" regardless of the date (today, last christmas, what ever). So it should do a "string"-search. Of course, ">8:15" would not work in this case.

So, in some cases we split this in two separate fields: one with the date and one with the time as string (5 characters long). When we then show these fields in a grid-component and let the user search for "8:15", he get what he expects: every record with time "08:15" because we have a string-search.

If we put these 2 values in one date-field in the database but show these in two separate colums with this date-field in the data-grid but in one it has just the date-part and in the second column just the time part, the user will have no result, if he searches for "8:15". For the user the data-grid looks exactly the same but he has differen results.

So maybe the solution would be, to define an additional date-format for the search in such a field that makes just a formated date-string and the search will then make a string-search on that.

Hope I could explain it a little bit clearer.

Best
Roland

[sean]

Thanks for the explanation. I created a support case and we can take a closer look:
https://support.servoy.com/browse/SVYX-269

But I'm not sure that it could even be implemented and could have unintended consequences.

[rph]

Thank you, Sean!