Hi Wayne,
Indeed, what Valentina wrote above.
It depends on how you manage your categories and ags.
If the assignment group can have only one category assigned to it, then add a reference category field to the assignment groups table (where you have all of your assignment groups).
If an assignment group can appear in more than one category, then you will need a new table where you can specify what's connected where.
Re the reference qualifier, you will probably need to add it to the assignment group dictionary override ref qualifiers and not directly to the field itself, as it is a global field. You will then be able to add a reference qualifier that looks a lot like a simple query or use something like:
javascript:'assignment_group='+current.category
So I think the first question would be - is it a one ag-many categories or one category-many ags relationship ?
harel
Edit:
Added a category field called u_inc_category on the group [sys_user_group] table and configured a category for several groups.
Configured the following Dictionary Override ref qual (table incident): javascript:'u_inc_category='+current.category
Hi Wayne,
Indeed, what Valentina wrote above.
It depends on how you manage your categories and ags.
If the assignment group can have only one category assigned to it, then add a reference category field to the assignment groups table (where you have all of your assignment groups).
If an assignment group can appear in more than one category, then you will need a new table where you can specify what's connected where.
Re the reference qualifier, you will probably need to add it to the assignment group dictionary override ref qualifiers and not directly to the field itself, as it is a global field. You will then be able to add a reference qualifier that looks a lot like a simple query or use something like:
javascript:'assignment_group='+current.category
So I think the first question would be - is it a one ag-many categories or one category-many ags relationship ?
harel
Edit:
Added a category field called u_inc_category on the group [sys_user_group] table and configured a category for several groups.
Configured the following Dictionary Override ref qual (table incident): javascript:'u_inc_category='+current.category
