AnsweredAssumed Answered

Stored Query - List of Change orders without any children

Question asked by masem04 Employee on Jan 15, 2016
Latest reply on Jan 21, 2016 by cdtj

Hello everybody!

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!

Outcomes