{ "source": { "type": "dataLayer", "dataSource": { "type": "table", "workspaceId": "MyDatabaseWorkspaceIDSSR2", "dataSourceName": "egdb.DBADMIN.USLakes" } } }
Hi Tanu,
I have a table with a few columns as below:
It will return proper response when I use the following syntax:
{"source": { "type": "dataLayer", "dataSource": { "oidFields": "ObjectID", "query": "SELECT * FROM dbo.test2_datetime2", "type": "queryTable", "geometryType": "esriGeometryPoint", "workspaceId": "can_2023" } }}
However, if do not use SELECT *, instead, if I include spatial column name in my select statement, it will return an error:
Do you have any idea what is going on?
Thank you!
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.