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

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/

Ralton Stewart
Tera Guru

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