Dear Team,
I am in a new requirement like, given a Support user-id, i need to get all the ticket details that he is assigned with.
I am a newbie to OTRS and need know if there is any web-services or any where i can look into it.
Need your Suggestions on this.
Awaiting for a reply.
Thanks and Regards
Anand.
Get Ticket Details for a users
Moderator: crythias
-
- Znuny newbie
- Posts: 3
- Joined: 25 Jul 2012, 12:34
- Znuny Version: 3.1.0
- Real Name: Anand
- Company: MahindraSatyam
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Get Ticket Details for a users
You want ticket details per agent?
How much detail do you want?
How much detail do you want?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 3
- Joined: 25 Jul 2012, 12:34
- Znuny Version: 3.1.0
- Real Name: Anand
- Company: MahindraSatyam
Re: Get Ticket Details for a users
Thanks for your reply.
As mentioned by you, I want the status of all the tickets for the particular agent.
for example if an Agent "X" has 10 tickets assigned with him, I need the total no of tickets and the status of those.
As mentioned by you, I want the status of all the tickets for the particular agent.
for example if an Agent "X" has 10 tickets assigned with him, I need the total no of tickets and the status of those.
Re: Get Ticket Details for a users
have a look at TicketSearch API description on dev.otrs.org
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 3
- Joined: 25 Jul 2012, 12:34
- Znuny Version: 3.1.0
- Real Name: Anand
- Company: MahindraSatyam
Re: Get Ticket Details for a users
Thanks jojo,
can u please elaborate.
a small code or snippet would be of a great help
Thanks
Anand.
can u please elaborate.
a small code or snippet would be of a great help
Thanks
Anand.
Re: Get Ticket Details for a users
please read and understand the manuals.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny advanced
- Posts: 121
- Joined: 30 Aug 2011, 10:48
- Znuny Version: 3.3.8 && 4.0.9
- Real Name: Artjoms Petrovs
- Location: Latvia
Re: Get Ticket Details for a users
Maybe you could use the static Stats module? (Yeah, again static stats ) It is like you can get a non-changeable report and include inside everything you need, as it is just a PERL module called under the OTRS framework.
If you need just the Total number of tickets and the states of those, then
a) Get a static stat template
b) Add a dropdown with all OTRS agents
c) WRITE the SQL statement, like
SELECT ticket.tn, ticket.state from ticket
WHERE ticket.owner = ?
and after that assign the variable from agent dropdown
It will give you a html table or a csv file with required data
But yeah, if you want dynamic list of tickets then you should use a call to TicketSearch function and write own custom module
If you need just the Total number of tickets and the states of those, then
a) Get a static stat template
b) Add a dropdown with all OTRS agents
c) WRITE the SQL statement, like
SELECT ticket.tn, ticket.state from ticket
WHERE ticket.owner = ?
and after that assign the variable from agent dropdown
It will give you a html table or a csv file with required data
But yeah, if you want dynamic list of tickets then you should use a call to TicketSearch function and write own custom module
Ar cieņu / Kind regards,
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer