Technical rule not triggering

[Bsah]

This is my SQL queries for the technical rule to meet the CP49=true to create AD account?

a.customproperty16='Active' AND a.statuskey=1 AND a.customproperty49 = 'True' AND a.customproperty13 in ("Permanent Full Time", "Permanent Part Time", "Max Term Full Time", "Max Term Part Time", "Casual", "Vacation Students") AND (a.customproperty37 is not null AND upper(a.customproperty37) != 'NONE') AND (date(addtime(sysdate(), '8:0:0')) >= date(a.customproperty35) AND date(addtime(sysdate(), '8:0:0')) <= date(a.customproperty36)) AND (a.customproperty38 is null OR upper(a.customproperty38) = 'NONE')

Thanks 

[amit_krishnajit]

@Bsah - when the technical rules are evaluated, they are evaluated as HQL and not SQL. Hence, there are functions or syntaxes that are allowed in SQL which may not work in HQL. 

Recommend you to look into the logs to validate what is the error that you are getting when this specific rule evaluates. Also, please check if functions like date(), addtime() are applicable for HQL or not. 

What is the use-case that you are trying to implement here?

[Bsah]

 this query is for creating AD which meets CP49=true and CP13 in all the employee group.

[amit_krishnajit]

Not sure where you are checking date and other conditions if there are only 2 conditions to be validated that you have mentioned above. 

[rushikeshvartak]

Does tasks are created ? If no can you check logs 

[Bsah]

No Pending task is creating for this tech rule.