- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2023 11:41 PM
I have a field named "Table" which references sys_db_object. Its default value is the sys_id of "Incident".
I've also defined a Condition Field Form Builder named "Conditions" that is dependent on the "Table" field.
However, no fields are displayed.
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2023 02:45 AM
hi @IgorMK,
Create Table field with type Table Name and give default value as incident
And keep the filter Condition as it is
And it will work like this
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2023 01:58 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2023 07:28 AM - edited 10-17-2023 07:29 AM
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..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2023 02:45 AM
hi @IgorMK,
Create Table field with type Table Name and give default value as incident
And keep the filter Condition as it is
And it will work like this
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2023 07:31 AM
This is the way, it works! Thanks!