Reports on Service Portal

Kaustubh k
Tera Contributor

Hi Team,

 

We have displayed  the Reports in Service Portal,

Now we want if any user who has external role ,when clicked on this report should only see the cases created by them,

for eg: Total case count in the report is 20,but created by user A is only 2 ,show when clicking on the report in portal it should show only 2 records or it should show an empty page only after clicking on reports.

 

How can we achieve this.

 

Thanks,

 

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@Kaustubh k 

external users? are you referring to snc_external users belonging to CSM (case)

You should check OOB query BR on case table and ensure it handles your requirement

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

Yes ,I am referring to snc_external users.

For ex:

Below is the report and it should show the count as 50 cases

Kaustubhk_0-1737463714783.png

but when user a clicks ,it should show only cases craeted by him,

 

So ,it should not hamper the aggregates,but only the records after clicking

@Kaustubh k 

when they click the OOB query BR on case table should handle that

Is that not working?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar ,

 

Its not working