Hi all,
what do I put in my filter condition to get the results of task created by this createdbyID?
Say I only have this CRActivity table, I have nothing in relationships or parameters.
Thank you!
Best answer by aaghaei
View original
Userlevel 4
+1
This answer may be too simplistic, but have you tried using an or statement?
“DisplayName” Equals “CRActivity.Owner” OR “DisplayName” Equals “LoginTracer.Username”
Userlevel 7
+8
Your best bet is to Add AccessInfo to the report Tables and in the report Relationships
join
CRActivity-Inner-AccessInfo
on
CRActivity.CreatedByID-Equal-AccessInfo.UserID
Considering AccessInfo always has ONLY the CURRENT user info, by joining it with CRActivity, automatically report will filter those records created by the current user.
I managed to get the logged in username which is the highlighted, so what I want in filter is to show the task only if username is equal to the names below which are the owners
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.