[Dynamic Sql Query Screen] I am trying to use this component with an External DB but doesn't work

Forge Component
(1)
Published on 2018-09-28 by Daniel Martins
1 vote
Published on 2018-09-28 by Daniel Martins

everytime I try to use it with an external db, it doesn't work.


I get this error, however, I write the correct Connection Name as it is in Service Center!


Is there any possible way to solve this?

Or Am I missing something?

Hi Mohammed,

Unfortunately this forge component is not ready to work with external databases. Won’t work if you try to query an external entity.


Best regards,

Daniel Martins

Mohamed Emam wrote:

everytime I try to use it with an external db, it doesn't work.


I get this error, however, I write the correct Connection Name as it is in Service Center!


Is there any possible way to solve this?

Or Am I missing something?


Please try this one:

https://www.outsystems.com/forge/component-overview/5900/sql-sandbox

Let me know if it worked, that one is a more recent component and accordingly with reviews you can choose the external database connections.

Daniel Martins wrote:

Mohamed Emam wrote:

everytime I try to use it with an external db, it doesn't work.


I get this error, however, I write the correct Connection Name as it is in Service Center!


Is there any possible way to solve this?

Or Am I missing something?


Please try this one:

https://www.outsystems.com/forge/component-overview/5900/sql-sandbox

Let me know if it worked, that one is a more recent component and accordingly with reviews you can choose the external database connections.

Yes, it's working but we have to write the physical table name  instead of just {Entity}.


Thanks :)