Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

create view for complex struct

avatar
Contributor

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

 

 

1 ACCEPTED SOLUTION

avatar

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 ....

View solution in original post

2 REPLIES 2

avatar

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 ....

avatar
Contributor
Thanks, that worked.