Hello,Is it possible to get filters set in a view page? I need this information for a further query.Thank you for your help.
In view page only show 1 record, and there is no Filter applied in the view page except the primary key to get the corresponding records.You can always show the SQL which retrieving the records from the database in [Tools] → [Debug].Please tell us the exact meanings of “get filters set in a view page” if above is not your problem.
Hello,I should no which date range a user has filled in.Example:Date >= 01.01.2017 and Date <= 31.03.2017This range i need for further calcualtion inside the query. With sql i do it with params.Can you give me a hint?Thank you.
Hello,I’ve fogot one detail. The view is needed in a crosstab report. In this report i should be able to calculate one amount based on a date range.Thank you.
There are some Server Events that you can access the filters in Crosstab report of PHP Report Maker.e.g. Page_Filtering, Page_Selecting.Read help file topic: “Server Events and Client Scripts” about above Server Event for more information.
You can find the WHERE component of the current page filtered query on:$this->SearchWhere