Hello, does anyone have any experience crafting search queries within the [Get List of Identities] action of workflows? I want to schedule a workflow to run in the early AM which identifies users on their start-date. Each Identity has a “formattedStartDate” and a “currentDate” attribute formatted …

Ryan, yes i think the name only holds the significance in this case as the documentation only states about adding “dateType” Link: <a href="https://documentation.sailpoint.com/saas/help/search/searchable-fields.html#:~:text=Note%20that%20if%20you%20add%20custom%20attributes%20to%20your%20identity%20profile%2C%20you%20can%20search%20on%20those%20as%20well%20using%20the%20technical%20name%20of%20the%20attribute.%20You%20can%20also%20configure%20your%20custom%20attributes%20to%20use%20the%20date%20type%20of%20value%20by%20adding%20the%20string%20dateType%20to%20the%20end%20of%20your%20attribute%20name" class="inline-onebox">Searchable Fields - SailPoint Identity Services . [image]

perform your required search you want through the search UI, once you have your query the way you need it, use the Get List of Identities action and use search Query in the “Find Identities By” field and past your search query in. When you do this, you will then need to use a loop operator. You are…

Hi Fred. Great minds think alike. I’ve been considering that, but was having a tough time crafting a search. I know you can utilize [now] within certain queries. Can it be utilized with a compare operator? I see it called out in the query documentation here https://documentation.sailpoint.com/s…

attributes.startDate:[now-1M TO now] this works for me just fine. The startDate is formatted as yyyy-MM-dd. In order to do comparisons with NOW, you have to have the date formatted correctly

Darn, no luck. attributes.formattedStartDate:"2025/07/11" String matching works just fine. Our Authoritative Source delivers startDate as dd-MMM-yyyy (technically it’s a string up stream). We pass it through a transform and build a 2nd identity attribute called formattedStartDate. I assume IDN t…

you need dashes rather than slashes

Hi @RPook Please refer to this thread, [image] Search joining date similar to created in ISC ISC Discussion and Questions Hi @ggregory199 So in order to achieve this use case, you will have to create a attribute which should have “DateType” at the end. Ex: joiningDateTy…

[image] Fred Patterson: attributes.startDate:[now-1M TO now] Looks like you beat me to it by about a year! My former transform looked like this with the slashes [image] A quick update changed it to dashes [image] I see the change in my Identity Attributes. I can successfully string mat…

Hello Ryan, In order to allow the searching via the now attribute please follow the above thread that i had shared. There are few requirements that needs to be met first in order to search using now keyword.

Well I’ll be… The former architects of this system built an attribute called, formattedStartDate and went through the effort of transforming data (with dashes, not slashes). Now I find that the attribute is configured as "type": "string", I’ve updated the Identity Attribute type via VSCode. The …

I’ve built a net-new attribute called “deletemetimeDateType” , but when I inspect the attribute in vsCode it claims the type is a string. Any idea how SailPoint handles attribute types? I see references to string and boolean within their API library but there does not appear to be anything in the U…

Workflow search query within Get List of Identities action

Identity Security Cloud (ISC) ISC Discussion and Questions

neeraj99 (Neeraj Nautiyal) July 13, 2025, 6:52pm 7

Hi @RPook

Please refer to this thread,

It has been already marked as solution you can follow the same method, and use that in the workflow action to find the identities.

Please letme know if you still face any issues.

Hope this helps

Topic		Replies	Views
Workflow - get single identity from list of identities ISC Discussion and Questions workflows , identity-security-cloud	3	815	July 18, 2023
Unable to perform date logic in custom identity attribute search ISC Discussion and Questions identity-security-cloud , search	4	1239	April 5, 2024
Identity search based on endDate attribute - Date format ISC Discussion and Questions identity-security-cloud , search	2	561	October 14, 2024
Search query to get list of vendors who is going to be expired within 30 days ISC Discussion and Questions identity-security-cloud , search	4	104	May 19, 2025
Identitiy search based on end date attribute ISC Discussion and Questions identity-security-cloud , search	7	415	October 31, 2024

Workflow search query within Get List of Identities action

Related topics