topic Re: How to search document based on custom model properties using Rest API in Alfresco Forum

How to search document based on custom model properties using Rest API

MOH_MCT — Thu, 18 Jun 2020 06:55:38 GMT

Hello,

Need your help to execute task where I need to search document based on custom model properties.

Task performed-

with Rest API POST '/nodes/{nodeId}/' - I have uploaded document.

As I already developed my content model aspect and property

with Rest API PUT '/nodes/{id}' - I have updated my document with content model property and based on this property I got my aspect name in response.

Task I need to Performed-

Based on this property I need to fetch my document.

Need your help to execute this task by using Rest API

Re: How to search document based on custom model properties using Rest API

EddieMay — Thu, 18 Jun 2020 07:25:43 GMT

Hi @MOH_MCT ,

Here are two threads about searching custom model properties. The first relates to the problems sometimes caused by locale. The second relates to tokenised value. Both have source code that might help you start.

HTH

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Thu, 18 Jun 2020 08:28:10 GMT

Hi @EddieMay

before making Rest API call I am searching my document in alfresco share under Node Browser selecting Lucene as search.

But I am getting the following error- 05181400 Request failed 500 /solr/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=100&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON

request for search

TYPE:"cm:content" AND od:ReObjID:"OmGanesh"

where od:ReObjID is my custom content model property and OmGanesh is my value.

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Mon, 22 Jun 2020 04:22:27 GMT

Hello,

Can anyone help me with this?

Re: How to search document based on custom model properties using Rest API

angelborroy — Mon, 22 Jun 2020 10:46:55 GMT

Use the Search API:

https://api-explorer.alfresco.com/api-explorer/#!/search/search

The JSON Body should be something similar to:

{
  "query": {
    "query": "TYPE:\"cm:content\" AND od:ReObjID:\"OmGanesh\""
  }
}

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Tue, 23 Jun 2020 04:34:30 GMT

@angelborroy

After trying the same JSON I am getting the following error:

//{
  "error": {
    "errorKey": "framework.exception.ApiDefault",
    "statusCode": 500,
    "briefSummary": "05221526 Request failed 500 /solr/alfresco/afts?wt=json&fl=DBID%2Cscore&rows=100&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON",
    "stackTrace": "For security reasons the stack trace is no longer displayed, but the property is kept for previous versions",
    "descriptionURL": "https://api-explorer.alfresco.com",
    "logId": "5493511c-1c08-470f-9817-bd34f0675e71"
  }
}//

JSON Request Used
//{
  "query": {
    "query": "TYPE:\"cm:content\" AND od:ReObjID:\"OmGanesh\""
  }
}//
Kindly help me with this

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Tue, 23 Jun 2020 07:44:34 GMT

Hello,

Can anyone help me with this?

Re: How to search document based on custom model properties using Rest API

angelborroy — Tue, 23 Jun 2020 08:34:05 GMT

Can you attach some information from you alfresco.log?

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Wed, 24 Jun 2020 05:44:32 GMT

Hi @angelborroy

I am attaching logs please download it from a link

https://drive.google.com/drive/folders/17ne9en04wQwWcvRYWTo2olOVsbWVc3GB?usp=sharing

Please let me know how i can overcome this issue

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Thu, 25 Jun 2020 04:07:28 GMT

Hi,

Any Update plz?

Re: How to search document based on custom model properties using Rest API

angelborroy — Thu, 25 Jun 2020 08:24:01 GMT

Logs doesn't help.

That should be working.

Try the same query using Node Browser or any other tool to be sure that it works and it's not a REST API problem.

Re: How to search document based on custom model properties using Rest API

pjcaracuel_2349 — Thu, 25 Jun 2020 09:12:26 GMT

Hi,

This query is working for me.

{

"query": {

"query": "(name:\"FAC*\" OR title:\"FACT*\") AND TYPE:\"fact:folder_fact\""

"paging": {

"maxItems": "25",

"skipCount": "10"

}

I have the correct folder number in the response.

{

"list": {

"pagination": {

"count": 0,

"hasMoreItems": false,

"totalItems": 1,

"skipCount": 10,

"maxItems": 25

"context": {

"consistency": {

"lastTxId": 229

}

"entries": []

}

I only see a difference with your code. I'm using standard alfresco metadata and you a custom metadata. Let me think because I 'm trying the same as you.

{

"query": {

"query": "(+@fact:cif:\"22*\") AND TYPE:\"fact:folder_fact\""

"paging": {

"maxItems": "25",

"skipCount": "10"

}

This call run without error

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Fri, 26 Jun 2020 04:56:49 GMT

Hi @pjcaracuel_2349 and @angelborroy

I am using

{
  "query": {
    "query": "TYPE:\"cm:content\" AND od:ReObjID:\"OmGanesh\""
  }
}
As JSON Payload where ReObjID is my custom property and OmGanesh is value for that can you help me out why i am unable to fetch.

Re: How to search document based on custom model properties using Rest API

pjcaracuel_2349 — Fri, 26 Jun 2020 06:14:24 GMT

Try this

"query": "TYPE:\"cm:content\" AND (+@od:ReObjID:\"OmGanesh\")"

Re: How to search document based on custom model properties using Rest API

MOH_MCT — Fri, 26 Jun 2020 12:49:23 GMT

Hi @pjcaracuel_2349

I tried with the JSON you mentioned i.e

{
"query":{
"query": "TYPE:\"cm:content\" AND (+@od:ReObjID:\"OmGanesh\")"}
}

i am getting following error:

{ "error": { "errorKey": "framework.exception.ApiDefault", "statusCode": 500, "briefSummary": "05260097 Request failed 500 /solr/alfresco/afts?wt=json&fl=DBID%2Cscore&rows=100&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON", "stackTrace": "For security reasons the stack trace is no longer displayed, but the property is kept for previous versions", "descriptionURL": "https://api-explorer.alfresco.com", "logId": "99150429-9c53-4821-a0ad-8373e85e8fbf" } }