Referencing the same field in a report filter AND statement | Community

Question

Referencing the same field in a report filter AND statement

Forum|Forum|5 years ago
September 4, 2020
2 replies
790 views

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.

Doug_Den_Hoed__AtAppStore

Community Advisor

Community Advisor

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

Just an quick update.

I think this is simpler that i thought it was going to be as i can just use the following:

categoryID=<ID OF CUSTOM FORM>

categoryID_Mod=notin

objectCategories:ID_Mod=notblank

Doug_Den_Hoed__AtAppStore

Community Advisor

Community Advisor

Excellent, Jonathan; glad you got it going.

Regards,

Doug

Community Advisor

Community Advisor

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. 😥