table not visible in Queries from in Relationships

[BALAJI K R]

Hi,

In the sys_relationship table I'm unable to find the required table in the Queries from table dropdown

Kindly provide your inputs.

[Amit Verma]

Hi @BALAJI K R 

For which tables you are trying to establish the relationship ?

Thanks and Regards

Amit Verma

[Animesh Das2]

Hi @BALAJI K R ,

Please check the attribute value in the dictionary of 'Queries from table'. If 'allow_public=true' is set there. If so then all the tables from all scopes should be available here to be selected.

If you want just a specific table to be selected here, then the attribute value should be 'allow_public=<table_name>'.

If you want specific multiple tables to be selected here, then the attribute should be 'allow_tables=table1:table2:table3:table4' (here colon is used as a table name separator).

Please verify if any of the above attributes is mentioned in the dictionary of 'Queries from table'.

You can have a look at the below support article for more information.

How To Select a Table In Global As Choice Table In Other Application Scopes 

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das