Checkbuttons to filter results in list mode

[james Johnsson]

Hi.

Ive looked around and couldn't find an answer on the forum, but if there is please point me to it.

Goal:

In list mode I want to have 3 check buttons (in the head) that hides and shows rows based on a field.

Example of field values

Offer

invoice

order

Problem:

I can manage this by scripting Omit multiple values, or extend found set. The problem is that I want the user to be able to check multiple boxes and get the right results. So if I check "offer" and that preforms a (="offer") find, I want to be able to check invoice as well and get both offer and invoice but not order (="offer" & or & ="invoice").

As it is now if I check one first, the second only follows the last find, so it will not display everything I want (cant use show all records since it will remove the first checkbox results).

I assume I can script this by making a hidden record for each search quarry (check box) and if it <1 it will add it to the find. But it seams like a bit much work and not very cleaver. Especially if I have a lot of options that I want to be able to filter by.

Any tips are appreciated. I hope I was clear enough

thanks

[bcooney]

I'd have your checkbox set be a global field, gType. Assign the value list of types to it (Offer, Invoice, etc.). Then attach a script trigger OnObjectModify that performs this script:

Go To Related Records (relationship gType to Type ) using current layout.

That's all you need, although you may wish to trap for no records found or an empty multikey.

You need a relationship from gType to the type field in your table. The key to this technique is understanding that a return-delimited multikey on the parent side of a relationship will match any record in the child that contains any one of the values in the (global) multikey--equivalent to a Find with multiple requests.

[james Johnsson]

Then attach a script trigger OnObjectModify that performs this script:

Go To Related Records (relationship gType to Type ) using current layout.

HI thanks for the reply. I can get the boxes to change the value of gtype so the relationship works fine, But I cant get the Go To Related Records script to work. nothing happens in the list view when I click it. Any Ideas?Ive checked that it runs the script properly, and the relationship seams to work fine. It just dont want to omit the other results.

Ive tried clicking show only related records.

any ideas what Im doing wrong?

[bcooney]

It's so hard for me to understand RGs that don't use Anchor-Buoy, but I'll try. Are you sure that gType is a global text field?

Is gType a field in Orders? I can't tell from your screen shots. Also this relationship shouldn't have anything checked in the boxes "Allow..." below the relationship definition.

Why don't you upload a clone of the file?

[james Johnsson]

Sorry if im not so clear. Its a quite big file...

Here is a very stripped version. But the sorting should work, I just dont know why not.

User: Admin

psw: Admin

Many thanks for your help. Very enoing that I cant solve it myself... :D

problem.zip

[comment]

Try it this way?

problem.zip

[james Johnsson]

Try it this way?

Aha, I finally get it. Many thanks, you saved my day.