Pie chart for two special cases in result set with maximo 7.5
I am working with the Maximo version 7.5. I want to display a result set on the start center in pie chart that contains closed Un-Planned WOs which statuses are cancelled (completed/close) vs
created Un-Planned WOs which statuses are not cancelled. How can I use the result set to get only these two cases but not all statuses?
Query for closed Un-Planned WOs:
(
(status = 'CLOSE' or status = 'COMPLETED')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
Query for created Un-Planned WOs:
(
(status != 'CAN')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
pie-chart status maximo
edited Dec 5 '18 at 11:01
Happypig375
646625
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
add a comment |
I am working with the Maximo version 7.5. I want to display a result set on the start center in pie chart that contains closed Un-Planned WOs which statuses are cancelled (completed/close) vs
created Un-Planned WOs which statuses are not cancelled. How can I use the result set to get only these two cases but not all statuses?
Query for closed Un-Planned WOs:
(
(status = 'CLOSE' or status = 'COMPLETED')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
Query for created Un-Planned WOs:
(
(status != 'CAN')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
pie-chart status maximo
edited Dec 5 '18 at 11:01
Happypig375
646625
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
Can you post some code that you have written in an attempt to solve this?
– Happypig375
Nov 25 '18 at 13:45
(((woclass = 'WORKORDER' or woclass = 'ACTIVITY')and historyflag = 0 and istask = 0 and siteid = 'SPCSITE'))and (((status = 'APPR' or status = 'READY' or status = 'WPCOND' or status = 'CLOSE' or status = 'COMP' or status = 'HISTEDIT' or status = 'COMPLETED' or status = 'DEFERRED' or status = 'FDBKDN' or status = 'HOLD' or status = 'INPRG' or status = 'RELEASED' or status = 'RELREQ' or status = 'REMOVED' or status = 'ACTIVE' or status = 'INPLAN' or status = 'WAPPR' or status = 'WREV' or status = 'WMATL') and istask = 0 and(worktype = 'CM')))
– aya fawzy
Nov 27 '18 at 11:47
Not in the comments! Please edit the question to include the code. It's unreadable this way.
– Happypig375
Nov 27 '18 at 11:56
ok , check it plz
– aya fawzy
Dec 5 '18 at 9:09
add a comment |
I am working with the Maximo version 7.5. I want to display a result set on the start center in pie chart that contains closed Un-Planned WOs which statuses are cancelled (completed/close) vs
created Un-Planned WOs which statuses are not cancelled. How can I use the result set to get only these two cases but not all statuses?
Query for closed Un-Planned WOs:
(
(status = 'CLOSE' or status = 'COMPLETED')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
Query for created Un-Planned WOs:
(
(status != 'CAN')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
pie-chart status maximo
edited Dec 5 '18 at 11:01
Happypig375
646625
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
I am working with the Maximo version 7.5. I want to display a result set on the start center in pie chart that contains closed Un-Planned WOs which statuses are cancelled (completed/close) vs
created Un-Planned WOs which statuses are not cancelled. How can I use the result set to get only these two cases but not all statuses?
Query for closed Un-Planned WOs:
(
(status = 'CLOSE' or status = 'COMPLETED')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
Query for created Un-Planned WOs:
(
(status != 'CAN')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0
and istask = 0
and siteid = 'SPCSITE'
and upper(exedepartment) = 'ELECT'
and (worktype != 'PM' or worktype != 'PMCAL')
)
and (
exists (
select 1 from dbo.locations
where ((upper(division) = 'ETH'))
and (
location = workorder.location
and siteid=workorder.siteid
)
)
)
pie-chart status maximo
pie-chart status maximo
edited Dec 5 '18 at 11:01
Happypig375
646625
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
edited Dec 5 '18 at 11:01
Happypig375
646625
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
edited Dec 5 '18 at 11:01
Happypig375
646625
edited Dec 5 '18 at 11:01
Happypig375
646625
edited Dec 5 '18 at 11:01
Happypig375
646625
646625
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
asked Nov 25 '18 at 12:52
aya fawzyaya fawzy
83
83
Can you post some code that you have written in an attempt to solve this?
– Happypig375
Nov 25 '18 at 13:45
(((woclass = 'WORKORDER' or woclass = 'ACTIVITY')and historyflag = 0 and istask = 0 and siteid = 'SPCSITE'))and (((status = 'APPR' or status = 'READY' or status = 'WPCOND' or status = 'CLOSE' or status = 'COMP' or status = 'HISTEDIT' or status = 'COMPLETED' or status = 'DEFERRED' or status = 'FDBKDN' or status = 'HOLD' or status = 'INPRG' or status = 'RELEASED' or status = 'RELREQ' or status = 'REMOVED' or status = 'ACTIVE' or status = 'INPLAN' or status = 'WAPPR' or status = 'WREV' or status = 'WMATL') and istask = 0 and(worktype = 'CM')))
– aya fawzy
Nov 27 '18 at 11:47
Not in the comments! Please edit the question to include the code. It's unreadable this way.
– Happypig375
Nov 27 '18 at 11:56
ok , check it plz
– aya fawzy
Dec 5 '18 at 9:09
add a comment |
Can you post some code that you have written in an attempt to solve this?
– Happypig375
Nov 25 '18 at 13:45
(((woclass = 'WORKORDER' or woclass = 'ACTIVITY')and historyflag = 0 and istask = 0 and siteid = 'SPCSITE'))and (((status = 'APPR' or status = 'READY' or status = 'WPCOND' or status = 'CLOSE' or status = 'COMP' or status = 'HISTEDIT' or status = 'COMPLETED' or status = 'DEFERRED' or status = 'FDBKDN' or status = 'HOLD' or status = 'INPRG' or status = 'RELEASED' or status = 'RELREQ' or status = 'REMOVED' or status = 'ACTIVE' or status = 'INPLAN' or status = 'WAPPR' or status = 'WREV' or status = 'WMATL') and istask = 0 and(worktype = 'CM')))
– aya fawzy
Nov 27 '18 at 11:47
Not in the comments! Please edit the question to include the code. It's unreadable this way.
– Happypig375
Nov 27 '18 at 11:56
ok , check it plz
– aya fawzy
Dec 5 '18 at 9:09
Can you post some code that you have written in an attempt to solve this?
– Happypig375
Nov 25 '18 at 13:45
Can you post some code that you have written in an attempt to solve this?
– Happypig375
Nov 25 '18 at 13:45
(((woclass = 'WORKORDER' or woclass = 'ACTIVITY')and historyflag = 0 and istask = 0 and siteid = 'SPCSITE'))and (((status = 'APPR' or status = 'READY' or status = 'WPCOND' or status = 'CLOSE' or status = 'COMP' or status = 'HISTEDIT' or status = 'COMPLETED' or status = 'DEFERRED' or status = 'FDBKDN' or status = 'HOLD' or status = 'INPRG' or status = 'RELEASED' or status = 'RELREQ' or status = 'REMOVED' or status = 'ACTIVE' or status = 'INPLAN' or status = 'WAPPR' or status = 'WREV' or status = 'WMATL') and istask = 0 and(worktype = 'CM')))
– aya fawzy
Nov 27 '18 at 11:47
(((woclass = 'WORKORDER' or woclass = 'ACTIVITY')and historyflag = 0 and istask = 0 and siteid = 'SPCSITE'))and (((status = 'APPR' or status = 'READY' or status = 'WPCOND' or status = 'CLOSE' or status = 'COMP' or status = 'HISTEDIT' or status = 'COMPLETED' or status = 'DEFERRED' or status = 'FDBKDN' or status = 'HOLD' or status = 'INPRG' or status = 'RELEASED' or status = 'RELREQ' or status = 'REMOVED' or status = 'ACTIVE' or status = 'INPLAN' or status = 'WAPPR' or status = 'WREV' or status = 'WMATL') and istask = 0 and(worktype = 'CM')))
– aya fawzy
Nov 27 '18 at 11:47
Not in the comments! Please edit the question to include the code. It's unreadable this way.
– Happypig375
Nov 27 '18 at 11:56
Not in the comments! Please edit the question to include the code. It's unreadable this way.
– Happypig375
Nov 27 '18 at 11:56
ok , check it plz
– aya fawzy
Dec 5 '18 at 9:09
ok , check it plz
– aya fawzy
Dec 5 '18 at 9:09
add a comment |
1 Answer
1
active
oldest
votes
I don't have time to try it, but I would create an ALN domain with the two statuses you want to show, create a relationshiop from workorder to your domain that will find the right value based on your criteria, then add to or create a Report Object Structure that includes ALNDOMAIN via your relationship. After all that, you may be able to use that related value for the attribute to base the graph on.
If that doesn't work, it's probably because the attribute to graph on has to be local (i.e. on WORKORDER). In that case, you'll need to add an attribute to WORKORDER and manage it via an escalation or autoscript.
But your query has problems in it, too. The history flag will be set (historyflag=1) when the status is CLOSE or CAN. It may also be set when the status is COMP, depending on your Organization > Work Order Options.
answered Jan 18 at 17:11
PreacherPreacher
615417
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53467617%2fpie-chart-for-two-special-cases-in-result-set-with-maximo-7-5%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I don't have time to try it, but I would create an ALN domain with the two statuses you want to show, create a relationshiop from workorder to your domain that will find the right value based on your criteria, then add to or create a Report Object Structure that includes ALNDOMAIN via your relationship. After all that, you may be able to use that related value for the attribute to base the graph on.
If that doesn't work, it's probably because the attribute to graph on has to be local (i.e. on WORKORDER). In that case, you'll need to add an attribute to WORKORDER and manage it via an escalation or autoscript.
But your query has problems in it, too. The history flag will be set (historyflag=1) when the status is CLOSE or CAN. It may also be set when the status is COMP, depending on your Organization > Work Order Options.
answered Jan 18 at 17:11
PreacherPreacher
615417
add a comment |
I don't have time to try it, but I would create an ALN domain with the two statuses you want to show, create a relationshiop from workorder to your domain that will find the right value based on your criteria, then add to or create a Report Object Structure that includes ALNDOMAIN via your relationship. After all that, you may be able to use that related value for the attribute to base the graph on.
If that doesn't work, it's probably because the attribute to graph on has to be local (i.e. on WORKORDER). In that case, you'll need to add an attribute to WORKORDER and manage it via an escalation or autoscript.
But your query has problems in it, too. The history flag will be set (historyflag=1) when the status is CLOSE or CAN. It may also be set when the status is COMP, depending on your Organization > Work Order Options.
answered Jan 18 at 17:11
PreacherPreacher
615417
add a comment |
I don't have time to try it, but I would create an ALN domain with the two statuses you want to show, create a relationshiop from workorder to your domain that will find the right value based on your criteria, then add to or create a Report Object Structure that includes ALNDOMAIN via your relationship. After all that, you may be able to use that related value for the attribute to base the graph on.
If that doesn't work, it's probably because the attribute to graph on has to be local (i.e. on WORKORDER). In that case, you'll need to add an attribute to WORKORDER and manage it via an escalation or autoscript.
But your query has problems in it, too. The history flag will be set (historyflag=1) when the status is CLOSE or CAN. It may also be set when the status is COMP, depending on your Organization > Work Order Options.
answered Jan 18 at 17:11
PreacherPreacher
615417
I don't have time to try it, but I would create an ALN domain with the two statuses you want to show, create a relationshiop from workorder to your domain that will find the right value based on your criteria, then add to or create a Report Object Structure that includes ALNDOMAIN via your relationship. After all that, you may be able to use that related value for the attribute to base the graph on.
If that doesn't work, it's probably because the attribute to graph on has to be local (i.e. on WORKORDER). In that case, you'll need to add an attribute to WORKORDER and manage it via an escalation or autoscript.
But your query has problems in it, too. The history flag will be set (historyflag=1) when the status is CLOSE or CAN. It may also be set when the status is COMP, depending on your Organization > Work Order Options.
answered Jan 18 at 17:11
PreacherPreacher
615417
answered Jan 18 at 17:11
PreacherPreacher
615417
answered Jan 18 at 17:11
PreacherPreacher
615417
answered Jan 18 at 17:11
PreacherPreacher
615417
615417
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53467617%2fpie-chart-for-two-special-cases-in-result-set-with-maximo-7-5%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you post some code that you have written in an attempt to solve this?
– Happypig375
Nov 25 '18 at 13:45
(((woclass = 'WORKORDER' or woclass = 'ACTIVITY')and historyflag = 0 and istask = 0 and siteid = 'SPCSITE'))and (((status = 'APPR' or status = 'READY' or status = 'WPCOND' or status = 'CLOSE' or status = 'COMP' or status = 'HISTEDIT' or status = 'COMPLETED' or status = 'DEFERRED' or status = 'FDBKDN' or status = 'HOLD' or status = 'INPRG' or status = 'RELEASED' or status = 'RELREQ' or status = 'REMOVED' or status = 'ACTIVE' or status = 'INPLAN' or status = 'WAPPR' or status = 'WREV' or status = 'WMATL') and istask = 0 and(worktype = 'CM')))
– aya fawzy
Nov 27 '18 at 11:47
Not in the comments! Please edit the question to include the code. It's unreadable this way.
– Happypig375
Nov 27 '18 at 11:56
ok , check it plz
– aya fawzy
Dec 5 '18 at 9:09