topic Re: Without Looping Get data from workday in Community Chat

Without Looping Get data from workday

Buvi — Wed, 28 Jan 2026 07:35:20 GMT

{ Rows: [ { Employee name: Test, Geo zone: zone, Job profile comp band: Sr.Manager Testing, Location: Test, Manager: Al-Test, Position created date: 2020-03-13T12:02:15.436000-07:00, Position ID title: dsfdsflka, Position status: Filled },

I’m using Workday Get Report activity. I need to match the input Job Profile Comp Band with the input value I’m passing, without using a loop. Once a match is found, I need to extract the Employee Name and EEO Zone.
The comparison should be case-insensitive (using downcase) and should check whether the value contains the input.

Re: Without Looping Get data from workday

shivakumara — Wed, 28 Jan 2026 14:36:28 GMT

Hi @Buvi ,
Here I am adding a solution. Please kindly check and let me know if you have any questions.

Re: Without Looping Get data from workday

francbaviello — Fri, 30 Jan 2026 16:44:25 GMT

Hi @Buvi , you can use the function 'where' and 'pluck'. example of formula:

array.where(Job profile comp band: 'Sr.Manager Testing').pluck('Employee name')

tell me if you encounter any problems

Re: Without Looping Get data from workday

Buvi — Wed, 04 Feb 2026 09:25:03 GMT

I get it what you are saying I have to downcase the content also

The comparison should be case-insensitive (using downcase) and should check whether the value contains the input