This may be simplistic....MySQL table question

[poperszky]

Which table controls the sequence of graph displays under the Hierarchy? The problem is that I have a 150 different interfaces that I monitor and when I add a new one, it is invariably near the top of the list so I have to click on the up button for 30 minutes to get it in the proper location. Is it possible to adjust their location by adjusting an entry in a specific table?

Terry

[bulek]

I can fully understand your feelings about clicking "up" for half an hour .

The table name is "graph_hierarchy_items", the column "Sequence". The place is relative for every category. You would probably need to increase sequence number by 1 for all graphs below your new one and set the proper number for newly created.

[raX]

Even I understand how combersome this can be for long lists. One of the things I did to temporarily alievate this is graph grouping. With graph grouping, you can move each "group" up/down separately of its child items.

Does anyone else have a better suggestion for how sequencing should work? I am sort of lost for ideas, so any help would be much appriciated.

-Ian

[bulek]

Well... since you can't do drag and drop there are not too many options. One of them is to print numbers with hierarchy:

1. SNMP graphs
1.1. Router
1.1.1. Util on Serial0
1.1.2. Util on Serial1
1.2. Switch
1.2.1 Util on Ethernet1
[...]

Then along with each graph entry you can add "Move" option where you can specify the desired position in hierarchy. This would also benefit with possibility to move graphs between groups.

[robsweet]

There are two possibilities that I've come up with for this:

1) Capability to move a graph up or down by an arbitrary number of 'slots'
2) Implementing drag-and-drop placement using CSS and DHTML

The later solution also makes it easy to "re-parent" graphs to other headings. I'm working on a proof-of-concept for this sort of functionality.

Rob.