April 14, 200817 yr 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.
April 14, 200817 yr Try this... Enter Find Mode Set Field [Table::User_ADName; "==" & $ADName] Perform Find That should do it!
Create an account or sign in to comment