AnsweredAssumed Answered

Constraining found set need help

Question asked by bookalaka on Aug 4, 2018
Latest reply on Aug 12, 2018 by philmodjunk

Hello,

 

I am employing a technique Mat Petrowsky offers on his "Quickfind coolness solution" which involves filtering through 2 global fields. I am wanting to modify one procedure but have not been successful in the "Constraining the found Set". In the solution from 2012 what does work involves a very long and tedious entry time.

 

Thanks in advance!

 

My Two global fields are SearchNamePop Up and WineryCode_PopUp

 

  • Technique Scripts: 3_Constrain Search Matt Petrowsky (I have over 500 entries and I want to avoid this process)

 

If [ InterfacePeople::WineryCode_POPUP = "CPL" ]

Constrain Found Set [ Specified Find Requests: Find Records; Criteria: InterfacePeople::WINERY_CODE: “CPL” ] [ Restore ]

Else If [ InterfacePeople::WineryCode_POPUP = "DYZ" ]
Constrain Found Set [ Specified Find Requests: Find Records; Criteria: InterfacePeople::WINERY_CODE: “DYZ” ]

[ Restore ]

Else If [ InterfacePeople::WineryCode_POPUP = "HLT" ]
Constrain Found Set [ Specified Find Requests: Find Records; Criteria: InterfacePeople::WINERY_CODE: “LGD” ]

[ Restore ]

Else If [ InterfacePeople::WineryCode_POPUP = "FXN" ]
Constrain Found Set [ Specified Find Requests: Find Records; Criteria: InterfacePeople::WINERY_CODE: “FXN” ]

[ Restore ]

End If

 

  • USE_CONSTRAIN - I am trying to use instead

Set Field [ InterfacePeople::SearchNamePopUp; "" ]

Set Variable [ $CODE; Value:InterfacePeople::WineryCode_POPUP ] Enter Find Mode [ ]
Set Field [ InterfacePeople::WINERY_CODE; $CODE ]
Perform Find [ ]

Constrain Found Set [ ]

 

 

 

 

Technique Scripts: 2_Search  (This is the main script and I'd like  to replace  the  Perform Script [ “3_Constrain Search” ] End If 

with the one above  USE_CONSTRAIN.


If
[ Get ( CurrentTimestamp ) - $$SEARCH.LASTKEYSTROKETIME 1 ]

Install OnTimer Script [ ]
Set Error Capture [ On ]
If [ IsEmpty (InterfacePeople::SearchNamePopUp) ]

Show All Records

Exit Script [ ] End If

Set Variable [ $object; Value:Get ( ActiveLayoutObjectName ) ]

Perform Quick Find [ InterfacePeople::SearchNamePopUp ]
If [ InterfacePeople::WineryCode_POPUP "000" ]

Perform Script [ “3_Constrain Search” ] End If

Go to Object [ Object Name: $object ] End If

 

 

 

Attached are some screenshots of my table.

 

I want to be able to  Search by wine code first and filter then down to specific wine

Outcomes