Great. Thanks. Then consider this ticket done (IMO).
Mike Taylor November 3, 2023 at 6:33 PM
That's correct — the UI can't parse the SQL file so its defaults are "invisible" to the user. The idea is that they pertain behind the scenes, whereas those in the JSON file are presented to the user.
Corrie Hutchinson November 3, 2023 at 5:43 PM
Defaults outlined in the .json file populate the 'Instructions' section of a 'Run report' as expected (see Screenshot_2023-11-03.png attachment).
I cannot tell that defaults defined in the SQL query are being implemented. They don't populate the 'Instructions', like those in the .json file, and there isn't any communication on the results screen that they were used.
Nassib Nassar November 2, 2023 at 5:17 PM
I have attached an image showing a repository configuration with test queries that can be used.
Corrie Hutchinson November 2, 2023 at 3:23 PM
Is there a test query I can use for this ticket? Or should I create my own? Thanks.
In the JSON metadata file for a report (as described at https://github.com/folio-org/ui-ldp/blob/master/doc/reports.md#writing-json-metadata-for-your-report), there is currently no way to specify a default value for a parameter. There should be.