New Region

Ralton Stewart
Tera Guru

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?

 

 

RaltonStewart_1-1700212911765.png

 

2 ACCEPTED SOLUTIONS

AndersBGS
Tera Patron
Tera Patron

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/

View solution in original post

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:

AndersBGS_0-1700223404139.png

It comes directly up when trying to pick location from the sys_user table:

 

AndersBGS_1-1700223454344.png

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/

View solution in original post

6 REPLIES 6

AndersBGS
Tera Patron
Tera Patron

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/

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

 

RaltonStewart_0-1700217883146.png

 

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/

Anders its on the cmn_location table when I click new and and search for ANZ (new region) I cannot see it.