Looking for a way to report on a node listing per View. I looked at the view table and found all the views, but I want to see what each view has for nodes.
can you help ?
Just to get an understanding, you want a list of all views, and which nodes use that view?
Yes, that is correct .
There's no real correlation between a node and a view globally. Each node will use a "Node Details" view of some description, but which one can be configured on a user by user basis (i.e. node ID 1 might use the default node details view for user A, but a custom node details view for User and also by device type. Which view each user is configured to use is in the accounts table.
Do you have reason to believe that different nodes are using different views? Looking in the "settings/views by device type" are any types set to anything else than "default"?
Ok , thanks -
Just for instance I have 4 fours Called
North
South
East
West
The views represent for regions of the US.
I want to be able to query the North View and observe each node that resides in that view.
I am not looking for Node details or what a user A can see.
dummy example
select *
FROM <view.tablename>
Result set:
nodea
nodeb
nodec
Ok, I think I see where you going with this. You have create a custom Network Summary view, rather than referring to a nodes details view? Which resources have you placed on the view to show the nodes? Could you paste a screenshot of your view to help me understand?
HI
I can share company data.
For instance :
I go into Orion Wesite Administration and select "add a view"
- I create a Summary type of view (named North)
- I add some resources in Column 1 and Column 2
- In View limitation (located below Resources Column 1 and Column 2) I choose " Groups of Nodes"
Then I go and add nodes to this View.
I would like to able to use some sql to display the nodes sitting under the North view.
OK, I understand. You're asking to produce a list of the nodes that are applied using the view limitation. I'd have to take a look in my database to see where these are stored, however you might find better results using groups and custom properties.
Create a custom property call "area"
Assign the correct area to this property to each node
Create four groups, one for each area
Under each group, create a dynamic query based on the value of the custom property
Set the view limitation to a single group
By creating a configuration like this, when you next add a node you only have to set its custom property correctly and it will appear in the correct group, and therefore the correct view, automatically. It's also very easy to get the list of nodes by A) querying the group, or querying the custom property value.
