12
Views
1
Comments
Cannot Join Aggregate in different DBMS
Question

Hi All,

I create aggregate which is inside an aggregate an source is Log_Screen(PlatformLogs Extension Module) and User(System Module), I try to join 2 entities but it's cannot be done

Thanks,

Kane

Rank: #86

Hello there Kane,

Hope you're doing well.

That problem is happening because you're trying to join application data (User entity) with log data (Log_Screen entity). Unfortunately, that is no longer possible in OutSystems 11.


Please refer to this documentation that explains exactly why this current OutSystems 11 version doesn't allow you to execute that operation:

https://success.outsystems.com/Support/Enterprise_Customers/Upgrading/Keep_OutSystems_log_data_in_a_separate_database


Also, please refer to this documentation that gives you a possible solution to address your issue:

https://success.outsystems.com/Support/Enterprise_Customers/Upgrading/Keep_OutSystems_log_data_in_a_separate_database/Update_applications_that_access_OutSystems_log_data


Most likely, if you really need to access that log data and cross with application data, you can read it and store it locally (creating a new entity) and perform the necessary join operations with this new entity afterwards.


Hope that this helps you!


Kind regards,

Rui Barradas