Unable to filter by ModalitiesInStudy when using a DB Backend that supports "ExtendedFind"

[sprog0]

Orthanc and OE2 are today's mainline versions (2024-12-23)

If select one or more modalities in studies, but not all and push Search... No result found!
For example:
URL: /ui/app/#/filtered-studies?StudyDate=20241223&ModalitiesInStudy=XA&order-by=Metadata,LastUpdate,DESC
request to tools/find: {
"Level":"Study",
"Limit":500,
"Query":{"StudyDate":"20241223","ModalitiesInStudy":"XA"},
"RequestedTags":["ModalitiesInStudy","NumberOfStudyRelatedInstances","NumberOfStudyRelatedSeries","SOPClassesInStudy"],
"Expand":true
}
answer: {
"Details" : "Unable to use Limit or Since in tools/find when querying tags that are not stored as MainDicomTags in the Database",
"HttpError" : "Bad Request",
"HttpStatus" : 400,
"Message" : "Bad request",
"Method" : "POST",
"OrthancError" : "Bad request",
"OrthancStatus" : 8,
"Uri" : "/tools/find"
}

If remove Limit from request, answer will be the correct data.

Configuration:
"MaxStudiesDisplayed": 500,
"PageLoadSize": 50,
// "StudyListSearchMode": "search-as-you-type",
// "StudyListSearchAsYouTypeMinChars": 3,
// "StudyListSearchAsYouTypeDelay": 400,
// "StudyListContentIfNoSearch": "most-recents",
"StudyListSearchMode": "search-button",
"StudyListContentIfNoSearch": "empty",

[amazy]

Thanks for reporting the issue. I'll investigate after the holiday seasons ... and this will require quite some work ...

[amazy]

Prepared a test for the issue: https://orthanc.uclouvain.be/hg/orthanc-tests/rev/f3376bc9f514
Prepared some work in Orthanc: https://orthanc.uclouvain.be/hg/orthanc/rev/cc6027cbd8f1

Unfortunately, no easy fix -> to be continued.