Stump the Panel: SharePoint Q&A

I have a list where I need to filter on three fields:

OnCallStack (lookup field)
OnCallActive (Yes/No)
OnCallOverride (Yes/No)

I need to always filter on OnCallStack.

Then, I need to filter on Override. If a record in the stack has Override = yes, then that's the record I want. If no record in the stack has Override = yes, then display the record (if it exists) where Active = yes.

I figured I'd have to use the XSLT Filtering, but I'm having a tough go at it and Google has been failing me.

Filtering in CAML is always going to be more efficient, but for something like this, I often filter on the nodeset. Something like this:

It's hard for me to tell from what you've posted exactly what you're after, but maybe this will help?

M.

I've been having that issue this week (getting the WHOLE story through in one post/email).

I have a Contacts list that the whole IS department uses for internal contact info. I've added these fields to help automate the On Call rotation process (I also have a timer job that fires off daily to adjust the current On Call person). What I want to do is display a web part that displays each OnCallStack's (ie "Technical Services", "A-Team", "Cache", etc.) active member. It would be pretty straight-foward if it was just show where OnCallActive = Yes, but, if OnCallOverride for a given stack is set, then that takes precedence over any OnCallActive = Yes in the stack.

For example:



This should return Smith, John as the active member on call. However, if this were the data:




Then Sue, Betty should be the active member on call.

Hmm. That's more complicated since you need to compare values across list items. It's definitely possible, but it'll be messy.

This isn't going to be exactly right because I can't test it, but something like this:

M.

Mark,

I'm not quite following the block. When I pasted into XSL, I had issues with the (count(="/ piece. I removed the =", but I'm thinking that's an integral piece. Should there be a closing " somewhere? Maybe here: @OnCallActive = 'Yes'") or ...?