In service portal under view all request how to display catalog item name

kaushalya1 · ‎07-17-2017

Service portal,

Select request-> view all request

2. Select view all button

3. Details will be displayed in table format.

4. Here I need to add status and catalog item in above table. When I add in instance options its not displaying. Please let me know how ill get catalog item and status in above table

Chuck Tomasi · ‎07-17-2017

Hi Kaushalya,

I need to understand what you are requesting. Requests is telling you how many items in the request table you have where requested_for is the current user logged in.

Requests can have one or more request items. When you say you want the status and catalog item in the table, you would potentially have multiple catalog items.

Can you include a screenshot and/or mockup of what you are looking for? If this is Service Portal, then you'll need to do some coding to make a custom widget to list the request and related request items.

kaushalya1 · ‎07-17-2017

Service portal,

Select request-> view all request

Select view all button

Details will be displayed in tabular format.

4. Here I need to add status and catalog item in above table. When I add in instance options its not displaying. Please let me know how ill get catalog item and status in above table

Chuck Tomasi · ‎07-17-2017

Thank you. As noted earlier, the table listed in the first image is pulling from the sc_request record. You'll need to create a custom widget that lists not only the REQ (sc_request) details as this one does, but also do a query to get all RITM (sc_req_item) records associated with that REQ (since it can have more than one.) This could be a bit confusing if someone has three RITMs associated to a single REQ. What would you have it display in that case?

kaushalya1 · ‎07-17-2017

hi Chuck,

i need to display catalog item name and status, widget its using is Data Table from URL Definition, but there is no option related to fields.

thanks

kaushalya