B1UP Calendar - Multi-scheduling from Service Calls
Completed
I can add SCL6 to the Service Call query in order to have the multi-schedule tasks show.
I can't make the Drag/Drop functionality work correctly ( Dates & Times aren't updated).
This functionality could be extended to other documents / forms wherever there is a row type grid (i.e. Purchase Orders). In this case Drag/Drop may not make sense however if the PO has multiple Due Dates I think it should appear on multiple days
-
Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
(Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
Read more about the Feature Request process here
[Internal Id: 21369] -
This (Multi-Schedule Support) will be available in B1UP 2021.09...
-
The development team has now completed this request. Expect it to be in the next release of the product. Thank you again for helping us make the product better :-) -
Fantastic. I have two clients looking for this right now :)
-
SQL from the Screenshot above:
SELECT
T0.callID AS 'PrimaryKey',
T1.Line AS 'SecondaryKey',
T1.StartDate AS 'StartDate',
T1.StartTime AS 'StartTime',
T1.EndDate AS 'EndDate',
T1.EndTime AS 'EndTime',
T0.objType AS 'ObjectType',
CONCAT(N'Service call ',T0.callID,': ', T0.subject) AS 'Subject',
T0.descrption AS 'Details'
FROM OSCL T0 WITH (NOLOCK)
JOIN SCL6 T1 WITH (NOLOCK) ON T0.callID = T1.SrcvCallID
WHERE (@StartDate BETWEEN T1.StartDate AND T1.EndDate OR T1.StartDate BETWEEN @StartDate AND @EndDate OR T1.EndDate BETWEEN @StartDate AND @EndDate)
AND T0.status <> -1
AND (
(T0.isQueue = 'N' AND T0.assignee = @UserId)
OR
(T0.isQueue = 'Y' AND T0.Queue = (SELECT MAX(TS0.queueID) FROM OQUE TS0 WITH (NOLOCK) JOIN QUE1 TS1 WITH (NOLOCK) ON TS0.queueID = TS1.queueID WHERE TS0.manager = @UserId OR TS1.member = @UserId))
) -
Thanks Rasmus!
Downloaded and tested yesterday. Works flawlessly and is easy to set up.
-
HANA Version of the SQL:
DO BEGIN
DECLARE StartDateVar DATETIME = @StartDate;
DECLARE EndDateVar DATETIME = @EndDate;
DECLARE UserIdVar INT = @UserId;
DECLARE FilterServiceCallPriorityVar NVARCHAR(20) = @FilterServiceCallPriority;
DECLARE FilterServiceCallOriginVar INT = @FilterServiceCallOrigin;
DECLARE FilterServiceCallProblemTypeVar INT = @FilterServiceCallProblemType;
DECLARE FilterServiceCallCallTypeVar INT = @FilterServiceCallCallType;
DECLARE FilterServiceCallStatusVar NVARCHAR(100) = @FilterServiceCallStatus;
SELECT
T0."callID" AS "PrimaryKey",
T1."Line" AS "SecondaryKey",
T1."StartDate" AS "StartDate",
T1."StartTime" AS "StartTime",
T1."EndDate" AS "EndDate",
T1."EndTime" AS "EndTime",
T0."objType" AS "ObjectType",
N'Service call ' || T0."callID" || ': ' || T0."subject" AS "Subject",
T0."descrption" AS "Details"
FROM "OSCL" T0
JOIN "SCL6" T1 ON T0."callID" = T1."SrcvCallID"
WHERE (StartDatevar BETWEEN T1."StartDate" AND T1."EndDate" OR T1."StartDate" BETWEEN StartDateVar AND EndDateVar OR T1."EndDate" BETWEEN StartDateVar AND EndDateVar)
AND T0."status" <> -1
AND (
(T0."isQueue" = 'N' AND T0."assignee" = UserIdVar)
OR
(T0."isQueue" = 'Y' AND T0."Queue" = (SELECT MAX(TS0."queueID") FROM "OQUE" TS0 JOIN "QUE1" TS1 ON TS0."queueID" = TS1."queueID" WHERE TS0."manager" = UserIdVar OR TS1."member" = UserIdVar))
)
AND (FilterServiceCallPriorityVar = '' OR T0."priority" = FilterServiceCallPriorityVar)
AND (FilterServiceCallOriginVar = -999 OR T0."origin" = FilterServiceCallOriginVar)
AND (FilterServiceCallProblemTypeVar = -999 OR T0."problemTyp" = FilterServiceCallProblemTypeVar)
AND (FilterServiceCallCallTypeVar = -999 OR T0."callType" = FilterServiceCallCallTypeVar)
AND (FilterServiceCallStatusVar = '' OR T0."status" = FilterServiceCallStatusVar);
END;
Please sign in to leave a comment.
Comments
7 comments