CUC Forums

« Back to CUPI Questions

Getting Callhandler Template fails

Combination View Flat View Tree View
Threads [ Previous | Next ]
Greetings experts
 
I am trying to read t the read the callhandler template that starts with word System using the following query:
 
[url=https://10.88.147.247/vmrest/callhandlertemplates?query=(DisplayName%20startswith%20System)]https://10.88.147.247/vmrest/callhandlertemplates?query=(DisplayName%20startswith%20System)
 
But this fails, and gives the HTTP 400 error. I have confirmed that the template exists on CUC server. But I don't know why the query fails. Your help is much appreciated!
Best regards
Shadan

The error is correct:
 
all query columns must be indexed or boolean: column=DisplayName
 
We put a restriction on what filters can be applied as some filters would can internal database performance issues.  Unfortunately, the display name column is not indexed on call handler templates.  I've sent an internal email to the data team to see if we can get that field indexed, but it won't help for current releases.
 
Complete error response pasted below:
 
<ErrorDetails>
<errors>
<code>INVALID_PARAMETER</code>
<message>
all query columns must be indexed or boolean: column=DisplayName
</message>
</errors>
</ErrorDetails>

Thanks for the reply!
 
So what are the columns that are indexed for CallHandler templates?
 
Best regards
Shadan

It appears that the only columns indexed on call handler templates are:  ObjectId, FileName and AfterMessageActionObjectId.  Internally it looks like there is an agreement that we can index the DisplayName column as well, but it won't help for current releases.
 
-Dave

Thanks David!