Forum Discussion

MichaelGraham2's avatar
MichaelGraham2
Qrew Assistant Captain
9 years ago

I want to be able to create a dynamic type of filter based on a field in a table.

Example:

I have the following tables.

Model, Main Category, Sub Category1, Sub Category2, Parts List,  ControlNumber.

I have a general search which I can choose by selecting Model, then the various categories and this is fine.  However, the other type of search is when someone enters a Control Number.

This number is made up of sections which will break down to the correct Parts List.

12345xxxyyyzzzb1

12345- Model
xxx - Main Category
yyy - Sub Category1
zzz- Sub Category2
B1 - Parts List form

The idea is that when a user enters the Control Number, they get directed the Parts List pertaining to to only that Model with its connected categories and subcategories.

Any ideas how to start?

Thanks.

Forms
reports and charts
Search
  • RohitAgarwal's avatar
    RohitAgarwal
    Qrew Cadet
    8 years ago
    Hi Michael,

    I guess you want to create a search box with a button.
    Steps-:
    1- Get text box value once you click the button.
    2- Hit doQuery API where use this text box value in qlist in order to filter.
    3- so, once you click the button your actually hit an API that will give you the result base on your value.


    I hope this will work. if not then will provide you the code. 

    Thanks,
    Rohit