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