I continue to wonder, even with newest PHPRunner builds why this problem (for me) continues:
EXPORT RESULTS for a VIEW never exports the same Print & Export settings and Visual pages in the PHPRunner project itself.
As soon as I ask for [b]Export Results and then select "All records" PHPRunner simply sends the raw table fields values that the View was based on.[/b]
So no matter that I have set up the Fields, the Totals & reviewed the Results in the Editor panels, even including setting separate pages for List, View, Export, Print, Search, etc.---the xlsx or CSV export ignores all of that, ignores the fields I chose not to show, and simply dumps the whole table and all of its fields.
But the extra fields shown online in the List view and all through the Runner Project are EXCLUDED when I want to Export this view.
And the sql is a simple join to pick up 2 fields from another table.
It is already cached when it shows up in the List page so why this behavior once I want to Export the view?
The ONLY Export that shows the View correctly is when I check records in the List view. That is the only time the Export is correct.
But with over a thousand records it is not something feasible to ask a user to do... to try to load ALL records in List and then Check them en masse.
- Once I make a View I always have to go Recreate it in a table, then make new pages based on this table created to hold every field of my view query.
- Only then can the User Ask for an Export and get every field in the View and excluding the fields I have deselected to be included.
- The next step is that I have to create another script and the whole sql query to keep inserting new records on a user save into the table to fake the View.
I am puzzled why this unintuitive function remains the same with each update of Runner.
A view should be preserved exactly as displayed in the List page when it is to be Exported whether 5 records or 1000+.
Thank you for any helpful answers.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=22982&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=22982&image=2&table=forumtopics' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=22982&image=3&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />