Searching for Records: Queries • Query –Allows users to send a request to Maximo, to only show records that meet requested criteria. • Default Query –...
Introduction • SQL is the Structured Query Language • It is used to interact with the DBMS • SQL can – Create Schemas in the DBMS – Alter Schemas
GOLD advanced. Sally Burgess. Amanda thomas coursebook advanced. GO. L. D advanced co ursebo ok B urgess • t ho m as with 2015 exam specifications. 19/ 12/2013 11:56. SAMPLE. GoldAdvBlad.indd 1. 06/01/2014 12:18
Dying Testimonies Of Saved And Unsaved • 001 -- Triumphant Death Of Ignatius • 002 -- Wonderful Conversion Of Mary Lones • 003 -- The Awful Death Of Sir Francis
Journal of Case Research in Business and Economics Google: Searching for Value, Page 2 Introduction The Google search engine has become so popular that it is now
Christina H. Dorr, PhD, has been an Elementary Media Specialist for twenty-one years, currently with Hilliard (Ohio). City School District. She also is an Adjunct ... those “scandalous anecdotes.”3 What is most intriguing, however, is the voice: ....
Database Systems Instructors: Hao-Hua Chu Winston Hsu Fall Semester, 2007 Assignment 3: SQL Queries Questions 1. The following relations keep track of airline flight
I met my future husband around Thanksgiving 1972, where else but church? I fell hard, but never felt worthy of him. He had not done all the horrible
INTRODUCTION: You can extract data (i.e. the total cost report) directly from the Truck Tracker SQL Server database by using a 3rd party data tools such as Excel or
Common Queries of Investors Primary Markets 1. When the company is going to get listed on exchange? Companies seeking public issue of their securities file their
Download Abstrak. Metode pengukuran beban kerja mental meliputi metode obyektif dan subyektif. Metode ... dapat digolongkan menjadi kerja fisik (otot) dan kerja mental ...
THE WILLEMS® APPROACH INTRODUCTION & ADVANCED COURSE ... based on the teaching principles of Edgar Willems. The course is aimed at : 1
Download Journal of Advanced Research (abbreviated as J. Adv. Res.) is an applied/ natural sciences, peer- reviewed journal with interdisciplinary activity. The journal ...
31 Dis 1984 ... ABSTRACT. A Tagalog reader designed for adult students beyond the intermediate level contains 30 lessons in agriculture, art, economics, education, history, language, literature, medicine, music, political science, religion, and socio
Advanced Metering Infrastructure (AMI) Overview of AMI Advanced metering systems are comprised of state-of-the-art electronic/digital hardware and software, which combine
Download Journal of Advanced Research (abbreviated as J. Adv. Res.) is an applied/ natural sciences, peer- reviewed journal with interdisciplinary activity. The journal ...
CALCULO DE STOCKS Como se visualiza en la imagen se debe establecer primero el almacén sobre el cual se va a trabajar y el periodo de tiempo en el cual se van a
Advanced Financial Accounting May 2012 2nd Year Paper 4 SECTION A Answer ALL THREE Questions in this Section QUESTION 1 (Compulsory) (a) The primary objective of
59 R. S. Hartenberg and J. Denavit, “A kinematic notation for lower pair mechanisms based on matrices,” Journal of Applied Mechanics, vol. 77, pp. 215–221, June
Louisiana Comprehensive Curriculum, Revised 2008 Advanced Mathematics Pre-Calculus . ... It is best to use the pdf format of a document if a printed
Download Advanced Registration. Manual. 4. Creating a New Event: • Click the Add New Event button. To create a new event, simply follow the tabs and fill in the information that is important to you. The only required fields are Title and. Start/
Advanced Programming with C++ 2 C++ PROGRAMMING CONSTRUCTS 1.3.2 Linux Here your compiler is g++ and your IDE is Eclipse 1.4 Major project for 2010
Using Maximo’s Advanced Searching & Saved Queries Presenter: Erin Johnston For Audio: Phone: 1-888-296-6500 Code:738859#
February 5, 2009
www.ontracksconsulting.com
Agenda • Searching for Records: Queries • Why use Saved Queries • Wildcards & Quick Tips • Commonly Used Saved Queries • Live Demonstration
For Audio: Phone: 1-888-296-6500 Code:738859#
www.ontracksconsulting.com
Searching for Records: Queries •
Query – Allows users to send a request to Maximo, to only show records that meet requested criteria.
•
Default Query – Maximo runs the query every time the application is opened, and may be used when a user requests the same data set every time
•
Saved Query – A re-useable query to the Maximo Database *A Saved Query is required to have a Result Set on a Maximo Dashboard For Audio: Phone: 1-888-296-6500 Code:738859# www.ontracksconsulting.com
Searching for Records: Methods •
The List Tab is used in most applications to build the query, this can be done with the following methods; • List Filter to search field values on the List Screen • Search using the More Search Fields dialog box • Search using a previously Saved Query • Search using a SQL Where clause written on the fly
www.ontracksconsulting.com
Wildcards Wildcard
Use
* Or %
To stand for any number of characters in the specified position
_ Or ?
To stand for a single character in the specified position
Examples: • “V%” is a search for a record whose data starts with a V • “%V” is a search for a record who ends with a V • “%V%” is a search for a record with a V in the middle • “V00_” is a search for a record that is four characters long and starts with ‘V00’
www.ontracksconsulting.com
Equal Sign, Null Values & Search Between Operators
Use
=
Means match exactly
~null~
Searching for null values
!=~null~
Searching for not-null values
Between ____ and ____
Searching between to values
Examples: • “=2102BEV” to find records with exactly 2102BEV in the field • “reportdate between ‘10-10-2009’ and ‘10-12-2009’” find records between a date range
www.ontracksconsulting.com
Common Saved Queries •
• •
Work Orders; • Assigned Work Orders • Past Due Work Orders • Status Work Orders – for example; Waiting for Approval, Complete • Specific Asset Failure Events PMs; • PMs due in the next 30 Days POs; • Waiting for Approval • Received but not yet invoiced
www.ontracksconsulting.com
Tips •
•
Unique Query Names: Maximo requires each query name to be unique, if multiple users require the same or similar query try adding the users initials to the end of the query name Field Names: Use ALT+F1 to determine the column name of fields to add to the Query SQL Where Clause.
www.ontracksconsulting.com
Demonstration 1. Each of the Maximo Search Methods 2. Using Wildcards & Operators
