CMDBuild Forum

Bug in client variable component reference

Old Versions
#1

Dear team, 

This seems to me as a bug:

{server:LookupType.Id} .. OK

{client:LookupType.Id} .. "Template error LookupType Id"

Or it is not possible to refer to client Lookup variable components?

Thanks, Jiří

 

 

#2

I have also problems with reference columns in filters: 

 
{server:ReferenceColumn.Id} is OK
{client:ReferenceColumn.Id} has unpredictable behaviour. In some cases it is OK, in some cases it does not work. 
 
Jiří
#3

It seems the reference to {client:“ReferenceColumn”.Id} works well after refreshing CMDBuild page before the first “Save” of the “Modified” or “Added” card. It seems the value of {client:“ReferenceColumn”.Id} is not set properly after first Card saving. 

 
During the another card modification there is a following error:

Details
Call: services/json/management/modcard/getcardlist?_dc=1465897055770
---------------------------------------------------------------------
Error: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ 
SELECT *, count(*) over() AS _AssetCategory__RowsCount FROM ( 
SELECT
"AssetCategory"."Code" AS "AssetCategory#Code", "AssetCategory"."OrderNumber" AS "AssetCategory#OrderNumber", "AssetCategory"."Notes" AS "AssetCategory#Notes", "AssetCategory"."UserCode" AS "AssetCategory#UserCode", "AssetCategory"."Name" AS "AssetCategory#Name", "AssetCategory"."Description" AS "AssetCategory#Description", "AssetCategory"."IdClass"::oid AS "_AssetCategory_IdClass", "AssetCategory"."Id" AS "_AssetCategory_Id", "AssetCategory"."User" AS "_AssetCategory_User", "AssetCategory"."BeginDate" AS "_AssetCategory_BeginDate" 
FROM "AssetCategory" AS "AssetCategory" 
WHERE "AssetCategory"."Id" IN (SELECT "Category" FROM "AssetProduct" WHERE "Id" = ) AND "AssetCategory"."Status" = ?) AS main
ORDER BY "AssetCategory#UserCode" ASC, "_AssetCategory_Id" 
LIMIT 20 
OFFSET 0]; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
 
The filter is defined by this way:
from AssetCategory where Id in (/(SELECT "Category" FROM "AssetProduct" WHERE "Id" = {client:AssetProduct.Id})/)
 
Please help me - it is critical error for me now. 
Jiří