In Openmaint 3.1.1, I am trying to create a “Unit/Section” card under “Locations”. I am able to see values in “Complex” drop down. But corresponding to “Complex” selected, corresponding buildings does not get populated in "Building dropdown. But same drop down cascading works perfectly when I create a floor card. Any idea why this is happening when creating “Unit” card only?
The Complex you have chosen contains at least one Building?
Yes. It has many buildings under it. Attaching a snapshot ofdata below.
Complex List:
Building List for above Complex:
When I try to create a floor, I select complex and the building drop down gets automatically populated as shown in below snapshot. But this does not happens when I try to create Unit/Section card. The building drop down does not gets populated with values with same complex selected. Although I have only One complex in the system as of now.
Any clue guys on the basis of snapshots I posted above?
Guys hoping to get some clue on this with start of the new year 2020 
We did a check and found an error in the filter set on that attribute.
We have already corrected and the next release will no longer have the error.
To correct your application immediately, go to the Administration Module and from the navigation menu go to: Classes => Standard => Site => Unit, then move to the center on the “Attributes” TAB and on the “Complex” attribute.
You must then edit the attribute properties, and in the field “Type properties” property “Filter” you must replace the filter “from Building where Complex = {client: IsInComplex.Id}” with "from Building where Complex = {client: Complex. Id} ", and then save the correction.
Thank you for your reply. I would get the things updated at my level as you mentioned and will confirm the result.
Ok. I did the change as you suggested. But when edit any existing unit/Section card, I get an error as below:
java.lang.IllegalArgumentException: invalid cql from = ClasseImpl{name=Building} (it is not consistent with this class = ClasseImpl{name=Complex})
The snapshot of the Unit/Section card where I tried to edit it and it showed error is as below:
Following is the snapshot of the change that I did as mentioned by you. Hope i did it correctly.
Sorry, my answer was wrong.
I wrote:
“To correct your application immediately, go to the Administration Module and from the navigation menu go to: Classes => Standard => Site => Unit, then move to the center on the “Attributes” TAB and on the “Complex” attribute”
but the attribute on which to intervene was not Complex but Building.
You must therefore remove (as it was originally) the filter on “Complex” and insert it on “Building”.
Be careful because there was a second error: the filter must be “from Building where Complex = {client:Complex.Id}” without the space between “client:” and “Complex.Id”.
Thanks for the update. I have gone on a 10 days vacation now. Will return back update you on this.
Bingoooo ! It worked perfectly! Thanks
