List of Contributions

Jason Verly

Contact Details

My Content

1 to 20 of 23 total

RE: Query for long description

Posted By Jason Verly 01-27-2023 09:21
Found In Community: Maximo Open Forum \ view thread
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 ldkey=pm.pmuid and ldownertable='PM' and ldownercol='DESCRIPTION' and ldtext is not null)​ The reason ...

RE: Spare Parts and Spare Part Auto Add in Maximo

Posted By Jason Verly 09-29-2022 10:49
Found In Egroup: Maximo Open Forum \ view thread
One of our users found your blog post and led to a great discussion on why we should or should not use that feature for their item/inventory records. The caveat I warned the user about was using this check box is a one way street. Once it's added as a spare part, it will be added to the asset's spare ...

Refresher on passing system properties in a Communication Template

Posted By Jason Verly 09-29-2022 10:39
Found In Egroup: Maximo Open Forum \ view thread
Hi, There are a few key Communication Templates that can pull information from the source record and pass it along to a user. The best example is the default password reset Comm Template: Enclosed is your new Maximo password: (0) To log in and change your password, follow this link: https ...

RE: How to create a variable for a dotted notation value?

Posted By Jason Verly 04-25-2022 11:34
Found In Egroup: Maximo Open Forum \ view thread
Thanks for the answers. I tried the first option by trying to call the dotted notation field, but that didn't work for some reason. I'll try the second method and report back. ------------------------------ Jason Verly Agropur ------------------------------

How to create a variable for a dotted notation value?

Posted By Jason Verly 04-24-2022 20:27
Found In Egroup: Maximo Open Forum \ view thread
I recently created an Automation Script to verify if the currently opened PR had a value in a related field on the Companies table. I normally just create a variable in the script to pull in dot notation values like this: In my script I can create a variable on the SITEID easily: from psdi.mbo ...

Deactivating Person records when still on Revised/Inactive records

Posted By Jason Verly 04-20-2022 22:19
Found In Community: Maximo Open Forum \ view thread
I'm curious how others have handled deactivating employees in the Person app when they are still listed on inactive or revised records. Our biggest struggle is finding a way a normal can deactivate a Person record and not have to give them SQL server access or require an administrator to handle an activity ...

RE: Back Order Reports

Posted By Jason Verly 03-02-2022 10:32
Found In Egroup: Maximo Open Forum \ view thread
Can you share the query you used to find the PO's? ------------------------------ Jason Verly Agropur ------------------------------

RE: Back Order Reports

Posted By Jason Verly 02-23-2022 11:24
Found In Egroup: Maximo Open Forum \ view thread
Hi Gina, Here's an example of the extended report object I have in our Maximo environment. The pink box is the main PO table and is what IBM provides out of the box. The additional tables in the green box are what I've extended for options in our Ad-Hoc/QBR reporting. ------------------------------ ...

RE: Back Order Reports

Posted By Jason Verly 02-21-2022 09:27
Found In Egroup: Maximo Open Forum \ view thread
Hi Gina, Do you know if your Maximo administrator has take any steps to expand the fields you can select in a QBR/Ad-Hoc Purchasing report? Out of the box, Maximo will just have a single report option for main Purchase Order (PO table) fields. A common task by either a Maximo admin or Report Developer ...

RE: Back Order Reports

Posted By Jason Verly 02-18-2022 12:13
Found In Egroup: Maximo Open Forum \ view thread
Hi Gina, Do you need to see the actual PO lines that are not complete or just a list of PO's that have an incomplete line? ------------------------------ Jason Verly Agropur ------------------------------

RE: Date query help

Posted By Jason Verly 02-04-2022 09:22
Found In Community: Maximo Open Forum \ view thread
I'll give an example for SQL Server, but this can easily translate to Oracle or DB2. You were on the right track with trying to find a record inside a date range. The method I use in Maximo would be written as: ... and (schedstart >= dateadd(d,-1,datediff(d,-0,getdate())) and schedstart < getdate())​ ...

RE: Date query help

Posted By Jason Verly 02-03-2022 18:09
Found In Community: Maximo Open Forum \ view thread
Are you on SQL Server, Oracle or DB2?

RE: Download Maximo report as PDF

Posted By Jason Verly 01-31-2022 12:14
Found In Egroup: Maximo Open Forum \ view thread
That jar file needs to be placed on your Maximo server as well. This should be placed in the same folder as you placed it in your BIRT development folder. This will require the EAR files to be rebuilt/redeployed. ------------------------------ Jason Verly Agropur ------------------------------

RE: Download Maximo report as PDF

Posted By Jason Verly 01-27-2022 09:44
Found In Egroup: Maximo Open Forum \ view thread
Hi, Can you give some background on how you coded the QR code generator into the report? Jason ------------------------------ Jason Verly Agropur ------------------------------

RE: How is Targetstartdate and TargetCompdates are calculated for Wo being generated from Route.

Posted By Jason Verly 07-01-2021 20:44
Found In Egroup: Maximo Open Forum \ view thread
Hi Biblab, I don't have the error, I was asking Meghana where the error was popping up. Jason ------------------------------ Jason Verly Agropur ------------------------------

RE: How is Targetstartdate and TargetCompdates are calculated for Wo being generated from Route.

Posted By Jason Verly 07-01-2021 12:48
Found In Egroup: Maximo Open Forum \ view thread
Is this error preventing the PM to generate work orders or is this on the WO itself? ------------------------------ Jason Verly Agropur ------------------------------

RE: Automation Script method to prevent TARGSTARTDATE validation

Posted By Jason Verly 06-30-2021 10:58
Found In Egroup: Maximo Open Forum \ view thread
Hi Travis, No, the initial script was to set on Save with an Object Launch Point to update the FNLCONSTRAINT date field to match the grace period standard in SMRP 5.4.10 spec. As we worked through that update we found the validation error on changes with the TARGCOMPDATE and wanted to expand the scope ...

RE: Automation Script method to prevent TARGSTARTDATE validation

Posted By Jason Verly 06-25-2021 09:25
Found In Egroup: Maximo Open Forum \ view thread
Thanks Steve. I did some more research last night and thought this was the answer I was going to find this morning. Back up plan now is to assess our use of TARGCOMPDATE and then possibly null out the value as a standard. It's hacky, but may actually be the right step based on how I think we're not ...

Automation Script method to prevent TARGSTARTDATE validation

Posted By Jason Verly 06-24-2021 16:47
Found In Egroup: Maximo Open Forum \ view thread
One of the options I always thought that should be built into Maximo is when a user change/updates TARGSTARTDATE on a Work Order the TARGCOMPDATE field should automatically update as well. I've now had enough of my users make this request that I've started to work on an automation script to do this. ...

RE: Set checkbox to checked by default in pop-up dialog boxes

Posted By Jason Verly 05-24-2021 11:23
Found In Egroup: Maximo Open Forum \ view thread
Got it to work. Noticed there are 2 re-order screens in Inventory and I was trying to update one that isn't called from the List tab. ------------------------------ Jason Verly Agropur ------------------------------