i creating simple app admin can filter users on basis of several criteria a,b,c,d,etc..
i looking implement functionality admin can save created search filter later use. search filters can of several types , can have different values. also, search filters have common attributes.
can give me idea of database schema storing such search filters in database. should store mysql clauses in database "where < 1000", "where b=1"...? or should store entire query gets generated?
kindly suggest me suitable database schema store such filters can retrieved later use.
