The Field Condition Builder with a dependent reference field doesn't show related field

IgorMK
Tera Contributor

I have a field named "Table" which references sys_db_object. Its default value is the sys_id of "Incident".

IgorMK_0-1697524497715.png

 

I've also defined a Condition Field Form Builder named "Conditions" that is dependent on the "Table" field.

 

IgorMK_1-1697524563595.png


However, no fields are displayed.

IgorMK_2-1697524688454.png

 

How can I solve this problem?

I know that the Condition Builder works with a "Table Data" type, but I would like to use the reference. My idea would be to create a field "Abc" of the "Table Data" type in the table and transfer the value from "Table" to "Abc" using a Business Rule.

Do you have other solutions?

1 ACCEPTED SOLUTION

Uday Soni05
Tera Guru

hi @IgorMK,

Create Table field with type Table Name and give default value as incident

Screenshot 2023-10-17 at 3.11.46 PM.png

And keep the filter Condition as it is

Screenshot 2023-10-17 at 3.13.31 PM.png

And it will work like this

Screenshot 2023-10-17 at 3.14.16 PM.png

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

View solution in original post

4 REPLIES 4

Community Alums
Not applicable

Do you want to see all incidents (like from incident table the condition be like "short_description=='blahblah' impact==1" or you want to select the types of fields you have in the incident table definition ?
If first you need to point to incident table not sys_db_object (the table definition itself - this would do any good if you are dynamically doing stuff with under the hood structure).
Also, note that you should use singular names for tables and columns - yours is "tables" bad practice which will bring unexpected behaviours.

Hey, thanks for your advice! I wanted to select the types of fields i have in the incident table definition. Incident is just an example here, what's important for me is that the condition works in the form. I will simply use the "Table Name" type..

Uday Soni05
Tera Guru

hi @IgorMK,

Create Table field with type Table Name and give default value as incident

Screenshot 2023-10-17 at 3.11.46 PM.png

And keep the filter Condition as it is

Screenshot 2023-10-17 at 3.13.31 PM.png

And it will work like this

Screenshot 2023-10-17 at 3.14.16 PM.png

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

This is the way, it works! Thanks!