sys_choice table is not available for Reference

[Alex248]

Hello,

I have custom application and trying to add a new reference field to sys_choice table, but this table is not available.

I spent some time to investigate this issue and found unexpected condition.

I opened the dictionary of Reference field 

And noticed that sys_choice table was forbidden to be chosen OOTB.

Also there is UI policy "SysChoice reference prevention" that warnings not to use this table in reference type.

I have Orlando release, patch patch7-08-19-2020 installed.

My second DEV instance is on Paris release and there is no such filter.

Have somebody faced with this issue and if there is explanation of this condition in Reference Dictionary?

[Brad Bowman]

I would say to just disable the UI Policy, and find what is preventing it in the Dictionary entry for the Reference field on sys_dictionary, or within the Script Include that it calls.  I don't have a filter in my Paris PDI, or in our Orlando instance, but there also seems to be a Business Rule or Data Policy preventing this, so SN REALLY doesn't think you should be using this as a reference table.  On the surface I don't see anything wrong with it, as long as you specify a table and element, but I haven't had a need for this in practice.  I have used this as a table for a List field.  What is your use case for needing to use this as a reference table, and not a List or Choice?

[Alex248]

Hi Brad,

Thank you for reply.

We need get all choices from parent table and show them on one specific field. Available choices should be filtered depends on selected value from another field. Choice list can be increased and now it more than 40 choices. 

Also all this choices are applicable to many tables. It's something similar to [task] table, but different.

So we need to select sys_choice table and filter all choices based on defined tables. I think we should ask the Support about it.