Jump to content
Sign in to follow this  

Can someone explain views?

Recommended Posts

is there somewhere I can go to learn about views?

my town network portals are in the world but missing their radar dot, and are white when selected. I tried to search for them in the database, they don't exist so I was going to create them but it says I can't modify more than one base table through a join view so my question is how would I add baseid 2056994944 to vw_ace_object?

the baseid 2056994944 doesn't exist in vw_ace_object but it does in ace_object, which I assume is why the portal is there but not showing up right.

Share this post

Link to post
Share on other sites

So a "View" is basically like a pre-defined query that typically pulls information from multiple tables into one virtual table. As the name implies, it's for viewing the data but not really editing it.

Don't have access to the database at the moment, but I believe the view you're speaking of references ace_object and base_ace_object. By looking at the structure of those two, you should hopefully see how/where you'd need to add in a new item. (There may be other places that an item touches, too, I don't know off-hand)

  • Like 1

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this