I have a requirement to bring all mandatory fields for a particular CI class into a breakdown. However, I’ve noticed an issue: some fields show a false value in the mandatory column within the sys_dictionary table while the sys_dictionary_override table has the mandatory column set to true for the same fields. My goal is to retrieve all fields where mandatory = true for inclusion in the breakdown. I attempted to use dot-walking between the sys_dictionary and sys_dictionary_override tables but couldn’t find a suitable field to achieve this, nor a combined view that would allow me to pull this data directly. Could someone please advise on how best to proceed or suggest an alternative approach?
Thanks
