CMDBuild Forum

Search by multilevel LookUp field

Old Versions
#1

Hi,

I'm trying to perform searches based on a multilevel lookup field.

The thing is I'm not being able to perform a search using just the first level of the lookup.

For example, let's say there is a lookup called Location composed by 3 levels: Country -> City -> Postal Code.

How could I perform a search to find all CIs located in Italy, no matter what city or postal code?

#2

I confirm that at the momento you can set a filter only on the last level lookup value.
To do more complex analysis, you can use reports.
CMDBuild Team

#3

Previously Tecnoteca wrote:

I confirm that at the momento you can set a filter only on the last level lookup value.
To do more complex analysis, you can use reports.
CMDBuild Team

 

Thanks for your answer.
Is there some kind of workaround? nobody has needed to perform this kind of search before?
Could it be possible to deal with it through a stored procedure or similar?
 
This issue is a hard problem for us and a good reason to discard the tool for our cmdb implementation.
 
Thanks in advance,
Alex.
#4

In place of the two (or more) levels lookup atrributes, you can use two (or more) related reference attributes (linked via a CQL filter configurable in the reference attributes definition) and in that way you can set up searches independently on each level.
CMDBuild Team

#5

Previously Tecnoteca wrote:

In place of the two (or more) levels lookup atrributes, you can use two (or more) related reference attributes (linked via a CQL filter configurable in the reference attributes definition) and in that way you can set up searches independently on each level.
CMDBuild Team

 

Ok, I understand. I'll try that. Thanks.