<p>Need help with this query to parse passed and failed from longdescription text</p>
<p> </p>
<p><b>select</b> </p>
<p>MAXIMO.WOACTIVITY.WOGROUP,</p>
<p>MAXIMO.WOACTIVITY.WORKORDERID,</p>
<p>MAXIMO.WOACTIVITY.DESCRIPTION,</p>
<p>MAXIMO.WORKORDER.ACTFINISH,</p>
<p>MAXIMO.WORKORDER.STATUS,</p>
<p>MAXIMO.WORKORDER.WONUM,</p>
<p>MAXIMO.WORKORDER.JPNUM,</p>
<p>MAXIMO.WORKORDER.ISTASK,</p>
<p>MAXIMO.WORKORDER.LOCATION,</p>
<p>MAXIMO.WORKORDER.WORKTYPE,</p>
<p>MAXIMO.WORKORDER.SUBWTYPE,</p>
<p>MAXIMO.WORKORDER.BRANCHID,</p>
<p>MAXIMO.LONGDESCRIPTION.LDTEXT,</p>
<p> </p>
<p>MAXIMO.WORKORDER.CREWID,</p>
<p>MAXIMO.LOCATIONS.SPACECLASS</p>
<p><b>from</b> </p>
<p>MAXIMO.WOACTIVITY</p>
<p><b>INNER</b> <b>JOIN</b> MAXIMO.WORKORDER <b>ON</b> MAXIMO.WOACTIVITY.WOGROUP <b>=</b> MAXIMO.WORKORDER.WONUM</p>
<p><b>INNER</b> <b>JOIN</b> MAXIMO.LONGDESCRIPTION <b>ON</b> MAXIMO.WOACTIVITY.WORKORDERID <b>=</b> MAXIMO.LONGDESCRIPTION.LDKEY</p>
<p><b>INNER</b> <b>JOIN</b> MAXIMO.LOCATIONS <b>ON</b> MAXIMO.WORKORDER.LOCATION <b>=</b> MAXIMO.LOCATIONS.LOCATION</p>
<p><b>where</b></p>
<p>MAXIMO.WORKORDER.WORKTYPE <b>=</b> 'TOURS'</p>
<p><b>and</b></p>
<p>MAXIMO.WORKORDER.SUBWTYPE <b>=</b> 'T:INSP'</p>
<p><b>and</b></p>
<p>MAXIMO.WORKORDER.BRANCHID <b>=</b> 'PBMO'</p>
<p><b>and</b></p>
<p>MAXIMO.WORKORDER.CREWID <b>=</b> 'PCQA'</p>
<p> </p>
<p><b>and</b></p>
<p>MAXIMO.WORKORDER.ISTASK <b>=</b> '0.00'</p>
<p><b>and</b></p>
<p>MAXIMO.LOCATIONS.SPACECLASS <b>in</b> ('Corridor',' Public Restroom', 'Ramp')</p>
<p><b>and</b></p>
<p>MAXIMO.WORKORDER.JPNUM <b>like</b> '%QA%'</p>
<p><b>and</b> </p>
<p>MAXIMO.LONGDESCRIPTION.LDTEXT <b>=</b> </p>
<p>(<b>CASE</b></p>
<p><b>WHEN</b> MAXIMO.LONGDESCRIPTION.LDTEXT <b>like</b> '%PASS' <b>THEN</b> 'Passed' </p>
<p><b>WHEN</b> MAXIMO.LONGDESCRIPTION.LDTEXT <b>like</b> '%FAIL' <b>THEN</b> 'Failed'</p>
<p> </p>
<p>End)</p>
<p> </p>
<p><b>ORDER</b> <b>BY</b> MAXIMO.WORKORDER.LOCATION</p>
