Maximo

Expand all | Collapse all

Saved query: Parameter via dialog window?

  • 1.  Saved query: Parameter via dialog window?

    Posted 3 days ago
    Edited by User1971 6 hours ago
    MAM 7.6.1.2:

    My organization uses this query for the Anywhere Work Technician WO list:

    --select WOs and tasks that are INPRG and that are assigned to me or my crew

    woclass = 'WORKORDER' AND worktype <> 'INSP' AND status IN (SELECT VALUE FROM maximo.synonymdomain WHERE domainid = 'WOSTATUS' AND maxvalue IN ('INPRG')) AND ( (EXISTS (SELECT 1 FROM maximo.assignment WHERE assignment.wonum = workorder.wonum AND siteid = workorder.siteid AND ( laborcode = (SELECT laborcode FROM maximo.labor WHERE personid = :&PERSONID&) OR laborcode IN (SELECT laborcode FROM maximo.amcrewlabor WHERE amcrew IN (SELECT amcrew FROM maximo.amcrewlabor WHERE laborcode = (SELECT laborcode FROM maximo.labor WHERE personid = :&PERSONID&)))))) OR (wonum IN (SELECT parent FROM maximo.workorder WHERE woclass = 'ACTIVITY' AND (EXISTS (SELECT 1 FROM maximo.assignment WHERE assignment.wonum = workorder.wonum AND siteid = workorder.siteid AND status IN ('ASSIGNED', 'STARTED') AND ( laborcode = (SELECT laborcode FROM maximo.labor WHERE personid = :&PERSONID&) OR laborcode IN (SELECT laborcode FROM maximo.amcrewlabor WHERE amcrew IN (SELECT amcrew FROM maximo.amcrewlabor WHERE laborcode = (SELECT laborcode FROM maximo.labor WHERE personid = :&PERSONID&)))))))))


    As a supervisor, I want to be able to "see what my Anywhere users see" to make sure that I've set up their WOs correctly.

    The above Anywhere query is available to me in the WOTRACK list view as a saved query.
    However, when I run the query, I don't have a way to specify what PERSONID I want to run the query on (it runs on the currently logged in user (me) and that's not what I want).

    For saved queries like this, is there a way to enter a parameter into a dialog window to filter the query?



  • 2.  RE: Saved query: Parameter via dialog window?

    Posted 2 days ago
    I'm not aware of a way to do this. I would just make a copy of the query with the "parameter" hard-coded. Then, the dialog you would enter the parameter into would be the View/Manage Saved Queries dialog.

    ------------------------------
    Blessings,
    Jason Uppenborn
    Sr. Technical Maximo Consultant
    Ontracks Consulting
    ------------------------------



  • 3.  RE: Saved query: Parameter via dialog window?

    Posted 2 days ago
    In addition to what Jason recommends you could also create either an ad-hoc report or a new static report and parametrize the person value.  Or you could create an outer report to generate a list of persons who report to you as a supervisor (or any person running the report.). This would provide a list of the persons for whom a subsequent sub report then shows the work orders using this query.

    ------------------------------
    Bradley K. Downing , MBA
    IBM Certified Adv. Deployment Prof. Maximo v7.6.1
    IBM
    Bakersfield CA
    ------------------------------