CMDBuild Forum

Create or modify card widget filter

Old Versions
#1

Hello all,

For some case, I need to show detailed information of a card, from another card. I use create or modify card widget, but I have problem with the widget filter

For example, I can create widget in card Room to get detail information of Floor, by applying this filter on the widget:

----

from Floor where Id = {server:Floor.Id}

----

 

But how can I get detail information of Building from widget in card Room? I try this filter, but it return error after click the widget button:

----

from Building where Id in (/(select Building from Floor where Id = {server:Floor.Id} and Status = 'A')/)

----

And this is the error message:

"Error: org.cmdbuild.exception.NotFoundException: CARD_NOTFOUND Building"

 

Anyone can help?

 

Thanks.

 

Regards,

Herru

 

#2

Dear Herru,

if you need the widget you have to create the reference on the Room class to the Building class, otherwise the filter will not work.

 

Best regards

CMDBuild Team

#3
Dear Team,
 
Why there is such limitation, while I still can get Building class from widget in Room class using hardcoded id in filter like this:
 
-----
from Building where Id = 64
-----
 
Thanks.
 
Regards,
Herru
 
Previously Tecnoteca wrote:

Dear Herru,

if you need the widget you have to create the reference on the Room class to the Building class, otherwise the filter will not work.

 

Best regards

CMDBuild Team

 

#4

But without the attribute on the card your filter can not be dynamic.
CMDBuild Team

 

 

#5
That's why I'm using subselect like below, I think it should work:
 
----
from Building where Id in (/(select Building from Floor where Id = {server:Floor.Id} and Status = 'A')/)
----
 
Regards,
Herru
 
Previously Tecnoteca wrote:
But without the attribute on the card your filter can not be dynamic.
CMDBuild Team

 

 

 

#6

{client:Floor.Id} is the floor edited in the current card (where Floor is a reference attribute), {server:Floor.Id} is not.

CMDBuild Team

#7
Still no luck.

I use server variable because I'm not editing it. I want to view Building class from Room without editing it, by ticking "Always enabled" option.
 
Thanks anyway..
 
Regards,
Herru
 
Previously Tecnoteca wrote:

{client:Floor.Id} is the floor edited in the current card (where Floor is a reference attribute), {server:Floor.Id} is not.

CMDBuild Team