Das Notes Forum

Lotus Notes / Domino Sonstiges => Projekt Bereich => Help-Desk Applikation !!Help!! => Thema gestartet von: alecrespi am 14.02.07 - 11:44:51

Titel: New View grouped by "Department"
Beitrag von: alecrespi am 14.02.07 - 11:44:51
Hi!
I've created a new view called "Closed by Department".
I would like to have all the Closed Ticket grouped by Department.

Is there any variable or field in the HELPDESK database that would help me in doing this?
or do I have to caluclate the Department using "username" and the Public Address Book (names.nsf)?
Titel: Re: New View grouped by "Department"
Beitrag von: alecrespi am 14.02.07 - 11:54:37
I would like to use a field like
"department"
in the form HD Anfrage

but I'd like to use it a sorting column inside a view...
Titel: Re: New View grouped by "Department"
Beitrag von: Thomas Schulte am 14.02.07 - 13:53:59
In the ticket you have got a department field. This one is Computed for Display. If you change it to Computed you will be able to use it in your view.
Keep in mind that this has one effect. The next update will changes this field to CFD again.
Titel: Re: New View grouped by "Department"
Beitrag von: alecrespi am 14.02.07 - 15:15:16
I've got it...
GREAT!
 ;D
Titel: Re: New View grouped by "Department"
Beitrag von: alecrespi am 14.02.07 - 16:26:55
another question linked with this one...
 ;D

How can I do to show the number of documents in each "department" group?
just to see which departments wins the "helpdesk prize" of the year...
 :P

Can I use the @Count function?
If I use the "Total" checkbox in Property box I get a "0" as count.
Titel: Re: New View grouped by "Department"
Beitrag von: alecrespi am 14.02.07 - 16:38:49
I would like to have a situation like this...
with the total of each "grouped category" between "(" and ")"
Titel: Re: New View grouped by "Department"
Beitrag von: Hagen-Roderich am 23.05.07 - 10:16:38
Ich steh vor dem gleichen Problem und will mit @Count einige Sachen zählen lassen. Die Notes Hilfe hat mich leider nicht weitergebracht.
Ich will zum Beispiel das in der Ansicht "Tickets in Bearbeitung / nach User" hinter dem Username in Klammern die Anzahl der offenen Tickets steht. Wie muss der Code dafür aussehen?
Titel: Re: New View grouped by "Department"
Beitrag von: Thomas Schulte am 23.05.07 - 10:30:53
In Klammern dahinter geht gar nicht.

Was du tun kannst ist eine neue Spalte als Summenspalte anlegen und in diese Spalte einfach eine 1 reinschreiben.
Titel: Re: New View grouped by "Department"
Beitrag von: Hagen-Roderich am 23.05.07 - 12:30:15
Danke, funktioniert.