Is it possible in IIQ to do what would be referred to in JPA/JPQL as a “join fetch” query"? By using a join fetch, the developer can instruct hibernate to load entities from multiple tables with the results of a single query. So this can be used, for example, to load all entities involved in a many to one relationship. The specific case I’d like to do at the moment, is to query for WorkItem objects and load the associated WorkflowCase at the same time. I see where the Filter class supports joins and left joins, but that does not seem to result in loading objects from the other table(s). There is also a ‘load’ method on anything that inherits from SailPointObject, but that just induces additional queries. The point of a fetch join is to reduce query load. My experience from other applications is that fetch joins can help the app perform better. Am I missing something, or is this not supported in the way SailPoint uses hibernate?
I don’t think this is supported. You will have to search for the WorkItem objects (perhaps you are doing this using context.search() or context.getObjectById()…) and then call the getWorkflowCase() method on a specific WorkItem object in order to get to the corresponding WorkflowCase object
That’s what I’ve found so far. Just seeing if I’ve missed something.
In this exact case I am using context.getObjects (because it’s a small number of objects) but the same applies to search.
For the record, just calling getWorkflowCase is actually insufficient. You must also call a method to get something from the workflow case in order for the object to get lazy loaded. For example, you can call getId() on the resulting workflow case.