I want a transform that checks the endDate attribute and if it’s within the next 7 days from now, returns true, any idea?
yes you can do this using dateMath and dateCompare
Thanks, also the goal is to email the manager 15 dyas and 1 day before the account expires…how can I achieve that? I’m thinking to use this transform set to an identity attribute and make use of it in the workflow
that is right, you can do that as you mentioned.
is it possible to provide me a sample format on this one?
you want send email to manager 1 day before or 15 days before looking enddate?
what ever, use scheduled trigger, get identity action, compare timestamp operator, send email action in sequence
okay, I used scheduled search for it, below is the query but the search returns identities whose enddate is within 7 days from today…but I need a query to return only identities whose enddate is exactly 7 days, meaning it returns users with enddate 08/21
NOT (attributes.type:“Employee”) AND attributes.endDate:[now TO now+7d]
Hello @ssel ,
I suggest you to use this query :
NOT (attributes.type:“Employee”) AND attributes.endDate:[now+7d/d TO now+7d/d]
Using [now+7d TO now+7d] template will return only identities whose endDate is exactly 7 days.
Personally, I used this kind of inputQuery on my project :
Thank you so much…So here’s my workflow below, the email needs to send to manager, can you please take a look what am I missing?
use compare timestamp as well please
recipient should be $.getIdentity.managerRef.id
Since I pull the identities from saved search, is compare timestamp necessary?
after get list of identities ad get identity action
got the below when I add the get identity
request failed (type: Bad Request, retryable: false): 414 - 414 Request URI Too Long:
after scheduled trigger add loop inside loop add getidentity list and get identity and send email that will work
Need to add a DL along with the manager’s email in sendEmail action…do we need to add it via API?
“recipientEmailList.$”: “$.getIdentity1.attributes.email”
It worked, thank you so much! Appreciate your help!