Restrict the fields shown in a form

abhinavmoha
Tera Contributor

So I have a form and it gets all the tables from i think sys_db_objects, I want to restrict it to only get certain tables, how do i do this. How do i edit the rules for this form.

abhinavmoha_0-1745491539376.png


how do i restrict this say to use only cmdb tables or use non sys tables?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@abhinavmoha 

something like this for only cmdb tables or non-system tables

To show only cmdb tables use this in advanced reference qualifier

javascript: 'sys_class_nameINSTANCEOFcmdb_ci';

AnkurBawiskar_2-1745502160122.png

 

 

Output

AnkurBawiskar_1-1745502128079.png

 

To block system tables you can check for name [Does not contain] sys

AnkurBawiskar_3-1745502286821.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

8 REPLIES 8

Hi @abhinavmoha ,

 

I believe, You can't include the database views as you are referencing to sys_db_object table.

 

Database views are not getting stored in sys_db_object table. its in sys_db_view table.

 

BR,

Gomathi K

Ok, this worked well but I also want to include database views with this as well, how do I do it?

@abhinavmoha 

I have answered your original question.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@abhinavmoha 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader