Jump to content

Search issue


This topic is 5718 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi guys,

I'm having a problem with a search request. One of the fields I want to search for is formatted as a radio button field (with value list: nt1, nt2, nt3) so you can select only 1 value.

In my search I want to use a global with the same value list BUT formatted as a checkbox field.

My idea is that you can select for example nt1 and nt3 so you will get all the records with the values nt1 OR nt3.

How can I achive this functionality? I was thinking about getting one selected value from the global (checkbox formatted) fiels at a time and use that in new searches with omit records afterwards.

But how can I get the values from the global field? I need some hints because my scripting skills are not yet that well developed...

Link to comment
Share on other sites

Try something along these lines:

Enter Find Mode [ ]

If [ ValueCount ( Table::gCheckbox ) ]

Loop

Set Field [ Table::Radiofield; MiddleValues ( Table::gCheckbox ; Get ( RecordID ) ; 1 ) ]

Exit Loop If [ Get ( RequestCount ) ≥ ValueCount ( Table::gCheckbox ) ]

New Record/Request

End Loop

End If

Link to comment
Share on other sites

This topic is 5718 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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