0

Union AS on Export?

We have a page called time blocks. It has 6 columns: User, Date, Project1, Project2, Project3, Project4.

Technically it should be 3:
User, Date, Project
But it makes it more difficult for artists to at a glance see if they filled in all 4 time blocks for the day, so usability trumps database cleanliness.

But now we need to get it into excel for producer types to analyze and review.   Is it possible to have a JOIN export where we have like:
SELECT User,Date,Project1 AS "Project" FROM Timeblocks
UNION
SELECT User,Date,Project2 AS "Project" FROM Timeblocks

Is this possible to do?  I might need to just write a super basic Python exporter for them.

댓글 0개

댓글을 남기려면 로그인하세요.