- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 01:22 AM
Hello All,
I added a new region in the sys_choice table but when I try to add an asset to this new region it is not showing
do I need to add it somewhere else as well?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 02:34 AM
Hi @Ralton Stewart ,
You're stating that you're trying to add an asset? but the new choice is a on the table sys_user - is this correct? If yes, then please give some context on where the custom field is placed, and how you use it from asset.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 04:18 AM
Hi @Ralton Stewart ,
Ok, got it. I just tried the same in my PDI without issues. If you add e.g. "ANZ" to the cmn_location table like below:
It comes directly up when trying to pick location from the sys_user table:
I'm unsure why you have created the "ANZ" in the sys_choice table, as the location field doesn't have choices but instead references from the sys_user table directly to cmn_location table.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 02:34 AM
Hi @Ralton Stewart ,
You're stating that you're trying to add an asset? but the new choice is a on the table sys_user - is this correct? If yes, then please give some context on where the custom field is placed, and how you use it from asset.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 02:45 AM
Anders we have a new region in australia and new zealand and I created ANZ so that when new hardware is assigned I can add anz like the screen grab
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 04:02 AM
Hi @Ralton Stewart ,
Ok, but where is the location field located? on the sys user record or any other table?
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2023 04:07 AM
Anders its on the cmn_location table when I click new and and search for ANZ (new region) I cannot see it.