Querying Work Orders between two Actual Finish dates

Forums MxLoader Querying Work Orders between two Actual Finish dates

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #20035
    Hannah Grace-Parker
    Participant

    Hi,

    I have been trying to query work orders between August 1st and 31st, and I have used the advanced search in Maximo to copy the ‘where clause’ into the query cell for MxLoader (I am not a coding genius!), however, this code does not want to run in MxLoader and I figure it is something to do with the way the timestamp is put in, but I have no idea what to do to change it.

    Here is the where clause code I am using:

    ((status = ‘CLOSE’ or status = ‘COMP’) and (woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and actfinish <= { ts ‘2020-09-01 00:45:00.000’ } and istask = 0 and siteid = ‘DUB’ and actfinish >= { ts ‘2020-08-01 01:00:00.000’ })

    Many thanks,

    Hannah

    #20047
    Hannah Grace-Parker
    Participant

    Still looking for a solution to this problem if anyone has any ideas?

    #20111
    Craig Kokay
    Participant

    I have just run your query with minor modifications.  I had to ensure that the quotes were NOT the curly type and they need to be the straight type:

     
    <table border=”0″ width=”566″ cellspacing=”0″ cellpadding=”0″><colgroup><col width=”566″ /></colgroup>
    <tbody>
    <tr>
    <td class=”xl66″ style=”height: 43.2pt; width: 425pt;” width=”566″ height=”58″><span style=”mso-spacerun: yes;”> </span>((status = ‘CLOSE’ or status = ‘COMP’) and (woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and istask = 0 and siteid = ‘BEDFORD’
    and actfinish between { ts ‘2001-08-01 01:00:00.000’ } and { ts ‘2020-09-01 00:45:00.000’ } )</td>
    </tr>
    </tbody>
    </table>
     

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.
You must be logged in to reply to this topic.
Scroll to top