How to restrict data of a table reference field in a custom table

ursnani · ‎08-09-2018

I Have a field on my custom table which is

Field Name : Table

Fied type = Table Name

When I created this field Its showing all the tables in Servicenow. But now I want to show only Some set of Table which are my Other Set of Custom Tables.

Can anyoNe please let me know on how to Achieve this

Please find the attachment of my field Dictonary

SanjivMeher · ‎08-13-2018

Reference field mayn't work since you have a condition field dependent on it.

Instead you may try a choice field and manually add the choices to the table field for your custom table.

If you have a Parent table, under which all you custom table are listed, may be you can add base_table attribute to it, which will only show you child table of the parent table.

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

View solution in original post

Rahul Kathuria · ‎08-09-2018

Right click on Choice table-->configure dictionary and set the reference key.

ursnani · ‎08-09-2018

There is not Reference Key, Please find the Attached Pic.

SanjivMeher · ‎08-09-2018

Try using the Calculated value to only return your custom table names using a script

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

ursnani · ‎08-09-2018

H Sanjeev,

What is the code that i have to write here can you please provide me on to render my custom tables that would be a great help