Hi,
i found that we can use CQL langage to filter some cards in the selection list presented to set a Reference attribute. i would like to know how to implement ?? in edit metadata ( reference ) on the administration mode ??
Regards
Regards
Yes, you can put your CQL statements in the “Filter” field that appears in the Administration Module defining a new attribute of type “reference”.
In the Administrator Manual you can also find some CQL examples (pagg 84-86)
Best regards
CMDBuild Team
Previously Tecnoteca wrote:
Yes, you can put your CQL statements in the "Filter" field that appears in the Administration Module defining a new attribute of type "reference".
In the Administrator Manual you can also find some CQL examples (pagg 84-86)
Best regards
CMDBuild Team
Ok thanks,
And how to transform a query with a sub query like this
" Select * from "Compte" Where ( "Status" = 'A' ) AND ( "Id" Not IN ( Select "Compte" from "Hebergement" Where "Status" = 'A' )) "
Previously Ted wrote:
Previously Tecnoteca wrote:Yes, you can put your CQL statements in the "Filter" field that appears in the Administration Module defining a new attribute of type "reference".
In the Administrator Manual you can also find some CQL examples (pagg 84-86)
Best regards
CMDBuild Team
Ok thanks,
And how to transform a query with a sub query like this
" Select * from "Compte" Where ( "Status" = 'A' ) AND ( "Id" Not IN ( Select "Compte" from "Hebergement" Where "Status" = 'A' )) "
désormais je me rapproche, mais il me reste un petit truc c'est qu'il ne reconnais pas le "NOT IN" in this query
from Compte where Id not in (/(select "Compte" from "Exploitation" where "Status" = 'A' )/)
Previously Ted wrote:
Previously Ted wrote:Previously Tecnoteca wrote:Yes, you can put your CQL statements in the "Filter" field that appears in the Administration Module defining a new attribute of type "reference".
In the Administrator Manual you can also find some CQL examples (pagg 84-86)
Best regards
CMDBuild Team
Ok thanks,
And how to transform a query with a sub query like this
" Select * from "Compte" Where ( "Status" = 'A' ) AND ( "Id" Not IN ( Select "Compte" from "Hebergement" Where "Status" = 'A' )) "
désormais je me rapproche, mais il me reste un petit truc c'est qu'il ne reconnais pas le "NOT IN" in this query
Sorry I wrote in French,
now I'm getting closer, but I have a little trick is that it does not recognize the "NOT IN" in this query
from Compte where Id not in (/(select "Compte" from "Exploitation" where "Status" = 'A' )/)