Get Filters

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
haemi
User
Posts: 17

Get Filters

Post by haemi »

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.


arbei
User
Posts: 9292

Post by arbei »

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.


haemi
User
Posts: 17

Post by haemi »

Hello,

I should no which date range a user has filled in.

Example:

Date >= 01.01.2017 and Date <= 31.03.2017

This range i need for further calcualtion inside the query. With sql i do it with params.

Can you give me a hint?

Thank you.


haemi
User
Posts: 17

Post by haemi »

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.


arbei
User
Posts: 9292

Post by arbei »

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.


nbelfort
User
Posts: 2

Post by nbelfort »

You can find the WHERE component of the current page filtered query on:

$this->SearchWhere


Post Reply