NF8.2 Dashboard Report Use Sql And Range Parameters

From iDempiere en

Feature: Dashboard Report Use Sql And Range Parameters

Goal: Functional

Developer: Nicolas Micoud and Carlos Ruiz

Description:

It is now possible to use @SQL= notation and set range parameters for embedded report on the home page.

Separator of parameters is the comma

Separator of from/to parameter is the semicolon

Simply fill the Process Parameters field of the Dashboard Content window:

DashboardReportUseSqlAndRangeParametersSetup.png

Eg: C_DocType_ID=116,DateAcct=@SQL=SELECT SYSDATE - 30 FROM DUAL;@SQL=SELECT SYSDATE FROM DUAL

It means that the report will filter data

- for Document Type 116
- for dates between D-30 and today

Technical Info: IDEMPIERE-4781

Cookies help us deliver our services. By using our services, you agree to our use of cookies.