Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Bugfest. Schema folio_reporting does not appear in query interface

Description

Running in folio-snapshot, the LDP app allows selecting the "public" schema but not "folio_reporting" which contains the derived tables.  I do not know if this involves ui-ldp or mod-ldp or both.  I checked the permissions in the LDP database, and the "ldp" user appears to have access to the "folio_reporting" tables. 

 

This was originally reported by Vandana Shah from Cornell:

Hi Nassib, one of the bugfest tests (Derived Table Test, #T933068) wants me to select 'folio_reporting' as a schema from the Schema drop-down menu in snapshot, but the only option I have is to select 'public'.

 

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Mike Taylor October 27, 2021 at 9:52 AM

When visiting https://folio-snapshot.dev.folio.org/ldp the UI fetches the tables-and-schemas information from https://folio-snapshot-okapi.dev.folio.org/ldp/db/tables

What is returned includes 111 schema-and-table combinations – see the attachment – but all 111 of them have "tableSchema": "public". So I think that the UI is doing the right thing on the basis of the data it's been given. The problem lies either in mod-ldp's response to that request, or in the underlying LDP database.

I am reassigning to MODLDP.

Done

Details

Assignee

Reporter

Tester Assignee

Labels

Priority

Development Team

Thor

Fix versions

Release

R3 2021 Bug Fix

Affected Institution

Cornell

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created October 26, 2021 at 6:09 PM
Updated October 28, 2021 at 3:28 PM
Resolved October 28, 2021 at 3:28 PM
Configure
TestRail: Cases
TestRail: Runs