Jump to content
Sign in to follow this  
TomYoung

multiple finds 2

Recommended Posts

take a field, say field A.

Use field A to do a Find & omit action

This Find action produces a found set.

Problem

If you do another find (using field A), it is NOT confined to the found set produced by the first find. Instead, the second find action is applied to the whole set of records.

I've saved various finds (all using the same field) as scripts and want to run them sequentially in another script.

I'm getting nowhere at the moment.

any ideas

t

Share this post


Link to post
Share on other sites

Unfortunately there is not "second" find.

You can restore previous find (Ctrl or Apple +R) and do more requests via additional New Request.

Share this post


Link to post
Share on other sites

shocked.gif" border="0

I have a similair problem:

I'm searching in two different fields with a script, say in field A and B.

In 'A' I'm searching for a department and in 'B' for a taskstatus.

So the result of a multi find in one or two scripts without manuel interaction should be:

Find in A:<department> and in B:<taskstatus>

What ever I do, I seem to get one of them but never the match of both alone at the same time. Or the results seems to be saved in an index so I get the wrong search items (e.g A=facility in A: or B: or in A: and B smile.gif" border="0

After two days of trail and error haven't found the solution.

Can anyone give me the correct script sequence? and the correct meaning of 'restore before and after the paste option in the middle)?

I think the only option left is to merge the fields like <field:A&' '&field:B> than search in that field (a calculationfield).

Or is there still hope of a better solution??

Thanks!

Share this post


Link to post
Share on other sites

shocked.gif" border="0

I have a similair problem:

I'm searching in two different fields with a script, say in field A and B.

In 'A' I'm searching for a department and in 'B' for a taskstatus.

So the result of a multi find in one or two scripts without manuel interaction should be:

Find in A:<department> and in B:<taskstatus>

What ever I do, I seem to get one of them but never the match of both alone at the same time. Or the results seems to be saved in an index so I get the wrong search items (e.g A=facility in A: or B: or in A: and B smile.gif" border="0

After two days of trail and error haven't found the solution.

Can anyone give me the correct script sequence? and the correct meaning of 'restore before and after the paste option in the middle)?

I think the only option left is to merge the fields like <field:A&' '&field:B> than search in that field (a calculationfield).

Or is there still hope of a better solution??

Thanks! nullcrazy.gif" border="0

Share this post


Link to post
Share on other sites

Rob in Holland: you should not *need* a script to perform this find, a find over two fields.

Say a db had fields "country" and "city" then to look for a city called sydney in country australia the find request would be:

city=sydney

country=australia

This is done with just one find request and it's relatively straightforward.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Christoph 
×
×
  • Create New...

Important Information

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