Issues when Querying Work Orders containing the number “7”

Forums MxLoader Issues when Querying Work Orders containing the number “7”

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #19967
    hannah
    Participant

    When I try to query work orders containing the number 7 in the work order number, for example one from 2017 (beginning “17.”) I get an unexpected server response with error code 2147745793. This also happens with the number 5 but doesn’t seem to happen when I try other numbers such as 8 or 9 if looking for work orders beginning with “18.” or “19.” I have attached a screenshot of the error. I am just copy pasting the where clause directly from the Maximo search so as not to make any errors with SQL. Here is the where clause I am using:

    ((status = ‘CLOSE’ or status = ‘COMP’) and (woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and istask = 0 and siteid = ‘DUB’ and (location like ‘%LP%’ or location like ‘%SH%’ or location like ‘%SL%’) and wonum like ‘%17.%’)

    When I use this same code but change the 7 to an 8 or a 9 I don’t get the error

     

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.
You must be logged in to reply to this topic.
Scroll to top