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

Pranay Tiwari · ‎08-12-2018

Hi Ursnani,

Goto Dictionary Entry and click on Advanced view >Default Value select Use dynamic default then select dynamic filter.

You create a dynamic filter(for filter out the field values) and write an script according to your requirement.