Richard
I cannot see ‘show user’ but that doesn’t matter.
Those supplied queries were a bit of an afterthought. Some of the queries expect parameters and they are passed from one query to another as a GET parameter arg1, arg2 etc.
If you look at the PHP snippet in the first column in ‘show ten users’, you can see
DBView::linkToView("[show posts by user $value]","show posts by user", $value);
which passes $value (which happens to be the user ID) as as argument to another view ‘show posts by user’. Hope this makes sense. Unfortunately those SQL statements with arguments aren’t handled properly when you edit and execute them – something i need to fix.
You can only use query parameters in the admin/dashboard pages. Have a look at this.
Orphaned PHP snippet error is generated when you modify a query and remove a column name to which you have attached a PHP snippet. It’s just a warning.
Sorry the help is a bit limited.
Thank you, John. I suspect it will take a bit of learning to fully utilise the plugin.
Could you explain how I can enter query parameters such as LIKE ‘A%’ from a text box or BETWEEN ‘2000-01-01’ AND ‘2000-12-31’?
I will look forward to the next release where you can pass arguments to queries on public pages.
Thank you . . .
Richard Harding
I think i understand what you want to do. It would not be easy to feed the value of a text box into the query!
Perhaps in a future version I should add an optional query or all column search box.
Thank you. That would be great.
Richard Harding
You can pass arguments to queries on public pages in 0.5.5 (and jump from one table to another).
