SWQL Query working in Studio but not in Orion

mwb

I was hoping someone could point straight to the issue here.  Results come up just fine in SWQL Studio, but Orion (for a report with SWQL selection) just tells me the query is not valid.  There has to be some variance underneath between the two that I'm not aware of.

SELECT ac.Application.Node.CustomProperties.Department as Department,
ac.Application.Node.CustomProperties.Comments as Comments,
ac.Application.Node.Caption as Caption, ac.Application.Node.Status as ApplicationStatus, ac.Application.Name as Application, Name as Component, DetailsUrl, Status as ComponentStatus, StatusDescription,
de.StringData as [ColumnLabel1], de2.StringData as [ColumnLabel2], de3.ErrorMessage as [Error]

FROM Orion.APM.Component ac

FULL JOIN (select ComponentStatusID, ColumnLabel, StringData from Orion.APM.DynamicEvidence where ColumnLabel='ColumnLabel1') de
on ac.CurrentStatus.ComponentStatusID=de.ComponentStatusID

FULL JOIN (select ComponentStatusID, ColumnLabel, StringData from Orion.APM.DynamicEvidence where ColumnLabel='ColumnLabel2') de2
on ac.CurrentStatus.ComponentStatusID=de2.ComponentStatusID

FULL JOIN (select ComponentStatusID, ColumnLabel, ErrorMessage from Orion.APM.DynamicEvidence where ColumnLabel is NULL) de3
on ac.CurrentStatus.ComponentStatusID=de3.ComponentStatusID

where name='ComponentName'

SELECT ac.Application.Node.CustomProperties.Department as Department,
ac.Application.Node.CustomProperties.Comments as Comments,
ac.Application.Node.Caption as Caption, ac.Application.Node.Status as ApplicationStatus, ac.Application.Name as Application, Name as Component, DetailsUrl, Status as ComponentStatus, StatusDescription,
de.StringData as [ColumnLabel1], de2.StringData as [ColumnLabel2], de3.ErrorMessage as [Error]

FROM Orion.APM.Component ac

FULL JOIN (select ComponentStatusID, ColumnLabel, StringData from Orion.APM.DynamicEvidence where ColumnLabel='ColumnLabel1') de
on ac.CurrentStatus.ComponentStatusID=de.ComponentStatusID

FULL JOIN (select ComponentStatusID, ColumnLabel, StringData from Orion.APM.DynamicEvidence where ColumnLabel='ColumnLabel2') de2
on ac.CurrentStatus.ComponentStatusID=de2.ComponentStatusID

FULL JOIN (select ComponentStatusID, ColumnLabel, ErrorMessage from Orion.APM.DynamicEvidence where ColumnLabel is NULL) de3
on ac.CurrentStatus.ComponentStatusID=de3.ComponentStatusID

where name='ComponentName'

mwb

Thanks @tdanner, but it wasn't it - it was actually a character in the column names that I was establishing in the brackets (but hid from the public forum).

The SWQL studio would let me name a column with a period ([text.txt] for example), but the the Orion engine - at least the SWQL in the web report builder, would not accept a column name with a period in it. 

Not a big deal not to have it, but a curious difference between the studio and the Orion website - and annoying since the Orion website won't point to the error.  I actually would have preferred that it fail in the Studio as well...