Advice needed - Complex multi-page search

[tcranford]

Greetings All,
I'm about to start work on a complex search form operating on very large tables. I'd like to get some advice on the best approach to tackle this within Fabrik. Assume that I will always be on the current stable rev of both J! and Fabrik.

Requirements - Multi-page form

• Page 1 - gather user input for search criteria using several fields
  
• Page 2 - show interim search results as a list and allow user to select records to consider for summary
• Page 3 - using records selected in page 2 create a summary view

How I THINK this should be solved but not sure of the specifics on the HOW

• After "Next" is selected on Page 1 use a PHP script to build a MYSQL view using the user input.
  
• View needs to be specific to user session (multiple users will be using the system so a common View name probably won't work).
• Page 3 Summary would show the results from the created view as well as a few other table look-ups based upon Page 1 user input

Is it possible within Fabrik to base a List on a temporary View (or temporary table for that matter)? Failing that, what other creative solution would work to satisfy the requirements?

Thanks in advance!

 

[cheesegrits]

Can you describe more what you mean by "summary view"?

-- hugh

 

[tcranford]

Hey Hugh,
Summary (page 3) is really a composite of:

• results from the selections done from page 2
• results from a query done on a completely different table/list

My main concern is the building of page 2 of the form using either a built view or temporary table.
Thanks!