What is the best way to hide a record?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2022 01:52 PM
We have a table with a number of records. This table is referenced in a variable on catalog items for the customers to select.
A few if the records in that table are no longer required and I would like to make it so they are no longer visible to the customer to be able to select on the form.
Is there an easy way to make the record "inactive" within the table? Or do I have to restrict it on the catalogue item form itself.
What is best practice for this type of question please?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2022 01:59 PM
I would definitely go with an "Active" field on the table and add a reference qualifier so that the Variable only looks at the records where Active is True.
You will notice that most tables in the platform have an "Active" field, or should 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-24-2022 05:18 PM
Thank Jim,
How do I make that record in active? I have opened the record and checked the form and there is no "Active" on the form and there does not appear to be an option to add it in the configure form layout option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-24-2022 05:35 PM
Hi, Jim's post indicates that you can add a custom yes\no field on the table called 'Active' and then set this as true\false as a way of showing if a record is 'active'.
You can then hide\filter records based on this 'Active' field via ACL's table filters, reference qualifiers, Query Business rules etc.
Based on your question\response I would recommend that you review the vendor documentation and work through the leaning options available on the developer portal using a Personal Developer instance, before you undertake any customization of the platform.
The learning material and registration for a PDI are both available here
developer.servicenow.com/
OOB all of the task tables have an 'Active' true\false field
and so if you want to better understand usage you can review tables like incident in a PDI.