[Pansophy] NCR Datamining

[Mike Dickey]

Hi Valerie,

I'm looking at this, but it looks like one of your queries.  It looks like a CLOB or BLOB situation that will need something like this

dbms_lob.substr(DescribeComment,500,1) DescribeComment

to fix it.  There are also some linked documents where the link that don't have links.

I'm not sure how to approach making corrections for this query.

Give me a chat after you have had a look.

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

From: Pansophy <pansophy-bounces at mailman.jlab.org> On Behalf Of Tiffany Ganey
Sent: Tuesday, September 6, 2022 12:57 PM
To: pansophy at jlab.org
Subject: [Pansophy] NCR Datamining

Could you please fix the DescribeComment column in the C100R-NCR Datamine VARGRID report so that it shows the text (similar to how the full comment text shows when you go through the QCReports for C100R-NCR)?  Right now the DescribeComment column shows as "gibberish" (see screenshot below) when you try to get to a summary from the Datamine area.

[cid:image001.png at 01D8C1F6.2E893850]

Tiffany Ganey

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20220906/1ec47c67/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 154167 bytes
Desc: image001.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20220906/1ec47c67/attachment-0001.png>