[midPoint] Object collection error "Resource not defined in a search query" when combining two resources.

[Pavol Mederly]

Hello Gary,

generally speaking, midPoint cannot join query results from two 
different resources. It would have to issue two requests and then 
somehow join the results. It's doable but extremely complex; think e.g. 
about sorting or paging here.

The only case where this is theoretically supportable, is when fetching 
the data from the repository. But even there it should be in the raw 
mode (going directly to internal Repository API), as there are 
additional implementation complications, e.g. that the objects will most 
probably have different schemas.

That way or another, this is something that midPoint does not support. :)

-- 
Pavol Mederly
Software developer
evolveum.com

On 14/08/2023 19:39, Maxwell, Gary via midPoint wrote:
> Can someone explain why the following objectCollection generates the "Resource not defined in a search query" error? The query receives the error when I combine 2 resources in the same query.
>   
> <objectCollection >
>      <name>test Object Collection</name>
>      <iteration>0</iteration>
>      <iterationToken/>
>      <type>c:ShadowType</type>
>      <filter>
>          <q:or>
>              <q:and>
>                  <q:ref>
>                      <q:path>resourceRef</q:path>
>                      <q:value xmlns="">
>                       <oid>46fhsnfg-fg64-44eg-r4dg-44gdty3ygsed</oid>
>                      </q:value>
>                  </q:ref>
>                  <q:equal>
>                      <q:path>kind</q:path>
>                      <q:value>account</q:value>
>                  </q:equal>
>              </q:and>
>              <q:and>
>                  <q:ref>
>                      <q:path>resourceRef</q:path>
>                      <q:value xmlns="">
>                          <oid>165dfghi-1124-3e34-4344-ccfe414ffde0</oid>
>                      </q:value>
>                  </q:ref>
>                  <q:equal>
>                      <q:path>kind</q:path>
>                      <q:value>account</q:value>
>                  </q:equal>
>              </q:and>
>          </q:or>
>      </filter>
> </objectCollection>
>
> Thank you for any help or can point me in the right direction.
> -Gary
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint