NetTalk Central

Author Topic: Conditional Filters  (Read 1413 times)

irissystems

  • Newbie
  • *
  • Posts: 17
    • View Profile
    • IRIS Systems
    • Email
Conditional Filters
« on: November 06, 2013, 11:46:20 AM »
Hi,
I need to filter a browse based on a value in my record. I've tried coding the condition in the conditional filter section as:

'TRI3:supr<>1' and a limit
'TRI3:supr=1' and no filter or limit

and I've tried:

'TRI3:supr<><39>1<39>' and a limit
'TRI3:supr=<39>1<39>' and no filter or limit

I seem to get the same result on either way. I know I've accessed the database record and I see that I have a value of 1 or a blank depending on my test case.
What am I doing wrong?


kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Conditional Filters
« Reply #1 on: November 06, 2013, 07:14:40 PM »
tick the template option to send the filter and order to debugview and examine the result

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11186
    • View Profile
Re: Conditional Filters
« Reply #2 on: November 07, 2013, 10:19:25 PM »
also - what is Tri3:Supr?  A Long or String or What?

Is tri3:Supr a field in the browse you are looking at, or some other field in another table?

>> conditional filter section

tell me more about your condition.

cheers
Bruce