question Re: create view for complex struct in Archives of Support Questions (Read Only)

create view for complex struct

ponypony — Fri, 16 Sep 2022 11:43:37 GMT

Hi,

I have a query like

select equipment.`location`.name from a

this works (in HUE), when i try to create a view, i have this error

Invalid column/field name: equipment.location.name

equipment is a complex object under a, and location is complex under equipment, how can i create the view?

Thanks

Shannon

alex.behm — Fri, 09 Jun 2017 14:08:59 GMT

You need to give your "equipment.location.name" an alias that is a valid column name. For example,

create view ... select equipment.location.name as name ....

ponypony — Mon, 12 Jun 2017 13:48:15 GMT

Thanks, that worked.