The "Overview" pages (of Incident Management, Problem Management and the likes ) are made upof OQ queries in the XM file.
Now, we put static queries which extract, say, the data of ast 14 days. Now, I want to do it dynamic so the user selects a date imit and OQL adjusts accordingy.
I want to know that is there any standard way to impement it? If so, then what is it?
That's a great idea, we have it in our mind for years, but it never got enough priority to get developped. Out of the box with iTop, this is just totally impossible.
Doing it at the level of the Dashboard is probably very difficult to be coded as an iTop extension, also I may be wrong, as for example a Dashboard is already able to receive as parameter, the selected organization (silo) and process it in each and every dashlets. But dates are much more complex to process in a generic maner as there are multiple dates fields on Classes, while there is a single field named 'org_id' on a Class (or none).
Developping new type of Dashlets is for sure possible and could provide that feature, meaning proposing buttons to get a different time view on each single dashlet. For example Calendar View Dashlett allow that type of time navigation. But having multiple place to change the dates make the dashboard quite painfull to use and inconsistent :-(
Another workaround could be to create a new class of objects, say "Period" with a label, a start date and end date, a duration or periodicity, a previous period, a next period and a dashboard attribute displaying whatever make sense, using in the query the placeholder :this->start_date and :this->end_date. That Dashboard could have at the beginning two dashlets displaying a link to the previous period and the next period. It might be tricky to force that link to open the other period on the dashboard tab directly, at least I don't know how to do it. And also you have to create all the Periods in advance, by CSV import.
You could store other information on the Period, such as some statistical results, to then compare period after period...
In all cases, this requires development skills.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello! Hopefully you are fine!
The "Overview" pages (of Incident Management, Problem Management and the likes ) are made upof OQ queries in the XM file.
Now, we put static queries which extract, say, the data of ast 14 days. Now, I want to do it dynamic so the user selects a date imit and OQL adjusts accordingy.
I want to know that is there any standard way to impement it? If so, then what is it?
If no, then any cue on how it can be achieved?
I have attached an, elaborating, image.
Regards
Mushrraf Baig Ashraf
That's a great idea, we have it in our mind for years, but it never got enough priority to get developped. Out of the box with iTop, this is just totally impossible.
Doing it at the level of the Dashboard is probably very difficult to be coded as an iTop extension, also I may be wrong, as for example a Dashboard is already able to receive as parameter, the selected organization (silo) and process it in each and every dashlets. But dates are much more complex to process in a generic maner as there are multiple dates fields on Classes, while there is a single field named 'org_id' on a Class (or none).
Developping new type of Dashlets is for sure possible and could provide that feature, meaning proposing buttons to get a different time view on each single dashlet. For example Calendar View Dashlett allow that type of time navigation. But having multiple place to change the dates make the dashboard quite painfull to use and inconsistent :-(
Another workaround could be to create a new class of objects, say "Period" with a label, a start date and end date, a duration or periodicity, a previous period, a next period and a dashboard attribute displaying whatever make sense, using in the query the placeholder :this->start_date and :this->end_date. That Dashboard could have at the beginning two dashlets displaying a link to the previous period and the next period. It might be tricky to force that link to open the other period on the dashboard tab directly, at least I don't know how to do it. And also you have to create all the Periods in advance, by CSV import.
You could store other information on the Period, such as some statistical results, to then compare period after period...
In all cases, this requires development skills.