[midPoint] [Japer Report] How to retrieve info from parentOrfRef

Tue Jun 21 11:11:02 CEST 2022

Hi Sébastien, 

complex path (e.g. extension/someAttribute) doesn't work in Jasper reports. To use extension in the Jasper reports in midPoint 4.0.x, you will need to slightly change the configuration of your report. 

First, you need to specify that you want to use extension in your report. You can do it by adding "extension" field definition, in jasper definition it looks like: 

<field name="extension" class="com.evolveum.midpoint.xml.ns._public.common.common_3.ExtensionType"/> 

and in midPoint you can see it like this: 

Then, you need to specify from which extension attribute you want to retrieve a value to the report. So, for the textField where the extension attribute should be used, you need to specify textFieldExpression in the following format: 

<textFieldExpression><![CDATA[basic.getPropertyValue((com.evolveum.midpoint.xml.ns._public.common.common_3.ExtensionType) $F{extension}, 'someAttribute')]]></textFieldExpression> 

where 'someAttribute' should be replaced with the name of your extension attribute. 

Hope this helps. 

Best Regards, 

-- 
Katarina Bolemant 
Development Team Leader 
evolveum.com 

From: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
To: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
Cc: "Sébastien MARBRIER" <smarbrier at positivethinking.tech> 
Sent: Tuesday, June 14, 2022 10:16:34 AM 
Subject: [midPoint] [Japer Report] How to retrieve info from parentOrfRef 

Dear midpojnt community, 

I need to create a report on a midpoint 4.0.1 

I am able to filter correctly the users related to the metarole using the filter: 

<queryString language="mql"> 

<![CDATA[<filter> 

<type> 

<type>UserType</type> 

<filter> 

<and> 

<ref> 

<path>parentOrgRef/@/roleMembershipRef</path> 

<value oid="…" /> 

</ref> 

<equal> 

<path>activation/administrativeStatus</path> 

<expression> 

<queryInterpretationOfNoValue>filterAll</queryInterpretationOfNoValue> 

<path>$activation</path> 

</expression> 

</equal> 

</and> 

</filter> 

</type> 

</filter>]]> 

</queryString> 

I can also extract normal information such as firstname, fullname or email but I can’t extract a piece of information located in the extension and also in the parentOrgRef’s name. 

The user schema extension has the following structure: 

<xsd:complexType name="UserExtensionType"> 

<xsd:annotation> 

<xsd:appinfo> 

<a:extension ref="c:UserType"/> 

</xsd:appinfo> 

</xsd:annotation> 

<xsd:sequence> 

<xsd:element name="company" type="xsd:string" minOccurs="0"> 

<xsd:annotation> 

<xsd:appinfo> 

<a:indexed>true</a:indexed> 

<a:displayName>Company</a:displayName> 

<a:displayOrder>110</a:displayOrder> 

</xsd:appinfo> 

[…] 

</xsd:annotation> 

</xsd:element> 

[…] 

</xsd:sequence> 

</xsd:complexType> 

With the parentOrgRef field, several variations were tried: 

Report Field 

Field name /extension/company field class : java.lang.String 

<field name="/extension/company" class="java.lang.String"/> 

<textField isStretchWithOverflow="true" isBlankWhenNull="true"> 

<reportElement x="360" y="0" width="100" height="20" uuid="e7f668f3-9664-4660-8b16-0d25df7d3e2d"/> 

<textFieldExpression><![CDATA[$F{/extension/company}]]></textFieldExpression> 

</textField> 

Error message : No such property: company for class: report_script in report script 

Report Field 

Field name parentOrgRef/name field class : java.lang.String 

<field name="parentOrgRef/name" class="java.lang.String"/> 

<textField isStretchWithOverflow="true" isBlankWhenNull="true"> 

<reportElement x="360" y="0" width="100" height="20" uuid="e7f668f3-9664-4660-8b16-0d25df7d3e2d"/> 

<textFieldExpression><![CDATA[$F{parentOrgRef/name}]]></textFieldExpression> 

</textField> 

Error Message : No such property: name for class: report_script in report script 

Report Field 

Field name /parentOrgRef/@/name field class : java.lang.String 

<field name="/parentOrgRef/@/name" class="java.lang.String"/> 

<textField isStretchWithOverflow="true" isBlankWhenNull="true"> 

<reportElement x="360" y="0" width="100" height="20" uuid="e7f668f3-9664-4660-8b16-0d25df7d3e2d"/> 

<textFieldExpression><![CDATA[$F{/parentOrgRef/@/name}]]></textFieldExpression> 

</textField> 

The error message after the tak ran : 

Compilation error in report script: startup failed: 
report script: 1: unexpected token: @ @ line 1, column 15. 
/parentOrgRef/@/name 

I was able to get some information rom the parentOrgRef when I directly used the parentOrgRef as a string parameter but it is not usuable. 

Can someone would new how to deal with it ? 

In very rare occasions the user can have several parentOrgRef tags, how can I handle this case if the extension field cannot be used ? 

Thank you very much for your help. 

[ https://www.positivethinking.tech/ ] 	

Sébastien Marbrier | Senior IT Consultant 
[ mailto:smarbrier at positivethinking.tech | smarbrier at positivethinking.tech ] 

Tel. +41 21 601 81 00 

[ https://teams.microsoft.com/l/chat/0/0?users=smarbrier@positivethinking.tech ] 	

[ https://teams.microsoft.com/l/chat/0/0?users=smarbrier@positivethinking.tech |   ] 	

[ https://teams.microsoft.com/l/chat/0/0?users=smarbrier@positivethinking.tech | Chat with me on Teams ] 

[ https://www.linkedin.com/company/the-positive-thinking-company/ ] [ https://www.instagram.com/positivethinkingcompany/ ] [ https://twitter.com/PTC_Tech ] [ https://youtube.com/channel/UCfaImWa6r0IoZoUYLhbiF7w ] 		

Avenue de cour, 135 – 1007 Lausanne 
[ https://www.positivethinking.tech/ | www.positivethinking.tech ] 

Positive Thinking Company puts security at a high priority in its conduct of business. Therefore, we have put our best efforts into ensuring that this email and its attached documents are error and virus-free. Nonetheless, full security of emails/documents cannot be ensured. Therefore, the recipient is responsible for checking the email/documents for threats with its own security measures, prior to opening it. Positive Thinking Company does not accept liability for any damage inflicted by using the content of this email/documents. If you are not the intended recipient, please notify the sender and delete this email/document. 

_______________________________________________ 
midPoint mailing list 
midPoint at lists.evolveum.com 
https://lists.evolveum.com/mailman/listinfo/midpoint 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jasper-extension-field.png
Type: image/png
Size: 97376 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 7735 bytes
Desc: image001.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 686 bytes
Desc: image002.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 2337 bytes
Desc: image003.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 2756 bytes
Desc: image004.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 2358 bytes
Desc: image005.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 2669 bytes
Desc: image006.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220621/31b282d2/attachment-0013.png>