Skip to main content
Solved

GI condition to exclude results where two fields have the same value


Forum|alt.badge.img

I have a GI with INTran records. I don’t want the GI to include any records where the BuildingID of the SiteID is the same is BuildingID of the ToSiteID. Can I create a condition that will do that?

Best answer by Laura02

Hello,

I think we can use conditions to select where two different Site ID Fields do not match.  I don’t know the tables you are using so I can’t give an exact answer, but here is an example that I think might work for you:

Condition example

Laura

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • October 20, 2023

Hello,

I think we can use conditions to select where two different Site ID Fields do not match.  I don’t know the tables you are using so I can’t give an exact answer, but here is an example that I think might work for you:

Condition example

Laura


Forum|alt.badge.img
  • Author
  • Freshman I
  • 14 replies
  • October 20, 2023

Thanks @Laura02 for your response!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings