08/24/2022 11:38 AM
Hey all,
We have endpoints configured that have dynamic attributes for business lines that group entitlements when requesting access:
I created a new one, same configuration as the others, and this latest one is having issues. I can see the 3 business lines show up, but only one of the lines has it's respective entitlements appearing when requesting. For the other 2 lines the access table doesn't appear. The only differences are the business line/entitlement names and the entitlementtypekey specified in the query.
Here is the sql query for the dynamic attribute:
select distinct customproperty1 as ID from entitlement_values where customproperty1!='' and entitlementtypekey=56 and status=1
When selecting the non functionning business lines in ARS i do get this in the application logs however i'm unable to decipher it:
Thought it was syntax but query works fine in the data analyzer and it looks okay, I made sure to check that the custom properties didn't have any weird spacing or something similar. Anyone come across something similar or has any leads as to what might be causing this?
Solved! Go to Solution.
08/24/2022 05:59 PM
It seems issue while executing HQL. Can you hardcode value in query & custom property of entitlement & try
08/25/2022 07:28 AM
Hey, thanks for the quick reply but how can that be achieved? Sorry my SQL is slightly rusty.
08/26/2022 06:12 AM
I found the problem if anyone happens to come across something similar, had an english apostrophe instead of a french one in the name of the business lines and that was breaking my query but not completely, which is why i missed it the first time.