Referencing the same field in a report filter AND statement | Community
Skip to main content
JonnyTh1
Level 3
Sep 4, 2020 4:22 PM UTC
Question

Referencing the same field in a report filter AND statement

I find myself a bit stuck as essentially i want to achieve the following:

A filter on a task report that shows me only the tasks that have a custom form attached (Category ID is not null) and also the task does not contain a particular form (Category ID not equal to <GUID Of Custom Form>).

Just wondering how to achieve this. I can obviously use the same field if using the OR statement but that would not work as i would get all tasks where there is no form attached.......

Thanks in advance

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    5 replies

    Sheri_Whitten
    New Participant
    Sep 8, 2020 7:18 PM UTC

    So glad you reposted this, Doug! I had it bookmarked in the previous community and lost it (and all my other bookmarked goodies) during the switch. 😥

    Translate
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    Sep 5, 2020 2:53 PM UTC

    Hi Jonathan,

    I suggest you use the technique I devised in Tunnel Of Death: How To Find A Form With Two Specific Custom Forms On It.

    I also recall seeing a way to do this with an EXISTS and a NOTEXISTS on the categories collection (vs the categoryID).

    Regards,

    Doug

    Translate
      JonnyTh1Author
      Level 3
      Sep 9, 2020 8:00 AM UTC

      Hi Doug

      Thanks for the advice. I will give this a go. I have done a few things with objectCategories via the API in the past so i see where you are coming from here.

      I will update this thread when i have given this a go!

      Thanks

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...