We have several list that need to be cleaned up. Items in our dropped down are no longer releveant. If i delete the field how can we later search. My consern is that we will not remeber what the field was called or that it existed. take for example Clovis PD, no longer needed. When i remove it, its no longer part of the search .
Question
Question
Replies
Hi Teresa,
I have run into similar situations where our list values have been modified and documents using older values need modified. Without knowing what those older values are, the only way I have been able to accomplish this is by querying the repository database directly.
To get a list of all the metadata fields using old list values I would perform the following queries in the repository database:
Find the property id for the metadata list field in question:
SELECT * FROM propdef where prop_type = 'L'
I'm looking for our list field called 'Section' and see that it has the property id of 49.
I can then use that id (49) to return a distinct list of all values used in that metadata list field (from propval table) while removing any values that are currently configured in the metadata list ( lup table). Resulting in all the old list values that are still used in the repository but not currently part of your metadata list.
SELECT DISTINCT str_val FROM propval where prop_id = 49 and str_val not in ( SELECT list_val FROM lup where prop_id = 49)
Results can be used to run manual searches, queries expanded to return document lists, or put into a workflow to automate document changes, etc.
Hope that made a little sense and helps!
This exact use case is why the input field in search allows the user to enter text that is no longer part of the list. So it's going to be possible to run a search with the old value. But you bring up a good point - if the value is not part of the dropdown, the user needs to enter the value without assistance, and they might need you to explain why it's not there. What's really going to help is the consistency of your values, visible in the screenshot. I would think that would be enough guidance for a user to understand how to correctly enter the name of the agency so that it matches the records they are looking for.
I get the text field, the problem is that if we do not know what the label was, Laserfiche will not locate the document. The above was an easy list I used as an example, but we have one for "Document type" that is more complex. Alot of those document types are no longer needed. we want to remove them, that way users don't have to scroll through unnecessary document types. The issue is that down line we will not remember what they were labeled as new people come in and the original people who build it will be gone. Type in the text field will not help, if we don’t know what we are looking for. Below is the Document list.
B109 - Commitment
AB109 - Flash Incarceration
AB109 - Probation Forms
AB109 - State Sentence Revocation
Administrative Segregation Placement Notice
Arrest Report
Behavior Management Plan-Initial
Behavior Management Plan-Review
Body Receipts
Bond Surrender
Bonds
CalAIMS
Certificate of Release
CHP Book and Release
Class-Admin Action Review
Class-Alert Notice
Class-Misc
Class-OHU Custody Placement
Class-Questionaire
Class-ReClass
Class-Restrictions
Class-Review
Class-Special Housing Needs
Class-Suicide Risk
Communications/Teletype
Critical Incident Review
DA Filing Packet
DA Intake Form
Death In-Custody
Deceased
Detainer
Discipline Property Form
Disposition
DNA IB
Drug Analysis Report
Federal Hold
Federal Release
Filing Slip
Grievance
Grievance - Medical
Hold Form
Hold Release
Hospital Log
IB-Arrest Report
IB-DOJ Correspondence
ICE Communication
ICE Consent Form
ICE Detainer 247-A Form
ICE Request Notification
Inmate Property Envelope
Jail Cite
Jail Incident Report
Legal Mail Open
MAGEC-FI Cards
MAGEC-Gang Reports (Pre AFR)
MAGEC-Other Agency Gang Documents
MAGEC-Other Gang Documents
MAGEC-Photos
Medical Records
Mental Health -Crisis Mgmt Plan
Misc.
Money Receipts
Notice of Additional Charges
Overcrowding Release
Pawn Slip
PC969 Packet
PREA Acknowledgement
Pregnancy/Lactation
Pretrial Release Per Emergency Rule 4
Professional Correspondence
Prop47 Mod
Property Release Authority
Prosecution Determination
Rec-Citations
Rec-EPO
Rec-Forensic Lab
Rec-Property
Rec-Reports
Rec-Requests
Rec-Vehicle
Rec-Warrant
Registrant
SAR-Briefing
SAR-Clues
SAR-Debriefing
SAR-Maps
SAR-Misc
SAR-Missing Person Form
SAR-Radio Log
SAR-Roster
SAR-Team Assignment
Scars, Marks & Tattoo's
SO-13 (Juvenile)
Strip Search Form
Superior Court Order
Suspect Demographics
Test
TJC-Assessments
TJC-Certificates
TJC-Contracts
TJC-GED
TJC-Minute Orders
TJC-Miscellaneous
TJC-Offendertrak documents
TJC-Personal Summary
TJC-Release of Information
TJC-Sharenet Documents
TJC-Unit file checklist
Warrant Abstract
Warrantless Arrest Declaration
How about keeping an unalterable document in the top folder called "Archival document names"