Dashboard / Report : use @SQL= syntax

Description

Hi,

It could be useful to use the @SQL= syntax when setting parameters for reports displayed on the homepage.

Eg: C_DocType_ID=116,DateAcct=@SQL=SELECT sysdate-10000 FROM DUAL

Regards,

Nicolas

Environment

None

Activity

Peter Takacs 
December 19, 2022 at 7:36 AM
(edited)

Hi , providing the test case:

  • create a Dashboard Content with a report (e.g. Order Detail) and add it to the dashboard

  • on the Dashboard Content in the Process Parameter field set an “ID“ parameter (e.g. C_DocType_ID=124)

  • zoom to the process → process parameter (in our case Document Type) and remove the Reference Key, if it is set

  • in this case “error:_ Exception: Key does not end with '_ID': _“ will be thrown when the dashboard is rendering

Heng Sin Low 
December 16, 2022 at 1:43 PM

hi , please detail the test case that’s fix by the latest PR.

Peter Takacs 
December 7, 2022 at 10:40 AM
(edited)

Reopening because of error:_ Exception: Key does not end with '_ID': _

Solution: We need to send Process Parameter - Column Name to MLookupFactory.getLookupInfo in DashboardController.java

I’ve created a PR with the fix (fixed by )

Nicolas Micoud 
May 11, 2021 at 2:48 PM

Carlos Ruiz 
May 11, 2021 at 11:23 AM

Ah - almost forgot this - can you please also prepare a NF8.2 page in the wiki describing the new functionality?

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created May 6, 2021 at 11:55 AM
Updated February 1, 2023 at 1:48 PM
Resolved December 20, 2022 at 1:14 PM