1 Reply Latest reply on Dec 12, 2014 1:19 AM by erolst

    filtering

    thong127

      Hello All,

       

      I have a Table name Assets. I am trying to filter my records, but its not filtering.

      Any Help is highly appreciated.

       

      Thank you.

       

      Please find below info.

       

       

      Product Name ( text field)

      Category (text Field, Radio Button; Values: API, Bottle, Closure, Capsule, Excipient, Label)

      Category Filter (text Field , Global, Pop Up; Values: All, API, Bottle, Closure, Capsule, Excipient, Label) Script trigger (Trigger Category Filter) On Object Save

       

      Trigger Category Filter

       

      Set Error Capture [on]

      If [Assets::Category Filter = "All"]

      Show All Records

      Else

      If [Assets::Category Filter = "API"]

      Perform Script ["API"]

      Else

      If [Assets::Category Filter = "Bottle"]

      Perform Script ["Bottle"]

      Else

      If [Assets::Category Filter = "Capsule"]

      Perform Script ["Capsule"]

      Else

      If [Assets::Category Filter = "Closure"]

      Perform Script ["Closure"]

      Else

      If [Assets::Category Filter = "Excipient"]

      Perform Script ["Excipient"]

      Else

      If [Assets::Category Filter = "Label"]

      Perform Script ["Label"]

      Enf If

      Enf If

      Enf If

      Enf If

      Enf If

      Enf If

      Enf If

       

      Script for API

       

      Enter Find Mode

      New Record/Request

      Set Field [Assets::Category; "Bottle"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Capsule"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Closure"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Label"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Excipient"]

      Omit Record

      Perform Find

       

      Script for Bottle

       

      Enter Find Mode

      New Record/Request

      Set Field [Assets::Category; "API"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Capsule"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Closure"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Label"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Excipient"]

      Omit Record

      Perform Find

       

       

      Script for Capsule

       

      Enter Find Mode

      New Record/Request

      Set Field [Assets::Category; "API"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Bottle"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Closure"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Label"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Excipient"]

      Omit Record

      Perform Find

       

      Script for Closure

       

      Enter Find Mode

      New Record/Request

      Set Field [Assets::Category; "API"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Bottle"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Capsule"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Label"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Excipient"]

      Omit Record

      Perform Find

       

      Script for Label

       

      Enter Find Mode

      New Record/Request

      Set Field [Assets::Category; "API"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Bottle"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Capsule"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Closure"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Excipient"]

      Omit Record

      Perform Find

       

      Script for Excipient

       

      Enter Find Mode

      New Record/Request

      Set Field [Assets::Category; "API"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Bottle"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Capsule"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Closure"]

      Omit Record

      New Record/Request

      Set Field [Assets::Category; "Label"]

      Omit Record

      Perform Find

        • 1. Re: filtering
          erolst

          Try this single script:

           

          If [ IsEmpty ( Assets::Category Filter ) ]

            Exit Script

          End If

          Enter Find Mode

          Set Field [ Assets::Category ; Assets::Category Filter ]

          Set Error Capture [on]

          Constrain Found Set [ ]

          # error trapping steps