dharkangel
MIS
hi everyone,
I have a view of an issues list that I set up and it is showing duplicate versions of each issue. So if I look at the issues in a datasheet, I see the Issue ID duplicated for each issue, EXCEPT for the first person listed in my filter. The issues tied to the first person in my query are NOT duplicated (see filter below).
This is how my filter looks:
Current = Yes
AND
Owner (this is a field in my issues list) = Smith, John
OR
Owner = Peters, Pam
Owner = Wilkes, John
Owner = Nagin, Fred
I understand why it doesn't work in terms of SQL but using Sharepoint's limited filter ability is there any way to make it work correctly? Correctly would be, being able to show only the most current issues that my field 'Owner' is equal to the four people above.
Thanks,
Sal
I have a view of an issues list that I set up and it is showing duplicate versions of each issue. So if I look at the issues in a datasheet, I see the Issue ID duplicated for each issue, EXCEPT for the first person listed in my filter. The issues tied to the first person in my query are NOT duplicated (see filter below).
This is how my filter looks:
Current = Yes
AND
Owner (this is a field in my issues list) = Smith, John
OR
Owner = Peters, Pam
Owner = Wilkes, John
Owner = Nagin, Fred
I understand why it doesn't work in terms of SQL but using Sharepoint's limited filter ability is there any way to make it work correctly? Correctly would be, being able to show only the most current issues that my field 'Owner' is equal to the four people above.
Thanks,
Sal