How to add new field in web page of ToolsJX

I have a great performance issue and I need to place a new field (check box) on a web page which will alter how search is done with ToolsJX to make it quicker.

I have a db-view which uses many tables with complex joins. One table (storage) is 100000+ rows.
My thinking is to split the big table into two tables - storage and storage_archive and have a UNION when needed.

When a row in storage is approved it normally will get a boolean set to true but now instead I want the whole row to be MOVED to storage_archive.

Almost every search is good enough to only search in storage which usually contains only 100 rows. The check box will be named something like "include archived rows in search (takes long time)"

I know I am a bit out of topic here because ToolsJX is not about check boxes =) How ever the result of dynamically enable the UNION between the tables will affect what the grid will present.

Please advice me with a
-best practice
-link or reference to web sites on how to build this
I understand that part of this is fundamental Joomla/php programming but anyway I need guidance on where to look/read further.

Thanks a million for your wonderful component and effort. You are the best =)


-