Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Performing Find using an exact field content match with a variable through a scripted search


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

Recommended Posts

Posted

I am trying to perform a find using an exact field content match with a variable through a scripted search. I have tried two different ways to perform a search to show appropriate records and I'm not having any luck getting it to run correctly.

First way:

Set Variable [$ADName; Value:Get(AccountName)]

Freeze Window

Enter Find Mode []

Set Field [Table::User_ADName; $ADName]

Perform Find []

## This way doesn't work because if I have users with nearly the same ADName, the search finds records regarding both of those accounts instead of just the one I was looking for. Example: I do a search for JoniS, but I get records for JoniS, JoniS1, JoniSmith, JoniSanford, etc. And I can't figure out how to insert the double equal sign to perform a field content match search this way.

Second way:

Set Variable [$ADName; Value:Get(AccountName)]

Freeze Window

Enter Find Mode [Restore]

## I specified the Find Request in the

## "Enter Find Mode" line above -

## Table::User_ADName:[==$ADName]

Perform Find []

## This way doesn't work because the find request searches for the text "==$ADName" instead of using the variable value.

There has to be a way to do an exact field content match using a variable through a scripted search. I just can't figure it out on my own today.

Posted

Try this...

Enter Find Mode

Set Field [Table::User_ADName; "==" & $ADName]

Perform Find

That should do it!

This topic is 6068 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.