usercount | User statistics bot for Mastodon | Blog library

min(pDate) per name, could be achieved prior to the pivot, using windows function.
Once you have it, you can aggregate by both name and min_pDate.

You use .filter(…), but that will return a QuerySet, so a collection of CouponCodes. You should use .get(…) or even better: get_object_or_404(…):

Using forEach() might be a possible solution. We are going to use the increment operator (++). For example, something like this should work:

You need to turn Sequelize.fn into Sequelize.literal with a subquery and remove User from include option and group option:

Ok,

The problem was that I didn't move the db initialisation into the return of component

If the elements in the events arrays are the same, this code works without errors.

Instead of trying to use JsonPath whose syntax is unclear and lacks a standard, you should try JMESPath instead, that Gatling supports as well.

This is how I would do it:

1. First query all the computers from your list. Here I'm assuming the computer list is coming from a CSV and the computers are on a column named Computers.
2. Get the computer's Organizational Unit by removing the Common Name from their DistinguishedName: (.... -split '(?=OU=)',2)[-1]
3. Add the computers objects to a Hash Table where the Keys are the computer's OUs. This will let us query each OU only once.
4. Loop over the Hash Table keys (OU's DistinguishedName) querying their CanonicalName.
5. Create a new object for each computer with the desired properties.
6. Export the result to a Csv.

The quickest fix might be to just add the name and surname to the GROUP BY clause: