Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Simple operator problem which is eluding me.


Mr H

Recommended Posts

  • Newbies

Apologies, I've been away from FM for about 6 months and I'm having a mental block, can someone help please?

I'm trying to get a portal to filter records and I'm using "<" & ">" to do it. The problem is I want record records > but also <, essentially, if we are talking about numbers 1 to 10 I want numbers greater than 4 but less than 7. If I use the "and" operator I get all records because I've used parameters that contradict each other.

Link to comment
Share on other sites

Posted (edited)
4 hours ago, Mr H said:

I want numbers greater than 4 but less than 7.

Make the portal filter like:

4 < PortalTO::Field and PortalTO::Field < 7

 

 

Edited by comment
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.