You’re offline. This is a read only version of the page.
55
I have written SQL query to display created cases and closed cases based on team.But for a agent login it need to only his data.and admin need to see his data as well as agent data.After deploying the rdl it shows same data with different user security roles.any help on this would be appreciated.
i have a similar question and i used a fetchxml query to build ssrs report , but not sure what condition i need to add so that logged in user will see records based on business unit
Can we not use parameter to filter only the current logged in user data
Tried that also.but with respect to user login it is not showing data.
I have written a query like
Select case when c.statecode=0 then c.createdon else c.resolvedon,ad.name from incident as a
Left join systemuser as ac on c.owininguser=ac.systwmuserid
Left join team membership on ac.systemuserid=teammembership.systemuserid
Left join team as ad on team membership.teamid=ad teamid
Where c.createon>=dateadd(day,-7,getdate())
And ad.name='abc'
Group by createon,ad.team,resolvedon
SQL queries
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,469
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (