public inbox for [email protected]  

help / color / mirror / Atom feed

From: Steve Midgley <[email protected]>
To: nikhil raj <[email protected]>
Cc: [email protected]
Subject: Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
Date: Sat, 25 Feb 2023 13:56:27 -0800
Message-ID: <CAJexoSLXy5yH7NROj=1ZMHMX1iDVpSmh-f4iZsAQX5KWY5AxGg@mail.gmail.com> (raw)
In-Reply-To: <CAG1ps1wWWGS1bai_N5n-aJzTQ7Efv9WR37OPAydnT1MBqbrZBQ@mail.gmail.com>
References: <CAG1ps1z_-s1yZM3fGghR07s2VcGN5xWPHYqWNBEX-0ujV7m_Dg@mail.gmail.com>
	<CAG1ps1wWWGS1bai_N5n-aJzTQ7Efv9WR37OPAydnT1MBqbrZBQ@mail.gmail.com>

On Sat, Feb 25, 2023 at 12:37 PM nikhil raj <[email protected]> wrote:

>
> Hi All,
>
> Need help in rotation of data in *Postgres*.
>
> There is a table called crew_details
>
> [image: enter image description here]
> <https://i.stack.imgur.com/cTarQ.png;
>
> There is a requirement to rotate the crew members for in weekly or on the
> every 7th day and continue for rest 6days the same order of for the given
> date range un till it reach end date . and the expected output should be
> like this below
>
> [image: >] <https://i.stack.imgur.com/hjasI.png;
>
> Please can any one help me in in the rotation in *postgres SQL*
>

Thanks for posting the table and output. I'm not totally clear on the
business requirements here but it seems like you have a crew rotation
sequence that is, in this case modulus 5?

I'm not sure I've got the SQL skills to easily make this in a single query
(but surely others here can). But just to clarify the business rules for
such a SQL wizard, I would think the solution involves some kind of hidden
variable (new column, aggregation, built in function?) where the number 1
team member's crew position number is incremented by 1 mod 5 for each new
shift date. Whenever that tracking counter becomes 1 again, convert their
actual shift order number to 5, and subtract 1 from every other crew
members' crew position number. Does that sound like the correct business
rule for the process you're trying to create?

Steve

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
  In-Reply-To: <CAJexoSLXy5yH7NROj=1ZMHMX1iDVpSmh-f4iZsAQX5KWY5AxGg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox