You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

group search results

Summary

OKA I try to make a grouping of results by date and ID

Content

Hi,

for an OKA customer im working on a report that groups searches by contact iD, by datetime.
I get the information from okcs_stg_question

My problmen is that the autocomplete functioneturns lots of partial searches. like

time - ID - SearchText
10:01:00 - 101 - what
10:01:01 - 102 - what is
10:01:02 - 103 - what is my

etc.

i have come up with a way to group these results by minute so i get 1 result based on the length (i add spaces to the shorter questions to make them equal length)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!