API search, using AND

[cmisztur]

Is it possible to AND two search fields? Below seems to result in an OR evaluation. Not only that, but it also appears that cabinets__label value is searched as individual words, Invoices, awaiting, entry, instead of Invoices awaiting entry.

/api/v4/search/documents.documentsearchresult/?_ordering=-datetime_created&document_type__label=blah&cabinets__label=Invoices awaiting entry

The documents filter and match_all does seem to enforce an AND evaluation, however.

/api/v4/documents/?_ordering=-datetime_created&filter__match_all=true&filter_document_type__label=Invoice without Purchase Order&filter_cabinets__label=Invoices awaiting entry

Ref:

Noob API search question

I am brand new to this API. I am trying to learn the API. I am using POSTMAN I have been able to auth, get a token and view my documents via the API. My question is how to search using the API I assume i use this endpoint /api/v4/search/advanced/{search_model_pk}/ my question is where do i find what “search_model_pk” is and also where to i put the search terms Thanks for help

Rest API - Ordering for Search-Endpoint not working

Yes, this was added in version 4.4 The AND operator is the default so there is no need to specify it. /api/v4/documents/?filter_versions__version_pages__ocr_content__content=term1%20term2 /api/v4/documents/?filter_versions__version_pages__ocr_content__content=term1+term2 Only fields configures for search are available for filtering. These can be obtained with the API /api/v4/search_models/

https://forum.mayan-edms.com/t/understanding-the-search-lexicon/1011

[roberto.rosario]

It is possible using search scopes. Each search scope acts like a parenthesis to isolate a single search. Operators (AND, OR, NOT) can be specified to determine the relationship between scopes. Due to the complex search queries that can be created using search scopes need, these need to be written by hand.

The entire search lexicon is available to search scopes too making them very powerful and the closest you can get to an SQL style query of your document repository.

Working on a Knowledge article covering their entire functionality and usage.