mario.damico

Database.GetQueryDescription returns the wrong table

Discussion created by mario.damico on Apr 5, 2019
Latest reply on May 2, 2019 by mario.damico

Hello to everybody!!

I'm using ArcGIS Pro version 2.3.2 and ArcGIS PRO SDK version 2.3.0.15769 to create a CIMSqlQueryDataConnection to be used in the creation of a FeatureLayer. The data are stored in a PostGIS database, the DB contains two schema named schema1 and schema2, inside those schemas I have placed two table with the same name so that we have:

PostGISDB

|

|_schema1

| |_table

|

|_schema2

|_table

 

When I invoke GetQueryDescription("PostGISDB.schema1.table") using the fully qualified name of the table the function returns the information related to the table "PostGISDB.schema2.table" instead of the information related to "PostGISDB.schema1.table"

 

Any hint?

Outcomes