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
1 Like
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
1 Like
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
1 Like
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!
1 Like