Jump to content

multiple finds 2


TomYoung

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

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

Link to comment
Share on other sites

  • 4 weeks later...
  • Newbies

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!

Link to comment
Share on other sites

  • Newbies

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

Link to comment
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.

Link to comment
Share on other sites

This topic is 8193 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
×
×
  • Create New...

Important Information

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