Lesson 3-3

Learn Maximo: Level 3 Using Query in Maximo.
5 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€47.92
List Price:  €67.09
You save:  €19.17
£39.76
List Price:  £55.67
You save:  £15.90
CA$71.86
List Price:  CA$100.61
You save:  CA$28.75
A$79.95
List Price:  A$111.94
You save:  A$31.98
S$67.76
List Price:  S$94.87
You save:  S$27.11
HK$388.87
List Price:  HK$544.46
You save:  HK$155.58
CHF 44.66
List Price:  CHF 62.54
You save:  CHF 17.87
NOK kr565.88
List Price:  NOK kr792.28
You save:  NOK kr226.40
DKK kr357.50
List Price:  DKK kr500.54
You save:  DKK kr143.03
NZ$88.36
List Price:  NZ$123.72
You save:  NZ$35.35
د.إ183.61
List Price:  د.إ257.07
You save:  د.إ73.46
৳5,972.07
List Price:  ৳8,361.37
You save:  ৳2,389.30
₹4,246.46
List Price:  ₹5,945.38
You save:  ₹1,698.92
RM225.35
List Price:  RM315.51
You save:  RM90.16
₦77,461.50
List Price:  ₦108,452.30
You save:  ₦30,990.80
₨13,910.80
List Price:  ₨19,476.23
You save:  ₨5,565.43
฿1,709.72
List Price:  ฿2,393.75
You save:  ฿684.02
₺1,759.33
List Price:  ₺2,463.20
You save:  ₺703.87
B$304.23
List Price:  B$425.95
You save:  B$121.72
R915.31
List Price:  R1,281.50
You save:  R366.19
Лв93.65
List Price:  Лв131.12
You save:  Лв37.46
₩72,306.53
List Price:  ₩101,234.93
You save:  ₩28,928.40
₪182.68
List Price:  ₪255.76
You save:  ₪73.08
₱2,941.16
List Price:  ₱4,117.86
You save:  ₱1,176.70
¥7,821.18
List Price:  ¥10,950.28
You save:  ¥3,129.10
MX$1,003.69
List Price:  MX$1,405.25
You save:  MX$401.55
QR182.18
List Price:  QR255.07
You save:  QR72.89
P690.74
List Price:  P967.09
You save:  P276.35
KSh6,461.20
List Price:  KSh9,046.20
You save:  KSh2,585
E£2,543.65
List Price:  E£3,561.31
You save:  E£1,017.66
ብር6,381.64
List Price:  ብር8,934.81
You save:  ብር2,553.16
Kz45,890.82
List Price:  Kz64,250.82
You save:  Kz18,360
CLP$49,447.60
List Price:  CLP$69,230.60
You save:  CLP$19,783
CN¥364.74
List Price:  CN¥510.67
You save:  CN¥145.92
RD$3,043.26
List Price:  RD$4,260.81
You save:  RD$1,217.54
DA6,741.95
List Price:  DA9,439.27
You save:  DA2,697.32
FJ$115.80
List Price:  FJ$162.13
You save:  FJ$46.33
Q385.07
List Price:  Q539.13
You save:  Q154.06
GY$10,455.79
List Price:  GY$14,638.94
You save:  GY$4,183.15
ISK kr6,955.10
List Price:  ISK kr9,737.70
You save:  ISK kr2,782.60
DH502.98
List Price:  DH704.21
You save:  DH201.23
L918.26
List Price:  L1,285.64
You save:  L367.37
ден2,949.73
List Price:  ден4,129.86
You save:  ден1,180.13
MOP$400.09
List Price:  MOP$560.15
You save:  MOP$160.06
N$920.09
List Price:  N$1,288.20
You save:  N$368.11
C$1,839.03
List Price:  C$2,574.79
You save:  C$735.75
रु6,798.06
List Price:  रु9,517.84
You save:  रु2,719.77
S/186.09
List Price:  S/260.55
You save:  S/74.45
K202.66
List Price:  K283.74
You save:  K81.08
SAR187.79
List Price:  SAR262.92
You save:  SAR75.13
ZK1,383.09
List Price:  ZK1,936.44
You save:  ZK553.34
L238.52
List Price:  L333.95
You save:  L95.43
Kč1,204.37
List Price:  Kč1,686.22
You save:  Kč481.84
Ft19,842.53
List Price:  Ft27,781.13
You save:  Ft7,938.60
SEK kr551.51
List Price:  SEK kr772.16
You save:  SEK kr220.65
ARS$51,075.09
List Price:  ARS$71,509.21
You save:  ARS$20,434.12
Bs345.34
List Price:  Bs483.51
You save:  Bs138.16
COP$217,942.60
List Price:  COP$305,137.08
You save:  COP$87,194.48
₡25,214.88
List Price:  ₡35,302.85
You save:  ₡10,087.97
L1,268.63
List Price:  L1,776.18
You save:  L507.55
₲389,688.96
List Price:  ₲545,595.73
You save:  ₲155,906.76
$U2,236.96
List Price:  $U3,131.93
You save:  $U894.96
zł204.31
List Price:  zł286.05
You save:  zł81.74
Already have an account? Log In

Transcript

Hi this is Troy again, who is talking now about how can query being useful you can make a lot of queries New York for example, you can make query for the common news material or items and the list will be updated. Two, you can make query for unapproved we are too full of this abroad if you are and they and they get approved with approval of them. Number three, make queries of current p O's to to see the status of web Oh, it is finished and you can receive it. You can receive Zen's items or materials. Number four, you can make query for tomorrow's work. Or you can make query for this hedgehog How can we do this?

We will we will see in the next slides. For the items in an inventory, you can open inventory and they both have items separated by comma. In this example, we we bought the cartridge, the cartridge, the ink cartridge of the color, a color printer. And the woods is a number of items, number of each encourage cartridge. severity by Komal exists. If we run, you get this screen, the severity item of the ink cartridge and the balance of Zim this valance updated if you open the query, it would be less or more or more than you show him you see here Make multi use the queries if needed for each group of items and to see directly in once at once the current balance of Zim number two if you will need to see the VRS of this items, you can both items separated by comma and the item field here is the VR.

You can save the query by suitable name for all users for for yourself. Then it is the result represent the number of prs request contains this items. You can make the same invoices in Gordo's but also this items and see which which to our status, closed on the incentive FF means items were received the wiser warehouse if you wanted to make a query for tomorrow's work you have no code does Advanced Search both the smaller day target start both target start and target start finish for Christmas 170 it will give you the tomatoes or list and we'll repeat it and updated this every every day. You will you repeat this every day. He was there as well been said anything here. And it does start at the start from to the same date of tomorrow.

He wants to do this every day too good to get update. I'm just kidding. No, you will learn you have to do this. Automatically you write this SQL statement I attached with a video. That's the coolest statement you you don't need to write it and the both it and we're close from here. You voted here and this will give you the tomorrow work updating every every day.

If you want this each work, essentially if you if you work eight six strugglin it will be for the start system date plus one to start two plus seven. This is one week. If you want or to week to week, it will be system D plus 13. And also this SQL statement attached with the video Send you for any questions. You can contact me at crude oil@gmail.com or this is my cell phone bye

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.