How to display active SCTASK in Service Portal?

[Byron Plant]

Hi good day!

We have a customized widget in our Service Portal (created by previous developer) that shows that active RITM Tickets (sc_req_item table) and active Incidents (incident table) of user (see image below).

Now, I need to add a new ICON that when click, will show all the active SCTASK (sc_task table) of user.

[Byron Plant]

Hi @shloke04 apologies about the screenshots let me paste everything again.

Yes, I followed all the changes in the Server Script.

For the Pages Module Part, , I clone the id ="my_requests" in Pages module and then, it also copied the existing Data Table from Instance Definition of the My Requests.

So I went to sp_instance_table and rename them.

I also changed the Table to sc_task and the fields that will appear on the portal

But I have a couple of problems though

 

1.) If I click the RITM ICON/INCIDENT ICON and it navigates to its respective URL, it shows all the 3 ICONS (RITM, INCIDENT and TASKS) however, if I click the TASKS ICON and navigate to its URL, it only shows 2 ICONS (INCIDENT and TASKS 

2.) I tried impersonating a NON-ITIL user and when I checked the TASKS ICON, there's this error that says: 1 row removed by security constraints. This error only appears on TASK, it is working properly for RITM and INCIDENT.

[Byron Plant]

Hi @shloke04  apologies about the screenshots let me paste everything again.

Yes, I followed all the changes in the Server Script.

For the Pages Module Part, , I clone the id ="my_requests" in Pages module and then, it also copied the existing Data Table from Instance Definition of the My Requests.

So I went to sp_instance_table and rename them. I also changed the Table to sc_task and the fields that will appear on the portal

But I have a couple of problems though

1.) If I click the RITM ICON/INCIDENT ICON and it navigates to its respective URL, it shows all the 3 ICONS (RITM, INCIDENT and TASKS) however, if I click the TASKS ICON and navigate to its URL, it only shows 2 ICONS (INCIDENT and TASKS)

2.) I tried impersonating a NON-ITIL user and when I checked the TASKS ICON, there's this error that says: 1 row removed by security constraints. This error only appears on TASK, it is working properly for RITM and INCIDENT.

[shloke04]

@Byron Plant 

List of record which are shown is based on the below lines of code in Server Script:

var CatQuery = "active=true" + "^ORopened_by=" + gs.getUserID();
var tableCatTask = "sc_task";

Modify your query accordingly and modify it as you need to see the list of records you need.

Currently the condition just says it will display according to below conditions:

1) Active records

2) AND records opened by current logged in user.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Byron Plant]

Hi @shloke04 good day, I am referring to the ICON buttons. The RITM button is missing on the SCTASK Page

are they not dependent on this line of code???

cat = {id: 7, label:CATTaskLabel, icon: 'fa fa-ticket',link:catalog_link,'count':CatCount, page :'New Page Name',visible:data.currentPage=='my_tickets'||data.currentPage=='my_requests'};
categories.push(cat);

[Byron Plant]

Hi @shloke04  I forgot to mentioned, for the ACL part, all of our NON-ITIL users contains role snc_internal.

So what I did, I created an ACL in the SC_TASK table and added the role snc_internal.

The error: 1 row removed by security constraints is GONE but the users still don't see any records.