Scoped application needs to create columns in global "sys_" tables. How to do this?

jonathan_luste
Giga Expert

We are building a few things to make Subscription Management actually usable.  We have the majority of things scoped, however there is a requirement to add a related list field/column to the sys_user_group table (as well as a choice field value for another field on that table).

How can we add this "code" to our scoped app so that it gets installed as part of the published app's installation?  

 

Does this make sense?

6 REPLIES 6

SanjivMeher
Kilo Patron
Kilo Patron

Do you just want to add a record in the related list or add a field?

 


Please mark this response as correct or helpful if it assisted you with your question.

Add a field.  We are creating a relationship between a new table and record type and the sys_user_group record.  We might lean towards a scoped m2m table but that also has us stuck with related list filtering.

Is you table extended from Task? If not at least one table has to be primary table and all other tables should be created as child table....And in that table, if you have a field reference to sys_user_group, it auto-adds to the related list of user group...You dont need to create a table or field in global scope ....


Please mark this response as correct or helpful if it assisted you with your question.

Amit Verma
Kilo Patron
Kilo Patron

Hi @jonathan_luste 

 

Please have a look on the below post which explains your requirement :

https://www.servicenow.com/community/app-publisher-forum/adding-scoped-field-to-global-table/m-p/206...

 

Thanks & Regards

Amit Verma


Please mark this response as correct and helpful if it assisted you with your question.