February 15, 2009 by Gabriel Mongefranco
Comments (2)
[Transferred from http:/
While creating some custom reports for Unicenter ServiceDesk in JasperServer, I thought it would be very cool to have links going directly to ServiceDesk. So I started reading online documentation and forums, just to find, to no surprise, not enough documentation. That is when I decided to take matters into my own hands, and begun looking at the HTML and JavaScript code in change order forms. Eventually, I came up with the basic parameters needed to create hyperlinks linking directly to specific forms in ServiceDesk, using only URL parameters.
The URL for a hyperlink should start with a base address in the form:
https:/
Every parameter after that must be separated by plus (+) signs. The following is a list of the parameters I found and their values.
Parameter: OP
Description: The operation to perform
Values: SEARCH, ???
Value Descriptions:
SEARCH: search for something in the database
Parameter: SKIPLIST
Description: Skips the search results list
Values: 0, 1
Value Descriptions:
0: Show the results grid (like Google)
1: Skip the results grid and jump directly to the most likely result
Parameter: FACTORY
Description: The form/table to open (change order, request, etc.)
Values: chg, cr, ???
Value Descriptions:
chg: Change order
cr: Change request
Parameter: QBE.<operator>.<[joint table or group]>.<field name>
Description: Query builder indicating from left to right: the comparison operator to use, the joint table or group (if any), and the field name
Values: Any value as appropriate
Value Descriptions:
Any value as appropriate
First Sub-parameter:
.EQ: Equal to
.GT: Greater than
.GE: Greater than or equal to
.LT: Less than
.LE: Less than or equal to
.IN: Contained in
Second Sub-parameter (optional):
.<[table name]>: The table name if looking outside of the main table (e.g., customers table)
Third Sub-parameter:
.<field name>: The field to use in the filter (WHERE clause)
And here are a few examples:
Example 1: Show a list of change orders assigned to the "INFO SEC" queue:
https:/
Example 2: Open a specific change order, #1234:
https:/
The QBE parameter can repeated multiple times to create an AND filter. OR filters can be created with the help of IN operators and a little bit of creativity. Having figured out AND and OR, one can create any other Boolean operators.
This documentation is by no means official. It is only my personal findings after experimenting for less than an hour. If you have a link to the complete, official documentation, please feel free to comment on this blog and leave the URL. Have fun, and happy hacking!
ed hardy clothing louboutin shoes jordan shoes wholesale nfl jerseys cheap nfl jerseys