How do I apply a complex filter on a DataView web part? RRS feed

  • Question

  • I have w web part which allows a user to add a comment (basically a forum).  It has a simple text box and a check box to make a comment Private (it's use is for annotation so some comments are for personal user).

    What I want to do is filter it with the following conditions:

    1. Items checked as "Private" are only visible to the user who created them
    2. Users can see all "Public" notes

    None of the buit in filters seem to allow me to create something like:

    show (IF Private = false) OR (IF Private = true AND created by = [Me])

    Another aspect is that in the XSL file I have an edit image displaying.  I want this to only be displayed to the creator of the note.
      I have it diplayinf to all users but don't know how to hook up to Created = [Me]

    Can anyone point me in the right direction

    • Edited by Gordon Johnston Friday, January 8, 2010 11:53 AM spelling error
    Friday, January 8, 2010 11:52 AM