- 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 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 04:24 AM
You are a Star that worked, I was advised to add it there I will go back to the person that suggested it. Thank you