Add a Column in Country country_core Table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 07:18 AM
The Table: Country [core_country] are we able to add a column ‘Blocked Country’ as a true/false field to identify what countries are blocked. If the blocked country status changes, we won’t need to update the form. The workflow will be off of Blocked Country = True.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2023 07:27 AM
you need to be careful in creating custom fields on OOB tables.
Country is a table which comes as part of foundation data and won't frequently change.
What should happen if the field changes to false? which form won't be allowed to update?
Please explain your business requirement in detail.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 05:09 AM
Below should be the three tasking scenarios.
Scenario 1: Do you intend on logging in or working from the listed country(ies) = NO
· Task 1 - US-IT-SRM-SecOps-DR, Notification of International Travel - <Requested For>
Scenario 2: Do you intend on logging in or working from the listed country(ies) = YES and Blocked Country = False
· Task 1 - US-IT-SRM-SecOps-DR, Notification of International Travel - <Requested For>
· Task 2 - US-IT-SRM-SecOps-Tier1, Notification of International Travel - <Requested For>
· Task 3 - US-IT-SRM-IAM, Notification of International Travel – Add Okta Groups
**Return Date Selected**
· Task 4 - US-IT-SRM-IAM, Notification of International Travel – Remove Okta Groups
Scenario 3: Do you intend on logging in or working from the listed country(ies) = YES and Blocked Country = True
· Task 1 - US-IT-SRM-SecOps-DR, Notification of International Travel - <Requested For>
· Task 2 - US-IT-SRM-SecOps-Tier1, Notification of International Travel - <Requested For>
· Task 3 - US-IT-SRM-IAM, Notification of International Travel – Add Okta Groups
**Return Date Selected**
· Task 4 - US-IT-SRM-IAM, Notification of International Travel – Remove Okta Groups
· Task 5 - US-IT-SRM-SecOps-Tier1, Change Password - International Travel to Blocked Country
And True/false will be done by client. I need to create only Column in Core_country Table.