<div dir="ltr"><div><br clear="all"></div><div><span id="gmail-docs-internal-guid-4fafef90-7fff-147d-6c38-f8614ea20c0c"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Hello, good evening, I’ve been working on a task that notifies users that their password is about to expire, and while it was working perfectly before the 4.9 upgrade, it looks like it stopped working. I’ll go through the problem using screenshots.</span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">These are some of my users.</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:232px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdJMS-NBkt2Sls0KcwQ96wImld6EnB5-4_AoBfiY98oMEo4QDbTF6SRAN7av31YUa3j3FaXOJMI4hUzT0OrixFrhaJxIqJfRLCEhVSZPMagI6u6ZR5Y0ps3_ARDByfdgPQW6i3V?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="232" style="margin-left: 0px; margin-top: 0px;"></span></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">From what I’ve read in the 4.9 release page and what I can see here, the way metadata is stored has changed.</span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:236px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcFWRaIVcm7zVkOxXaZcaMLMmaKmMZtzsPoZK2LMq2achExm34A_6z2UnZfYpHd6zQYw1jlmRrtCx-7cb7TnRkTAlzhclTf9TwG4iSBrQQYOCMoOpX-mbvkkN08KwpBbW0c88ch?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="236" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">And when I try to query my users whose password was created before a date (in this example it’s far into the future to show an edge case where it should show me everyone) it only shows me the administrator, which is the only user that was created before the upgrade</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:187px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeCshFZqygzUMWCos8hchuCiU7SCSPk5ZxWpcmBgIvNXSf5c3bXEcO4kSi1HvLjmZ4-c8QrVfSwmpKpomjoc-UiLPJu_9rOdhcX07gBkzOGf7U7fAMMMj2Sr4ShYtSdoqQhra7K?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="187" style="margin-left: 0px; margin-top: 0px;"></span></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">While checking for differences in the xml between the administrator and other users, I noticed that it still has the old metadata format.</span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:307px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXd7LvM8sUqm-d9dhO9goAIDKw36wiP93FPBp3Shnb_vgv3AllDDZd7W3L32nwSK3XNCbu7W-OctY4QdITEy7YchBrxqjZwdu-37FRKTKvFBVDzirzR7sw6bS37kuDDoQMZy5RxR8Q?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="307" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">In the 4.9 release page I found that this was the new way to filter by metadata</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><a href="https://docs.evolveum.com/midpoint/release/4.9/#:~:text=Value%20metadata%20storage%20and%20process%20are%20indexed%20for%20assignments%20and%20available%20for%20search%20using%20assignment/%40metadata/storage" style="text-decoration-line:none"><span style="font-size:11pt;font-family:Arial,sans-serif;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;text-decoration-line:underline;vertical-align:baseline">https://docs.evolveum.com/midpoint/release/4.9/#:~:text=Value%20metadata%20storage%20and%20process%20are%20indexed%20for%20assignments%20and%20available%20for%20search%20using%20assignment/%40metadata/storage</span></a><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"> </span><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><br></span><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><br></span><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">However, it does not seem to be working, be it with or without the @, is there something that I’m missing?</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:171px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdGOEuWwUBROIlEzORNyd8GaO_CZZxd4Q_SzYtpIBWy4C1QQkD-STlANr-RmAT1nv_54D6WpI3xZfQDP1XRE2Q7z8_id3w_SaJ50d_VuX1UTjuE03JkjI8hGnnajv68eHCtg1X1ug?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="171" style="margin-left: 0px; margin-top: 0px;"></span></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:168px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeylna9CVIyKEVxMO-HI8R1bNPzCthbBk3f56tUmiO1NpJkCH2DozDVd_jeYxOXuINvw6hgtvNn_vUKeMqoQfcu7-bohxyP9SI5IUtlv-pwN0bwf96g7CpeOnDkn7UkHY9e5Z2-?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="168" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Also, to verify that the query itself was working correctly, I tried it in </span><a href="https://demo.evolveum.com" style="text-decoration-line:none"><span style="font-size:11pt;font-family:Arial,sans-serif;background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;text-decoration-line:underline;vertical-align:baseline">https://demo.evolveum.com</span></a><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"> and it worked as expected</span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:279px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdcSUcLkj2f0Vd1rVHTJRMu5JNblyRzE27MCmQ9aLQ20aFuJ4fahBxPB7Q6kvcxBgMI84jFe2rcYTtFu2j1Dt8MdvUJI49eUt4HiYhKrVca30Hwh31D-mjlt8x12LmsL-eirT6flw?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="279" style="margin-left: 0px; margin-top: 0px;"></span></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Search in demo before passwords were set</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:187px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfM4iBsI0fpfCwfEeNCNL-UHyfxyfy9l6GoDDrzFsi1KErjDT2sh2XYp-x00n4HlBTswkNM8J69vdkyHkys5HFmiCbiPcxm5hTaJW50o6hoSoElXspsg5Fc0Tc1TYFTNCzXCQLP3A?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="187" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline">Demo is running an older version and has the older metadata format</span><span style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:baseline"><span style="border:none;display:inline-block;overflow:hidden;width:602px;height:323px"><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXds2XhtengZT9cUe9w2aLe-7HwFLBbxaUNahq_5up8JQr_b2JW-_EEfCE2h0rcuIjoTvlpA-eS9mdSXGLz0KvAvQ2V664bks_akiYaMf7atYcB7NBmMTLi7KYoUyoynvJy-BbKKpw?key=SKuovIEtn7EaJHOqxPyr4ECu" width="602" height="323" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br>Thank you for your assistance!</span></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr" style="color:rgb(34,34,34)"><font face="arial, sans-serif" color="#666666"><b>Ivan Dimitri Tarjan Caldarini</b></font></div><div style="color:rgb(34,34,34)"><font color="#999999" face="arial, sans-serif">Jr IAM Engineer | Rakkau</font></div><div style="color:rgb(34,34,34)"><font face="arial, sans-serif" color="#999999">+54 (911) 3383-0309<br></font></div><div style="color:rgb(34,34,34)"><font face="arial, sans-serif" color="#999999"><a href="mailto:nrossi@rakkau.com" style="color:rgb(17,85,204)" target="_blank"><font color="#999999">itarjan@rakkau.com</font></a></font></div><div style="color:rgb(34,34,34)"><a href="http://www.rakkau.com/" style="color:rgb(17,85,204)" target="_blank"><font face="arial, sans-serif" color="#666666">www.rakkau.com</font></a></div></div></div></div>