Get Ticket Details for a users

Moderator: crythias

Post Reply
h3lloanand
Znuny newbie
Posts: 3
Joined: 25 Jul 2012, 12:34
Znuny Version: 3.1.0
Real Name: Anand
Company: MahindraSatyam

Get Ticket Details for a users

Post by h3lloanand »

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.
crythias
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

Post by crythias »

You want ticket details per agent?
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
h3lloanand
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

Post by h3lloanand »

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.
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Get Ticket Details for a users

Post by jojo »

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
h3lloanand
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

Post by h3lloanand »

Thanks jojo,

can u please elaborate.

a small code or snippet would be of a great help

Thanks
Anand.
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Get Ticket Details for a users

Post by jojo »

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
artjoms15
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

Post by artjoms15 »

Maybe you could use the static Stats module? (Yeah, again static stats :D) 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 ;)
Ar cieņu / Kind regards,
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
Post Reply