Service Portal - My Tickets

[arnabbose]

My Requirement ::

I want an widget called My Open Tickets: The Widget must display the Open requests, incidents and ideas that the user has submitted for themselves and others on the service portal homepage within a single widget in list form with a maximum of 5 items displayed, with the ability to scroll through the list further if needed.

Please can anyone suggest how to accomplish this! Code snippet will be of great help

[Pritam6]

Take a look at the "requests" page as this has most of what you require. You'll just need to clone one of the widgets and amend it to display Ideas.

[arnabbose]

I've already looked at it - It's gonna be much more than that one though

Can you pls tell me how can I push Incidents and Idea into that list?

Can you also give me a sample code snippet since you'll anyways have that OOB Request widget...

[meia_ahaesy]

If all of those extend from the TASK table, you could potentially display the TASK associated with those items, and select the type to be REQUEST, INCIDENT, or IDEA (not sure what idea is).

The challenge is that SP widgets OOB are not built to query multiple tables like that.

If you're looking for additional customization, you'll need to build a custom widget, which might require a more experienced SP developer to help you on.

[derrickbrown]

If I understand what you want to do, you can absolutely do it within the portal.   Here are the steps I took to test:

NOTE: I'm being overly descriptive so this can be used by many of varying experience.

1) type "task.list" (without quotations) into the filter navigator (above the apps list on the left)

2) Click on the filter above the list

3) Enter the filter criteria you want to use (I recommend using number - starts with - INC [OR] number - starts with - IDEA....etc.)

4) Once you have the filter the way you want it, select run, then right-click on it and select "copy query"

For example, here's a quick test filter I created:

numberSTARTSWITHINC^ORnumberSTARTSWITHRITM^ORnumberSTARTSWITHIDEA^u_callerDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORref_sc_req_item.request.requested_forDYNAMIC90d1921e5f510100a9ad2572f2b477fe^state!=3^ORDERBYDESCnumber

5) Within a portal page, add a "Data Table From Instance" widget

6) Copy your query into the "Filter" field

7) Make sure the table is set to "Task"

Here is what mine looks like:

You should now have the list with whatever criteria you used in your filter.   Hope I correctly understood what you wanted.