Search by greater than and less than in Date fields in Maximo / ICD

Pinned
Publish Date
Tags
configuration
Status
Completed
Sometimes its better to search date fields in Maximo by greater than or less than. The user typically dont want to insert > or < in search fields. There is a simple way to achieve this. In <tablecol/> add the an attribute name prepend
For greater than or equal to, just add prepend=">="
For less than or equal to add prepend="<="
For example
  1. Export the application's xml.
  1. E.g If your date field is REPORTDATE. Add prepend in it like below to search all dates less than or equal to the searched term
<tablecol dataattribute="reportdate" prepend="<=" id="se5" label="Report Date" lookup="datelookup" />
This will show all records who are less than or equal to selected value.