Skip to main content

B1UP Calendar - Multi-scheduling from Service Calls

Completed

Comments

7 comments

  • 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]
  • Rasmus Jensen

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

  • 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 :-)
  • Geoff Booth

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

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

  • Geoff Booth

    Thanks Rasmus!

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

  • Rasmus Jensen

    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.