B1UP Calendar - Multi-scheduling from Service Calls Completed

Geoff Booth

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

Comments

7 comments

Date Votes
  • Comment author
    SSP Automation
    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]
    1
  • Comment author
    Rasmus Jensen

    This (Multi-Schedule Support) will be available in B1UP 2021.09... 

    0
  • Comment author
    SSP Automation
    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 :-)
    0
  • Comment author
    Geoff Booth

    Fantastic. I have two clients looking for this right now :)

    0
  • Comment author
    Rasmus Jensen

    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))
    )

    0
  • Comment author
    Geoff Booth

    Thanks Rasmus!

    Downloaded and tested yesterday. Works flawlessly and is easy to set up.

    0
  • Comment author
    Rasmus Jensen
    • Edited

    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;

    0

Please sign in to leave a comment.