Hey Kusal, thanks for the hint with the SpacePropertyService. Unfortunately it is not possible to get all space keys with the given property key. fetchMany requires a space key. Do you have plans to change that? How can I implement it without the JPAQueryFactory?
Such queries work correctly only for “defined” names (like ConfluenceBandanaRecord etc), but is there any reliable way to query tables AO_****?, so far I have used createNativeQuery, but it does not give 100% certainty of operation and problems appear for some configurations 
Example: “SELECT * FROM AO_ED669C_TOTP_USER_ENROLLMENT WHERE USER_KEY = ‘USER_KEY’”
The following might be suitable: com.atlassian.activeobjects.external.ActiveObjects#findWithSQL.
1 Like
Hi @Kusal
Basically, what you sent will work for tables/classes built into the plugin, but what if I wanted to retrieve data from another add-on’s AO? … I don’t have any of my tables defined in AO but I would like to download other
invoking ActiveObjects before <ao> configuration module is enabled or plugin is missing an <ao> configuration module. Note that scanning of entities from the ao.model package is no longer supported.
I don’t believe that’s supported
Thanks @Kusal - perhaps you are planning to implement such a solution?, in Jira, there is no issue with querying any tables