FMPRO 8 CWP multiple search or saved found set for additional processing

[the wheelhorse]

I have a database that is being served to the web and we are using the XML/XSLT to retrieve data and display. Works fine.

Presently there are two fields to search, a location and a group of keywords. these are calcultion fields based on other fields in the database.

So right now we are doing a -LOP=and (http query) and the results are perfect.

HOWEVER, the owner wants the search to work different.

He wants it to work like and OR find but not exactly.

He wants the first field to constrain all possible choices that match ANY of the second field.

SO this is like combining an AND and OR search together and I just can't seem to make it work.

I can make the thing work in FMPRO but not from the http query.

(using a multiple find request and some looping)

It seems that we have to do a find, and then another find from those results.

I hope I am being clear. I can give more concrete examples if anyone has a line on this.

thanks

[Mikhail Edoshin]

You can resort to a script to find records. E.g. you can pass search requests via global fields, specify the final script using the ‘-script’ parameter and make the script to use the data from the global fields to find the records.

With FileMaker Server 9 you can specify complex find requests, like A and B or not C. Look up the description of the `-query` tag.

[the wheelhorse]

THANK YOU for the reply.

Do you think you could elaborate more about using the globals and the script or point me towards some documentation?

Any help is greatly appreciated.

I understand you can use the -script part of the query with or without parameters. I am testing a sample today.

It seems like I will need to use some Javascript to concate or parse the text in the field areas to pass them as a parameter?

[Mikhail Edoshin]

You pass field values as usual, but you use global fields. To successfully set a value of a global field in a web session you need to tell FMS the filed is global, so if the field name is “A” you use “A.global”:

...&A.global=first criteria&B.global=second criteria&-script=Adjust Find&-findall

The “Adjust find” script enters find mode, creates correct find requests with values from A and B fields and performs find. The result goes to the browser.