[Pansophy] Problem with Projects/L2HE/CavPerfReport.cfm

[Mike Dickey]

Update:

I made a number of changes to the Projects/L2HE/CavPerfGrid.cfm file, including comments (4 total, so far).

Additional problems arose from the fact that the 'dbms_lob.substr(...' string is in a string itself, with commas.

The page is working in DEV, however since there is a lot of data, the column width is narrow, only the first few words can be seen.  I'm looking into using CSS to create a textbox on hover for the CLOB fields.  I'm not sure how well this will work.  I may also look into word wrap and other options.

Once we get the display readable, we'll have to fix the export, which I just tried.  It is having problems too, probably related to the string stuff.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Mike Dickey
Sent: Friday, October 29, 2021 10:18 AM
To: pansophy at jlab.org
Subject: Problem with Projects/L2HE/CavPerfReport.cfm

Hi Megan & Valerie,

I was looking into the problem we have been having with Projects/L2HE/CavPerfReport and I think I may have found an issue in the Projects/L2HE/CavPerfGrid.cfm file at ~ line 26.

<cfset flds = #right(flds, len(flds) - find(".",flds))#>

This line was intended to remove the 'table' from 'table.field' notation.  To deal with the CLOBs, we introduced the 'dbms_lob.substr(...' oracle function to the 'GridFieldNames' string, which is processed by the line above.

I will see what I can do today, but I have a doctor appointment on Monday, and won't be back until Tuesday.

I wanted you to know what I found, in case I can't fix it today.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20211029/d32d10e0/attachment.html>