Dear community,
I'm having difficulty figuring out why this SQL query is coming up empty when creating a 'Query Layer.'
I have two layers in the electrical network on SDE. Database on MSSQL 19 and using ArcPro 2.9.2.
Relationship: one eTransformerBank [Field Name: FacilityId, Alias:Transformer ID, (Data Type: Long)] has many eTransformerUnit [Field Name: FacilityId, Alias: Facility Identifier, (Data Type: Text)].
Query:
select T.OBJECTID,FC.Shape,FC.FacilityId,FC.TransformerType,FC.UnitCount,FC.Project,FC.MapId,T.Phase,T.Voltage, CAST(FLOOR(T.kvaRating) AS varchar) AS Label from ForestGrove.GIS.eTransformerBank_evw AS FC LEFT OUTER JOIN ForestGrove.GIS.eTransformerUnit_evw AS T ON FC.FacilityId=T.TransformerBankId
The query is validated, and I choose FacilityID as a unique identifier to set the spatial properties of the table.
However, once I do this, I get a table with no data.
What am I doing wrong?
Jen Zumbado-Hannibal, GISP
GIS Coordinator
City of Forest Grove
Forest Grove, OR 97116