Changing AND to OR in "Edit Find Request"

[Kurt Hansen]

I have the following fields in a table (classical music):
Category
Category 2
instrument 1
instrument 2
instrument 3
instrument 4
I would like to make a script that export to the following conditions:
IF "category" OR "category 2" contains "Instrument" then output the contents of "Instrument 1", "Instrument 2", "Instrument 3" and "Instrument 4".

If I add two or more conditions the default is AND. How do I change this to OR?

Edited August 18, 2016 by Kurt Hansen

[webko]

Do it as two find requests, rather than combining them in one as per above.

The Perform Find would look like:

Cheers

 

Webko

[comment]

35 minutes ago, Kurt Hansen said:

IF "category" OR "category 2" contains "Instrument"

This problem is a symptom of another. Any time you find yourself numbering your fields, like "Category 1", Category 2", etc. you should consider using a related table instead. Even a repeating field, or a single field formatted as checkboxes, would be preferable to what you have now.

[Kurt Hansen]

44 minutes ago, webko said:

Do it as two find requests, rather than combining them in one as per above.

Thanks, Webko, but...!

I want it to output only if "Kategori" or "Kategori 2" contains the word "Instrument". My test (see attachments) doesn't do that.

Example: Catalog number BRIDGE 9450 outputs "Kammermusik   Klaver   Klaver   Klarinet    Fagot".

In my database "Kategori" contains "Kammermusik" and "Kategori 2" contains "Instrument".

[comment]

5 minutes ago, Kurt Hansen said:

My test (see attachments) doesn't do that.

Why does your test have four find requests instead of the suggested two?

[Kurt Hansen]

10 minutes ago, comment said:

This problem is a symptom of another. Any time you find yourself numbering your fields, like "Category 1", Category 2", etc. you should consider using a related table instead. Even a repeating field, or a single field formatted as checkboxes, would be preferable to what you have now.

Yes, comment, I believe that, but it would be quite a work for me to "split" my data into two tables. I have 35.000 records in my current flat database AND I'm a novice ;-)

[comment]

Just now, Kurt Hansen said:

it would be quite a work for me to "split" my data into two tables.

Not really. It can be scripted, you know.

[Kurt Hansen]

7 minutes ago, comment said:

Why does your test have four find requests instead of the suggested two?

I'm sorry, I do not know. It is as I had seen the proposal. Which 2 of the 4 should I keep?

[Edit] Ok, comment. I'm working and I think I'm going the reght way now.

Edited August 18, 2016 by Kurt Hansen

[comment]

3 minutes ago, Kurt Hansen said:

Which 2 of the 4 should I keep?

If you want to search the "Kategori" and"Kategori 2" fields, then those are the requests you should keep (#1 and #3 in your screenshot).

I am a little confused by your original requirement:

1 hour ago, Kurt Hansen said:

IF "category" OR "category 2" contains "Instrument" then output the contents of "Instrument 1", "Instrument 2", "Instrument 3" and "Instrument 4".

The result of performing a find is a found set of records. It does not "output" any particular fields. Does your find need additional criteria regarding the "Instrument" fields?

[Kurt Hansen]

Sorry folks, but this is too complicated for me. I give up

Edited August 18, 2016 by Kurt Hansen

[comment]

Why don't you try an easier (IMHO) way:

Enter Find Mode [  ] 
Go to Layout [ “YourTable” ] 
Set Field [ YourTable::Category; "instrument" ] 
New Record/Request 
Set Field [ YourTable::Category2; "instrument" ] 
Perform Find [  ] 

Note that no find requests are specified for the Enter Find Mode [ ] or Perform Find [ ] steps.

 

 

[Ted S]

Comment,

I see you go into find mode before switching layouts. I assume you are doing this to prevent the new layout from retrieving records that are not needed for the task at hand but could the same thing be accomplished with Freeze Window as the first step?

Just curious. 

[comment]

1 hour ago, Ted S said:

could the same thing be accomplished with Freeze Window as the first step?

I suspect so, but I am not really sure:
http://fmforums.com/topic/94092-ask-for-no-records/?do=findComment&comment=430266

[Kurt Hansen]

On 18/8/2016 at 1:12 PM, comment said:

Why don't you try an easier (IMHO) way:

Enter Find Mode [  ] 
Go to Layout [ “YourTable” ] 
Set Field [ YourTable::Category; "instrument" ] 
New Record/Request 
Set Field [ YourTable::Category2; "instrument" ] 
Perform Find [  ] 

Note that no find requests are specified for the Enter Find Mode [ ] or Perform Find [ ] steps.

How do I select two fields in line 3 and 5?

[comment]

5 minutes ago, Kurt Hansen said:

How do I select two fields in line 3 and 5?

Why would you need to?

[Kurt Hansen]

As I (mis)understand you(?) I must select both "Category" + "Instrument" (and "Category" + "Instrument"). My database is flat with only one table. I havn't got tables called "Category" and "Categori 2".

[comment]

14 minutes ago, Kurt Hansen said:

My database is flat with only one table. I havn't got tables called "Category" and "Categori 2".

You must use fully-qualified field names in a script, in the format of TableName::FieldName. My script presumes your table is named "YourTable" - replace this part with your real table name.

 

14 minutes ago, Kurt Hansen said:

I must select both "Category" + "Instrument" (and "Category" + "Instrument").

I don't understand this part. Do you also want to search the Instrument field (or rather fields, since you have 4 of them)?

 

Note that this is the same question I asked earlier:

On 08/18/2016 at 9:22 AM, comment said:

I am a little confused by your original requirement:

...

Does your find need additional criteria regarding the "Instrument" fields?

 

 

Edited August 22, 2016 by comment

[Kurt Hansen]

Please see attachment. How to select? My table has the name "Varer" and "Category" is "Kategori" in Danish.

[ YourTable::Category; "instrument" ]

[comment]

7 minutes ago, Kurt Hansen said:

How to select?

Just click OK and Filemaker will insert the field name for you. It will look like this: Varer::KATEGORI. Then click the Calculated result: Specify button and enter the text "instrument" (including the quotes) as the calculation formula.

These are basic script operations; you should know them after having done the tutorial and/or consulting the help.

[Kurt Hansen]

29 minutes ago, comment said:

Just click OK and Filemaker will insert the field name for you. It will look like this: Varer::KATEGORI. Then click the Calculated result: Specify button and enter the text "instrument" (including the quotes) as the calculation formula.

These are basic script operations; you should know them after having done the tutorial and/or consulting the help.

Aha! Got it. Thanks.

Yes I know that I should (...) but my needs are very modest and irregular; usually just a few times a year. I am not unwilling to make an effort itself, but my experience is that even a very conscientious review of a tutorial is not stored in my memory, so I can remember it next time.