CMDBuild Forum

CQL - Fatal Filter Error

Old Versions
#1

Hi,

 

we have a question about the CQL filter function in CMDBuild (Ver.2.1.8).

When we look at different cards in Editing mode there is no data shown in several fields (attributes) although data has been inputted and also saved. When you look directly in the database, you see that there is data in the fields. These attributes are of the type “Refernc” and have a filter. When you open a card the data disappears. We have uploaded a little video for better understanding on YouTube. :) YouTube-Link

I hope that we have made ​​an config mistake in this basic function and it is not a bug in CmdBuild.

 

 

We use the following configuration:                  

[SC] = SuperClass,  [C] = Class, [A] = Attribut & Referenc, [D] = Domain

 

o   [SC Location]

o   -> [C Building]

o   -> [C Floor] - [A Building] - [D BuildingFloor]

o   -> [C Room] - [A Building] - [A Floor] - [D BuildingRoom] - [D FloorRoom],

 

o   [SC Assets] -> [SC Computer]

o   -> [C Desktop-PC] - [A Building] - [A Floor] – [A Room] - [D BuildingAssets] ->

[D FloorAssets] -> [D RoomAssets]

 

 

The following filter is being used on the “Reference” Attributes in the Class Desktop-PC and always reproduces the same error (empty or not shown Fields):

 

o   from Floor where [BuildingFloor] = {client:Building}

o   from Floor where Building = {client:Building}

o   from Room where Floor = {client:Floor} 

o   from Room where [FloorRoom] = {client:Floor}

 

Here is a YouTube link to a Screen Captured Video of this Error:

<<<<< http://youtu.be/YJ6OlZ076lg >>>>>

 

Thanks for the help

Konrad

 

 

 

#2
Hi Konrad,
 
the correct syntax for the cql filters is
 
  • from Floor where Building = 0{client:Building.Id}
  • from Room where Floor = 0{client:Floor.Id}
 
However, also with the right syntax the error you noticed sometimes appears. 
Thanks for reporting this issue, we will fix it as soon as possible. 
 
Kind regards
 
CMDBuild Team
 
 
Previously Herrmann wrote:

Hi,

 

we have a question about the CQL filter function in CMDBuild (Ver.2.1.8).

When we look at different cards in Editing mode there is no data shown in several fields (attributes) although data has been inputted and also saved. When you look directly in the database, you see that there is data in the fields. These attributes are of the type “Refernc” and have a filter. When you open a card the data disappears. We have uploaded a little video for better understanding on YouTube. :) YouTube-Link

I hope that we have made ​​an config mistake in this basic function and it is not a bug in CmdBuild.

 

 

We use the following configuration:                  

[SC] = SuperClass,  [C] = Class, [A] = Attribut & Referenc, [D] = Domain

 

o   [SC Location]

o   -> [C Building]

o   -> [C Floor] - [A Building] - [D BuildingFloor]

o   -> [C Room] - [A Building] - [A Floor] - [D BuildingRoom] - [D FloorRoom],

 

o   [SC Assets] -> [SC Computer]

o   -> [C Desktop-PC] - [A Building] - [A Floor] – [A Room] - [D BuildingAssets] ->

[D FloorAssets] -> [D RoomAssets]

 

 

The following filter is being used on the “Reference” Attributes in the Class Desktop-PC and always reproduces the same error (empty or not shown Fields):

 

o   from Floor where [BuildingFloor] = {client:Building}

o   from Floor where Building = {client:Building}

o   from Room where Floor = {client:Floor} 

o   from Room where [FloorRoom] = {client:Floor}

 

Here is a YouTube link to a Screen Captured Video of this Error:

<<<<< http://youtu.be/YJ6OlZ076lg >>>>>

 

Thanks for the help

Konrad

 

 

 

 

#3
Hello, 
 
thanks for reply. 
If this basic and essential function fixed in the new version 2.2? Or could give me an approximate date? 
We need this information for further planning. :) 
 
... "Work in progress 
We released CMDBuild 2.1.8, and at the moment we are Developing the version 2.2 did is scheduled for the end of May "..... 
 
Thanks a lot :) 
Konrad
 
++++----++++----++++----++++----++++----++++----++++----++++----++++----++++----++++----++++
 
Previously Tecnoteca wrote:
Hi Konrad,
 
the correct syntax for the cql filters is
 
  • from Floor where Building = 0{client:Building.Id}
  • from Room where Floor = 0{client:Floor.Id}
 
