Still trying to create an hour report that will only display when the Owner ID is not equal to the Last Updated By ID | Community
Skip to main content
B
BillPe
Level 3
April 26, 2024
Solved

Still trying to create an hour report that will only display when the Owner ID is not equal to the Last Updated By ID

  • April 26, 2024
  • 1 reply
  • 589 views

One column has the ownerID and the other column has the lastUpdatedByID.  I want to create a text filter that compares the value and only displays if they are not equal.  It is an hour report

 

Here is my text filter

hours=0
hours_Mod=ne
lastUpdatedByID=FIELD:ownerID
lastUpdatedByID_Mod=cine

 

When it runs, it does not filter out the ones that do not match.  It displays all of them

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

hi BillPe, if it helps to give you perspective, think of this "compare field" functionality from a numerical standpoint. (I understand that you're more trying to use it on an ID field -- but I've never been able to get any form of "not equals" to work so this is where my brain rests.)

 

What works for me is: 

* equals

* less than

* greater than 

 

With that in mind, consider cheating the system by using less than and greater than. Your filter should nut out to:

OR:1:hours=0 OR:1:hours_Mod=ne OR:1:lastUpdatedByID=FIELD:ownerID OR:1:lastUpdatedByID_Mod=gt hours=0 hours_Mod=ne lastUpdatedByID=FIELD:ownerID lastUpdatedByID_Mod=lt

In other words, "give me everything except equals." Hope this helps.

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
April 26, 2024

hi BillPe, if it helps to give you perspective, think of this "compare field" functionality from a numerical standpoint. (I understand that you're more trying to use it on an ID field -- but I've never been able to get any form of "not equals" to work so this is where my brain rests.)

 

What works for me is: 

* equals

* less than

* greater than 

 

With that in mind, consider cheating the system by using less than and greater than. Your filter should nut out to:

OR:1:hours=0 OR:1:hours_Mod=ne OR:1:lastUpdatedByID=FIELD:ownerID OR:1:lastUpdatedByID_Mod=gt hours=0 hours_Mod=ne lastUpdatedByID=FIELD:ownerID lastUpdatedByID_Mod=lt

In other words, "give me everything except equals." Hope this helps.

B
BillPeAuthor
Level 3
April 29, 2024

Thank you Skye.  Your choice of using GT and LT worked fine for me.

Terms & ConditionsAccessibility statement

Loading footer...