Maximo Open Forum

 View Only
  • 1.  START CENTER DESIGN BASICS – ROLES & PERFORMANCE

    Posted 05-28-2020 13:41
    Webinar | Thursday, June 11, 2020 @ 2:00 PM ET. | Presenter: Chris Winston, Projetech
    The Maximo Start Center represents the home page for any user. As some users have a number of responsibilities, and as Start Center functionality has expanded since the release in version 5, Start Centers have gotten bigger. Users often need to scroll right/left as well as down/up, to get to what they want at the time.

    During the webinar, we will take a look at Role-based Start Centers, and several key tips that have been useful in scaling Start Centers to balance functionality as well as performance. Since Result Sets take the most resources on rendering a Start Center, we will look at some query segments with substitution variables as well as performance features. Everything reviewed will focus on what you can do without any need to do a database configuration.

    What question do you have prior to the webinar so I can be sure to address them?

    #EverythingMaximo
    #MORECommunityWebinar

    ------------------------------
    Christopher Winston
    Projetech, Inc.
    ------------------------------


  • 2.  RE: START CENTER DESIGN BASICS – ROLES & PERFORMANCE

    Posted 06-22-2020 16:35

    For those that missed the webinar, here is a link to the recording: https://www.youtube.com/watch?v=ojuJoY-Ux10&feature=youtu.be 

    Continue to post questions in regards to the webinar to get answers!



    ------------------------------
    Joe Kelley
    Projetech
    ------------------------------



  • 3.  RE: START CENTER DESIGN BASICS – ROLES & PERFORMANCE

    Posted 07-28-2021 10:22
      |   view attached
    Presentation file is attached. Sample result set query syntax is below to make it easier to copy/paste/alter


    Substitution Variables are available to cut down the number of queries you have to build



    In Work Order Tracking / Quick Reporting, your base query would include:

    (woclass = 'WORKORDER' or woclass = 'ACTIVITY') and status = 'WAPPR' and historyflag = 0 and istask = 0) and…

    Then, depending on what is required, you can add the segment you need based on:

    related to the current user's default insert site:
    …(siteid in (select defsite from maxuser where userid= :USER))

    related to the current user being the person assigned as lead (replace 'lead' below with reportedby, supervisor, owner, etc., as needed)
    …lead = (select personid from person where personid = (select personid from maxuser where userid = :USER ))

    related to the current user being the person on a team assigned as owner group (replace ownergroup with persongroup if needed)
    ownergroup in (select persongroup from persongroup where persongroup in (select persongroup from persongroupteam where respparty in (select personid from person where personid = (select personid from maxuser where userid = :USER ))))


    You can also have other substitution variables in the same query such as, a query for work awaiting approval over 90 days (replace getdate() with SYSDATE for Oracle)
    ...status = 'WAPPR' and reportdate > getdate()-90)


    ((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0) and (exists (select 1 from dbo.assignment where (laborcode = (select laborcode from labor where personid = (select personid from person where personid = (select personid from maxuser where userid = :USER)))) and (exists (select 1 from workorder yy where ((yy.istask = 1 and yy.parent = workorder.wonum ) or (yy.wonum = workorder.wonum)) and assignment.wonum = yy.wonum and yy.siteid = workorder.siteid) and siteid = workorder.siteid)))

    ------------------------------
    Christopher Winston
    Projetech Inc.
    ------------------------------

    Attachment(s)