How to filter lowest value and keep the results

[Frantisek_Vujtek]

Hello. I have another weird question… Im trying to filter queues from JIRA with lowest issue Count in the queue and assign that the newest ticket to the person with the lowest number of tickets.

But whem im using the tool for numeric aggregation, (Using MIN(VALUE)) it will connect with the iterator and i will loose the possibility to continue with previous values and operate with them later

The thing is, i will lose the name of the queue and im not able to pair it and get the name of the queue for next moves… or im doing it wrong, can you help me with that?

[samliew]

Regarding your module [4],

To sort a complex array of collection by a key, you can use the built-in function sort. Then, since we are sorting by asc, you can use the built-in function first to get a single item from the sorted array.

e.g.:

{{first(sort(4.data.values; "asc"; "issueCount"))}}

For more information, see

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate
• Discord Server – join us in live chat for fans of Make!

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[Frantisek_Vujtek]

Hi Thank you for answer. But i still don’t know how i should retrieve the minimum value of Issue Count field to get just the min value of issuecount (so in this case is Martin Holecek queue name with 3 tickets. But with which function i can get it?

s

[samliew]

If they are in multiple bundles you cannot do it.

First delete the iterator module, keeping it as an array.

Then, post your output bundle of the array aggregator here.

If you need further assistance, please provide the following:

Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

• Either add three backticks ``` before and after the code, like this:

  ```
  <sup>input/output bundle content goes here</sup>
  ```

• Or use the format code button in the editor:
  

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!