I have a Start Center that has Result Set portlets based on the WOTRACK application. I have a clone of the WOTRACK application that is used for updating records. Is it possible to link to the cloned WOTRACK Read more

I'll add another version of the query to the one @Sid Ogden gave (which is absolutely correct) with one that uses the EXISTS statement: siteid = 'WODM' and exists(select null from longdescription where Read more

Does anyone have any info on what is considered to be best practice for these two use cases? Thanks for any help you can lend! #EndUser #EverythingMaximo #MaximoUserGroups ------------------------------ Read more

It looks like the culprit is the beginning part of the query in your first screenshot: (mxrsource != 'FRC' or mxrsource is null) The other query does not have that. So I am guessing that field is some Read more

I agree with Prashant, I think first you need to dissociate some of the apps from doctypes (Attachment Library/Folders > Associate Folders dialog and the appdoctype table). That is probably the best approach. Read more

Hi Eric, Make a new relationship and try this where clause (child table=WFTRANSACTION). It will get the WF transaction with the most recent date for the WO. ownertable = 'WORKORDER' and ownerid = :workorderid Read more

@Steven Shull that's what I was afraid of. We will eventually be going to MAS but probably not for a few years. I guess we'll just have to live with the way it works​

The legacy work centers are not easily customizable and don't have a supported process to persist your changes on updates. It can be done but I wouldn't recommend it because it'd be a short-lived customization. Read more

Our organization is in the process of implementing the "Submit a Service Request" Work Center. When you go to add a new Service Request you drill down by clicking on "bubbles" (i.e. Classifications) It Read more