'controlled.allowOtherValues':true prevents filter from working in templated queries

Description

Overview : When creating a report for the templated queries functionality in the Reporting app, filters with ‘controlled.allowOtherValues”:true in the JSON file that outlines parameters won’t work.

To reproduce :

  • In folio-snapshot, open Settings and go to Reporting.

  • Under ‘Report repositories’, add the following repo by clicking on the ‘+' , adding the following information, and then clicking 'Save’ :

    • GitHub user = metadb-project

    • Repository name = metadb-examples

    • Branch = main

    • Directory = folio/reports

  • Open the Reporting app and choose the ‘Run reports’ function.

  • Click on the ‘Count loans and renewals’ entry from the metadb-project/metadb-examples GitHub repository.

  • Try typing in the ‘Permanent location filter’ text box.

Expected result : either I can type a name in the box or choose from the dropdown that appears when I start typing.

Actual result : I can neither type an option or choose from the drop-down that appears. The filter won’t allow any input.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

4

Checklist

hide

Activity

Show:

Mike Taylor September 18, 2024 at 2:42 PM

LOL

Charlotte Whitt September 18, 2024 at 2:21 PM
Edited

I’m so, so sorry - I understand that now your patience with me got to a point where you simply moved on

You did right. All good.

Mike Taylor September 17, 2024 at 12:02 PM

Since has never responded to my clarification above and is now on vacation, I'm going to go ahead and close this long-ago-complete issue as Done.

( Feel free to file a new issue for “No such report” if you think the present behaviour is wrong.)

Mike Taylor September 9, 2024 at 2:51 PM

Calling !

Mike Taylor September 4, 2024 at 4:42 PM

The “something went wrong” is because when you refresh the FOLIO UI, the tabs you created for reports are lost, and the URL you are trying to visit doesn’t exist. (That's what “No such report” is telling you — maybe more explicit wording might help.)

Before that point, what is it that you think went wrong? The Metadb database that snapshot is connected to is not fed from the snapshot FOLIO, so you can’t have any expectations about what results a report will find.

This issue was about controlled.allowOtherValues:true no longer preventing values from being entered into the form element, and I think that’s fixed. Do you disagree?

Done

Details

Assignee

Reporter

Tester Assignee

Labels

Priority

Sprint

Development Team

Thor

Fix versions

Release

Ramsons (R2 2024)

RCA Group

Incomplete/missing requirements

Affected releases

Quesnelia (R1 2024)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created March 22, 2024 at 4:11 PM
Updated September 18, 2024 at 2:42 PM
Resolved September 17, 2024 at 12:02 PM
TestRail: Cases
TestRail: Runs