cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Query Not Working for Some Doctypes via REST

ybxdde
Star Contributor
Star Contributor

We've set up some custom queries that are configured to query against specific doctypes & to respond with specific columns.  We then are able to 'modify' the custom query via REST and specify the query keywords/values to use.  It returns with a qwerty id which is then used in the next REST call to return the results.

 

This has worked fine for us, until we added another doctype and when giving the keyword defined for it, it does not return in the results.  Using this custom query via the web client however, returns the document.

 

Is there a difference in permissions possibly between the web client and the REST API?  We've got the service account calling the REST API set to Manager level permissions which should give full access.

 

REST API example…modify query to query for ProNo….

/ApiServer/onbase/core/documents/queries

 

{

                  "queryType": [

                                    {

                                                      "type": "CustomQuery",

                                                      "ids": [

                                                                        "283"

                                                      ]

                                    }

                  ],

                  "queryKeywordCollection": [

                                    {

                                                      "typeId": "102",

                                                      "value": "7853337263",

                                                      "operator": "Equal",

                                                      "relation": "And"

                                    }

                  ],

                  "userDisplayColumns": []

}

 

Now call this endpoint to retrieve results based on qwerty ID results from above modify query endpoint…..but no results are returned

/ApiServer/onbase/core/documents/queries/24e255f9-5153-44fe-86a6-659e4d15e1ce/results

{

    "items": []

}

1 ACCEPTED ANSWER

ybxdde
Star Contributor
Star Contributor

This seems to be due to needing an IIS RESET for changes to the queries to take effect.

View answer in original post

1 REPLY 1

ybxdde
Star Contributor
Star Contributor

This seems to be due to needing an IIS RESET for changes to the queries to take effect.