Model Views table

[Uffe]

Hi all,

I've got a situation where I need to set up a set of "Bookmark" views with preselected contents, so I thought I'd put together a little script -- but I can't find where the views are stored.

Does anyone know?

They've got to be in the database somewhere 'cos they're project-global, right?


/Uffe

[qwerty]

Look into %appdata% where you find a User Views directory.

q.

[Uffe]

No, that's not it. These aren't user views, they're project-global. Everyone can see them.

/U

[qwerty]

How do you define the user view then?

q.

[Uffe]

Found it!

Model views are stored in t_xrefsystem, with Type = 'PView'. Other columns differ depending on type. Sample below.

/Uffe


Root nodes:
    Namespace = 8
    Client = 0
    Supplier = 'ModelRoot'
    Link = NULL
    Description = 'vt=Cust;' for custom, as opposed to built-in (or MDG?), roots; blank for built-in ones.

Views folders:
    Namespace = 7
    Client = 0
    Supplier = the GUID of the parent root node
    Link = NULL

Slideshow folders:
    Namespace = 7
    Client = 0
    Supplier = the GUID of the parent views folder
    Link = NULL
    Description = slideshow details; 'APTime=5;AP=1;' for the default auto-play with five-second delay.

Search folders:
    Namespace = 9
    Client = 0
    Supplier = the GUID of the parent views folder
    Link = NULL
    Description = 'srchID={search GUID};'.

Favorites folders:
    Namespace = 10
    Client = appears to be sort order within parent views folder
    Supplier = the GUID of the parent views folder
    Link = NULL

Package in favorites folder:
    Namespace = 3
    Client = appears to be sort order within parent views folder
    Supplier = the GUID of the parent views folder
    Link = package GUID
    Description = 'sType=Package;'