Extension with imported tables

Extension with imported tables

  
Hello,

I've created an extension where I imported some tables from a SQL Server dabatase, using a Database Connection created in Service Center.
I've added that extension to a new espace and created a screen with a query to one of the tables and respective Table Records widget.
When I try to publish this new espace I get the following error :

Invalid Query
 
In the query 'Query1' the database is not defined for the following Foreign Entity: 'TABLE_NAME'

The query just has 1 table with no conditions.

I'm using the Agile Community Edition 5

Thanks,
Nelson

 
Invalid Query
 
In the query 'Query2' the database is not defined for the following Foreign Entity: 'BANK_RECONCILIATION'
Hi Nelson,

You problably need to associate the  extension "logical database" with a existing Service Center "Database Connection".

In Service Center, edit  te extension and in the "Operations" tab you can create this association.




Regards, 
João Portela
Thanks. 
It really was simple.

Hi Nelson,

After you know what to do it's simple :).

Perhaps the message should be changed to provide the necessary information on what to do, or even configure the logical-"physical" association since you used a "physical" connection to introspect the table.


Regards,
João Portela