However, also with the right syntax the error you noticed sometimes appears. 
Thanks for reporting this issue, we will fix it as soon as possible. 
 
Kind regards
 
CMDBuild Team
 
 
Previously Herrmann wrote:

Hi,

 

we have a question about the CQL filter function in CMDBuild (Ver.2.1.8).

When we look at different cards in Editing mode there is no data shown in several fields (attributes) although data has been inputted and also saved. When you look directly in the database, you see that there is data in the fields. These attributes are of the type “Refernc” and have a filter. When you open a card the data disappears. We have uploaded a little video for better understanding on YouTube. :) YouTube-Link

I hope that we have made ​​an config mistake in this basic function and it is not a bug in CmdBuild.

 

 

We use the following configuration:                  

[SC] = SuperClass,  [C] = Class, [A] = Attribut & Referenc, [D] = Domain

 

o   [SC Location]

o   -> [C Building]

o   -> [C Floor] - [A Building] - [D BuildingFloor]

o   -> [C Room] - [A Building] - [A Floor] - [D BuildingRoom] - [D FloorRoom],

 

o   [SC Assets] -> [SC Computer]

o   -> [C Desktop-PC] - [A Building] - [A Floor] – [A Room] - [D BuildingAssets] ->

[D FloorAssets] -> [D RoomAssets]

 

 

The following filter is being used on the “Reference” Attributes in the Class Desktop-PC and always reproduces the same error (empty or not shown Fields):

 

o   from Floor where [BuildingFloor] = {client:Building}

o   from Floor where Building = {client:Building}

o   from Room where Floor = {client:Floor} 

o   from Room where [FloorRoom] = {client:Floor}

 

Here is a YouTube link to a Screen Captured Video of this Error:

<<<<< http://youtu.be/YJ6OlZ076lg >>>>>

 

Thanks for the help

Konrad

 

 

 

 

 

#4
This fix will be included in the 2.2 version which is scheduled for the second week of June. 
 
Kind regards.
CMDBuild Team
 
 
Previously Konrad wrote:
Hello, 
 
thanks for reply. 
If this basic and essential function fixed in the new version 2.2? Or could give me an approximate date? 
We need this information for further planning. :) 
 
... "Work in progress 
We released CMDBuild 2.1.8, and at the moment we are Developing the version 2.2 did is scheduled for the end of May "..... 
 
Thanks a lot :) 
Konrad
 
++++----++++----++++----++++----++++----++++----++++----++++----++++----++++----++++----++++
 
Previously Tecnoteca wrote:
Hi Konrad,
 
the correct syntax for the cql filters is
 
  • from Floor where Building = 0{client:Building.Id}
  • from Room where Floor = 0{client:Floor.Id}
 
However, also with the right syntax the error you noticed sometimes appears. 
Thanks for reporting this issue, we will fix it as soon as possible. 
 
Kind regards
 
CMDBuild Team
 
 
Previously Herrmann wrote:

Hi,

 

we have a question about the CQL filter function in CMDBuild (Ver.2.1.8).

When we look at different cards in Editing mode there is no data shown in several fields (attributes) although data has been inputted and also saved. When you look directly in the database, you see that there is data in the fields. These attributes are of the type “Refernc” and have a filter. When you open a card the data disappears. We have uploaded a little video for better understanding on YouTube. :) YouTube-Link

I hope that we have made ​​an config mistake in this basic function and it is not a bug in CmdBuild.

 

 

We use the following configuration:                  

[SC] = SuperClass,  [C] = Class, [A] = Attribut & Referenc, [D] = Domain

 

o   [SC Location]

o   -> [C Building]

o   -> [C Floor] - [A Building] - [D BuildingFloor]

o   -> [C Room] - [A Building] - [A Floor] - [D BuildingRoom] - [D FloorRoom],

 

o   [SC Assets] -> [SC Computer]

o   -> [C Desktop-PC] - [A Building] - [A Floor] – [A Room] - [D BuildingAssets] ->

[D FloorAssets] -> [D RoomAssets]

 

 

The following filter is being used on the “Reference” Attributes in the Class Desktop-PC and always reproduces the same error (empty or not shown Fields):

 

o   from Floor where [BuildingFloor] = {client:Building}

o   from Floor where Building = {client:Building}

o   from Room where Floor = {client:Floor} 

o   from Room where [FloorRoom] = {client:Floor}

 

Here is a YouTube link to a Screen Captured Video of this Error:

<<<<< http://youtu.be/YJ6OlZ076lg >>>>>

 

Thanks for the help

Konrad