Advanced Find RRS feed

  • Question

  • Hi All

       In a view I need to get all contacts which does not have any activity associate to it? Sorry I relized late that I have put this thread in Deployment i read it as Development my bad...

    Please answer


    Friday, July 31, 2009 2:18 AM


  • It seems impossible...

    The only solution that iI can think of is:

    1 - Creating a new boolean attribute in the Contact entity, something like "new_activitiesowner"

    2 - Create a workflow on the Activity entity on Create/update event when the Owner field changes. This workflow should update the "new_activitiesowner" to yes on the Regarding(Contact) that owns this Activity.

    3 - Make an advanced find new_activitiesowner=no (this will not work to the records created before the workflow, in this cases you should update this new attribute manually)

    I think this should work but I'm not sure if this is your solution.
    Good luck.

    NOTE: Is not possible to create a workflow to "Activities" in general. You must create a Workflow to "Note", "E-mail", "Task", etc.

    • Proposed as answer by Jim Glass Jr Thursday, August 6, 2009 2:59 PM
    • Marked as answer by Donna EdwardsMVP Thursday, August 13, 2009 9:22 PM
    Friday, July 31, 2009 9:02 AM