Custom CRM Template Search Scenarios

[bperry11]

I've been able to get a custom crm template working for CID lookup as well as basic search functionality. My issue is that my API only has firstname, lastname, email, etc.... and doesn't have a full name or freestyle search endpoint. So, if I search contacts and type in a first name results begin to appear (but not specific enough results), but as i put a space and beginning typing lastname it stops returning any results.

Presumably, "first last" doesn't match any first names or last names so nothing comes back. Can I work around this in the template? I've tried what I could think for splitting the searchtext and running multiple passes but haven't been able to get anything to work. I'm on a hosted 3cx so I don't have a way that I know of to look under the hood and see what's going on.

Is there a way to handle this to make the search functionality more usable?

 

[Evolute IT]

Create multiple scenarios all starting with "SearchContacts_" and do a search on one field per scenario. Results will be merged and 3CX does the splitting IIRC. If your API is custom, you can always add a column in your database for full name as well.

 

[edossantos_sipcaller]

The problem is that they will need to split the search text, and then run the query with each text item. It's not a simple approach, actually I'm not sure it can be done at all. Maybe the simplest solution would be creating a proxy server, put it between 3CX and the CRM, so 3CX can send the query to this server with the full text, and then the proxy invokes the search of each word in each endpoint.