Jump to content
Sign in to follow this  

Find on Value list and another field

Recommended Posts

I am trying to find all open trouble reports against one software version.

I have two fields Status = open, work in progress, assigned etc. Status has 6 values.

So my first find is to find all TR's that are open.

I created a script and it works.

The second part is I want to now find the Software version that has open TR's.

Every time I try to find in the same script with the open find I get all the status options against the one software version.

What I want is all the open staus values against one software version.

Seems I can do either or but not both in the same script.

Share this post

Link to post
Share on other sites

I'm not really sure what you are asking. Do you want to find a particular status AND a particular version? Or, do you want to find all the versions with open TR's? "find the software version that has open TR's" has me confused.

If you wish to find the open TR's for a given version:

Allow User Abort(off)

Set Error Capture(on)

Enter Find Mode()

Set Field (Version, "" <-- just a little programmer humor

Set Field (Status, "open")

Perform Find()

I think your error might be using two finds. Each find operates over the whole file. Two finds in a row do not narrow a search as the second DOES NOT operate on the found set of the first. To perform an AND make more field entries in the same find request. To perform an OR create more find requests.


Share this post

Link to post
Share on other sites

Thanks for responding.

I want to find all open status values against one version

I did the open status with

Enter find mode


Set field ( status, "ready for test")

New record/Request

Set field ( status, "assigned")

New Record request

Set field ( status, "need more info)

New Record Request

Set field (status, " deferred")

New Record Request

Set field (status, "work in progress"

Perform find

This script works, now I just need to find a software version with the open status. In other words I want all open status values for one given software version.

The softwar version is what I cant seem to get.

I tried to do another

New Record/Request

Set field (software version, "GW")

then do the find and it finds all GW's but with all staus open and closed.

Share this post

Link to post
Share on other sites

You've set up an OR search that will find all records whose status is open OR whose version is "GW". You want to find only those records whose status is open AND whose version is "GW". The problem is that finding records with an open status requires an OR search by itself, so you need to combine them on each request:

(status="ready for test" AND sw_version="GW") OR (status="assigned" AND sw_version="GW") OR ...

Try this:

Enter Find mode

Set Field ["software version",""GW""]

Set Field ["status", ""ready for test""]

Duplicate Record/Request

Set Field ["status", ""assigned""]

Duplicate Record/Request

Set Field ["status", ""need more info""]

Duplicate Record/Request

Set Field ["status","" deferred""]

Duplicate Record/Request

Set Field ["status",""work in progress""]

Perform Find

Duplicating each find request saves you from having to set the software version field each time since it doesn't change.

Share this post

Link to post
Share on other sites


Could you explain the "little programmer humor" to me please?

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.

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  

  • Create New...

Important Information

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