Using Extend Found Set with a Variable

[csmedsrc]

I have a script that searches two fields on a table: account name and status

At the start of the script I define a variable $un with the Get (Account Name) function. It then enters find mode, insert $un into the account name field, and insert "Pending" into the status field. Perform find and everything works.

The problem is that when I try to extend the found set to also include the status of "Approved", I do not get the desired results. If I only add the "Approved" criteria it returns with approved records for users other than $un (it also includes $un).

If I extend the found set with the criteria of status = "Approved" and account name = $un, I do not get any additional results.

How can I perform a find that returns records for the user $un (the current account name) and a status of Pending or Approved?

[fRESH_OiL]

You need to enter find mode, insert the text into the field and then perform a find b/c you can't use variables in a find. I know, it sucks.

[csmedsrc]

Thanks for the info. I went with constraining the found set by omitting the one status I didn't want to see.

[comment]

How can I perform a find that returns records for the user $un (the current account name) and a status of Pending or Approved?

Enter Find Mode []

Set Field [ Table::AccountName ; $un ]

Set Field [ Table::Status ; "Pending" ]

Duplicate Record/Request

Set Field [ Table::Status ; "Approved" ]

Perform Find []