Where clause for condition node in workflow for definition related records in not final status

For TICKET:

(select count(1) from ticket where origrecordid = :ticketid and origrecordclass = :class and status not in ('CLOSED', 'RESOLVED')) = 0
and
(select count(1) from workorder where origrecordid = :ticketid and origrecordclass = :class and status not in ('CLOSE', 'REJECTED', 'CAN', 'FAILPIR', 'COMP', 'FAIL', 'REVIEW')) = 0

For WORKORDER:

(select count(1) from ticket where origrecordid = :wonum and origrecordclass = :class and status not in ('CLOSED', 'RESOLVED')) = 0
and
(select count(1) from workorder where origrecordid = :wonum and origrecordclass = :class and status not in ('CLOSE', 'REJECTED', 'CAN', 'FAILPIR', 'COMP', 'FAIL', 'REVIEW')) = 0

SQL query for searching responsible person group for classification looking from bottom level to top level classification tree

If you want to define common responsible person group for all child classification elements hierarchy from top to down element, by defining responsible person group only for one top classification element, you can use the following sql query to define relationship for the object (e.g. TICKET, WORKORDER etc., all objects which has classstructureid attrribute) with persongroup object.

SQL Query for classification description updating

If you want update description of classification, you have to update field "description" in two tables. Example:

update classstructure set description = 'Description' where classificationid = 'IT010303'
update classification set description = 'Description' where classificationid = 'IT010303'

Maximo Jars for Maximo Java Development

1. maximo\lib\*.jar
2. maximo\lib\j2ee.jar
Extracted from maximo.ear:
3. businessobjects.jar
4. maximouiweb.war\WEB-INF\classes (zipped to maximouiweb.jar)

Simple Excel VBA macros for swapping two rows

Sub SwapRanges()
  Dim ra As Range: Set ra = Selection
  msg1 = "You have to select TWO ranges of cells of the same size"
  msg2 = "You have to select 2 ranges of cells of the SAME size"
  If ra.Areas.Count <> 2 Then MsgBox msg1, vbCritical,"Error":Exit Sub
  If ra.Areas(1).Count <> ra.Areas(2).Count Then MsgBox msg2, vbCritical,"Error":Exit Sub
  Application.ScreenUpdating = False
  arr2 = ra.Areas(2).Value
  ra.Areas(2).Value = ra.Areas(1).Value
  ra.Areas(1).Value = arr2
End Sub

p.s.
And not only rows. You can swap any 2 equal areas:

How to use VBA macros:

Hide the Search panel on the Start center in IBM Control Desk 7.5.3, 7.5.1.2

If you want to hide Search panel on Start center and make expanded by default "Go To Application" menu in IBM Control Desk 7.5.3, 7.5.1.2, you have to do the following steps:

1. Go To > System Configuration > Application Designer
2. Select Action > Export System XML

How to hide the additional search panel in the applications

If you want to hide this new panel, which have been appeared in the latest versions of SmartCloud Control Desk 7.5.3 (7.5.1.2), you have to change System property
mxe.webclient.searchMenubar from 1 to 0.

Before changing:

and the result will be next: