Master table data is not displayed on the portal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2024 05:34 PM
Is there any way to prevent specific data in the Master table from being displayed on the portal without deleting the data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2024 08:28 PM
Hi, I'm not sure what the master table is? but normal practice would be to use a filter based on some field from the table, a common example would be active=true. If there is no field in your dataset that can deliver this requirement then perhaps you could add a bool true/false field to the table IE show_in_portal and use this as your data filter.
Depending on your solution\requirements you could also potentially use ACL and\or query business rule.
But, if you are exposing one of ServiceNow's key system tables to your users via portal, then rather than adding a field to allow visibility, you might want to rethink your solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2024 09:39 PM
Thank you very much for your answer.
For example
I have three records A, B, and C in my Master table. I refer to this table in the variable Name (type: List Collector) of Record Producer. Now I want to prevent the information of record B from being displayed on the portal screen.
Master table
portal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2024 01:32 PM
Hi, your record producer variable has a 'Type specification' tab with a reference qualifier field.
To filter our records from your reference field, you would use this just as you would for any backend table view.