Data Services #1719
closed
Added by Venkata Suryateja Thripuraribhotla about 2 months ago.
Updated about 1 month ago.
Description
Dear Madhuri,
Please modify the service desk report sp's with the following criteria.
Add one more condition from Usertype for SI admin.
Update SP in such a way that when SI admin logins get his role(8) from userinfo and join the table "UserSiDetails" based on user id column.
- Status changed from New to Closed
On 27thFeb25,I have tried locally to get the output based on SI of an SIAdmin role.
Due to don't have data in UserSiDetails table, I didn't test in stage by update sp by adding this new query.
On 6thMar25, I have verified UserInfo and UserSiDetails tables, For SIAdmin users SI names are displaying separating by comma in UserInfo table but in UserSiDetails table, only single SI name is displaying. Actually it has to be in revers. So after knowing this issue they are started to working on this issue.
On 7thMar25,After resolved the issue I have Updated the 3 SP's for SIAdmin roles and verified in the application, this is working fine.
Also available in: Atom
PDF