CMDBuild Forum

Report & Lookup parameters

Old Versions
#1

Hello !

I got 2 problems, I am trying to upload my .jrxml file into CMDBuild but when i click on the "Save" button, the upload field goes empty and my file isn't uploaded.
The preview report in iReport is working...

And for this report, I wanted to know if there is a way to get the value of a lookup parameters.
I did not find any way to get anything but an integer value, can you help me ?

I'm using CMDBuild 2.3.2 Ready2Use and iReport 5.6 with compatibility mode to 3.6.2

 

Thank you for your answer

#2

The first problem is not a known issue, perhaps depends on your browser.
For the second problem you can find the answer below
CMDBuild Team

 * AVAILABLE FORMATS FOR JRPARAMETER NAME
 * reference: "name.class.attribute"
 * lookup: "name.lookup.lookuptype"
 * simple: "name"
 * 
 * REQUIRED PARAMETERS
 * By default all custom parameters (with prompt flag set to true) are required.
 * Set a parameter's property with name="required" and value="false" to override.
 * 
 * Note: Reference or lookup parameters will always be integers while simple params will match original parameter class.

 

#3

The first problem occurs with IE 9 and Firefox

38.0.5.

 

And for the second one, there is no way to get anything else ? I have to change all the lookup parameters for Strings ?

 

Previously Tecnoteca wrote:
The first problem is not a known issue, perhaps depends on your browser.
For the second problem you can find the answer below
CMDBuild Team
 
 * AVAILABLE FORMATS FOR JRPARAMETER NAME
 * reference: "name.class.attribute"
 * lookup: "name.lookup.lookuptype"
 * simple: "name"
 * 
 * REQUIRED PARAMETERS
 * By default all custom parameters (with prompt flag set to true) are required.
 * Set a parameter's property with name="required" and value="false" to override.
 * 
 * Note: Reference or lookup parameters will always be integers while simple params will match original parameter class.

 

 

#4

For the first question I confirm that it is not a known problem, we just did a test using Firefox 38.0.1 and everything is working properly.
For the second question the behavior I described is the standard CMDBuild behavior.
CMDBuild Team

#5
Hello Tecnoteca team,
 
At this time of writing, I think some changes already applied for custom report parameter in later CMDBuild version. Required=true no longer by default.
 
And there is another way to set lookup and reference parameter by setting lookupType or targetClass in report parameter properties. There are also filter and filter prefix properties, but I still don't understand the purpose and how to use it. Any clue? :)
 
Another thing, is it possible to have multiple selection of lookup or reference as input parameter? For example, user want to have report of all registered building in multiple cities from lookup.
 
Thank you.
 
Regards,
Herru
 
Previously Tecnoteca wrote:
For the first question I confirm that it is not a known problem, we just did a test using Firefox 38.0.1 and everything is working properly.
For the second question the behavior I described is the standard CMDBuild behavior.
CMDBuild Team

 

#6
Dear Herru Windiarto,
 
since version 2.3.4 the behaviour is to have "Required=false".
 
# How to set a foreign key
 
 
required=true|false
targetClass=Foo
filter=from Foo where ...
filter.var1=....
filter.varN=....
 
where "var1"..."varN" are variables of the filter.
 
 
# How to set a lookup
 
required=true|false
lookupType=Foo
 
Best regards.
 
-- CMDBuild Team
 
Previously Herru Windiarto wrote:
Hello Tecnoteca team,
 
At this time of writing, I think some changes already applied for custom report parameter in later CMDBuild version. Required=true no longer by default.
 
And there is another way to set lookup and reference parameter by setting lookupType or targetClass in report parameter properties. There are also filter and filter prefix properties, but I still don't understand the purpose and how to use it. Any clue? :)
 
Another thing, is it possible to have multiple selection of lookup or reference as input parameter? For example, user want to have report of all registered building in multiple cities from lookup.
 
Thank you.
 
Regards,
Herru
 
Previously Tecnoteca wrote:
For the first question I confirm that it is not a known problem, we just did a test using Firefox 38.0.1 and everything is working properly.
For the second question the behavior I described is the standard CMDBuild behavior.
CMDBuild Team

 

 

#7
Hello CMDBuild Team,
 
Thank you for you response, I'll try that.
 
What about my question regarding multiple selection of reference and lookup as report parameter. Is it possible?
 
Thanks.
 
Regards,
Herru
 
Previously Tecnoteca wrote:
Dear Herru Windiarto,
 
since version 2.3.4 the behaviour is to have "Required=false".
 
# How to set a foreign key
 
 
required=true|false
targetClass=Foo
filter=from Foo where ...
filter.var1=....
filter.varN=....
 
where "var1"..."varN" are variables of the filter.
 
 
# How to set a lookup
 
required=true|false
lookupType=Foo
 
Best regards.
 
-- CMDBuild Team
 
Previously Herru Windiarto wrote:
Hello Tecnoteca team,
 
At this time of writing, I think some changes already applied for custom report parameter in later CMDBuild version. Required=true no longer by default.
 
And there is another way to set lookup and reference parameter by setting lookupType or targetClass in report parameter properties. There are also filter and filter prefix properties, but I still don't understand the purpose and how to use it. Any clue? :)
 
Another thing, is it possible to have multiple selection of lookup or reference as input parameter? For example, user want to have report of all registered building in multiple cities from lookup.
 
Thank you.
 
Regards,
Herru
 
Previously Tecnoteca wrote:
For the first question I confirm that it is not a known problem, we just did a test using Firefox 38.0.1 and everything is working properly.
For the second question the behavior I described is the standard CMDBuild behavior.
CMDBuild Team

 

 

 

#8

This is not possible.
In general in CMSBuild the “lookup” and “reference” attributes let you choose only a value.
CMDBuild Team 

 

 

 

 

#9
Hello there,
 
Any plan for that? :)
 
I see iReport support input parameter of List or Collection.
 
Regards,
Herru
 
Previously Tecnoteca wrote:
This is not possible.
In general in CMSBuild the "lookup" and "reference" attributes let you choose only a value.
CMDBuild Team 

 

 

 

 

 

#10

No, it is currently not an activity on which we plan to work.
CMDBuild Team