Time bounded restriction for Entitlement Request

[gazanjum]

We are trying to establish an approach where the Entitlements like Directory Roles will be requested should be only requested at a particular time.

For instance,

Access is requestable only during 20:00  to 5:00  CET

We already have a query which is restricting the maxtimeframe to 9 hours however our requirement is for specific time.

Regards

Gazala

[NM]

Hi @gazanjum , you can reject the request if time of submission is greater than or less than the above specified time.

[gazanjum]

The ask is user should only be able to request during that timeframe. We are not looking for an approval flow here.

[rushikeshvartak]

Considering this is application access request form. Creating blocking dynamic attribute which will check current time and show allowed or not allowed message.

SELECT CASE WHEN TIME(CONVERT_TZ(NOW(), '+00:00', '-06:00')) BETWEEN '20:00:00' AND '23:59:59' OR TIME(CONVERT_TZ(NOW(), '+00:00', '-06:00')) BETWEEN '00:00:00' AND '05:00:00' THEN 'allow' ELSE 'not allow' END AS id From dual