I'm trying to create a Stored Query that lists the Change Orders without any children.
I've tried with the following syntax:
children.length = 0
but I get the following error message: AHD05800: Bad where clause. invalid constraint. Unable to resolve children .
I even tried with the following syntax:
children.0.chg_ref_num = \'\'
but I obtain the same message error.
Does anybody have any ideas?
Is the only possible solution to add a custom field (zchildren_num) to set by a custom trigger?
Thank you everybody!