thong127

filtering

Discussion created by thong127 on Dec 12, 2014
Latest reply on Dec 12, 2014 by erolst

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

Outcomes