Maximo Open Forum

 View Only

 Filter field is not working

  • Customizations
Axel Alamilla's profile image
Axel Alamilla posted 10-03-2024 18:34

Hi, I have problems with automatization. I created a dialogue in the LIBRARY.xml to show a view of different tables. Here the user can multi-select rows and after this selection is added to the inventory usage application in invuselines. The problem is that the filter field is not working; it only shows as if it has been deactivated (in grey). 

The following is the dialogue code on LIBRARY.xml.

<dialog beanclass="psdi.webclient.system.beans.MultiselectDataBean" id="selecttoolsoninvuse" label="Seleccionar herramientas" datasrc="MAINRECORD">
		<table id="selecttoolsoninvuse_select_table" label="Herramientas" selectmode="multiple" relationship="CCNPINVBALCUSTOMTOOLS">
			<tablebody displayrowsperpage="15" filterable="true" id="selecttoolsoninvuse_select_table_tablebody" inputmode="readonly">
				<tablecol filterable="false" hidden="false" id="selecttoolsoninvuse_select_table_tablebody_1" mxevent="toggleselectrow" sortable="false" type="event"/>
				<tablecol dataattribute="itemnum" id="selecttoolsoninvuse_select_table_tablebody_2"/>
				<tablecol dataattribute="description" id="selecttoolsoninvuse_select_table_tablebody_3"/>
				<tablecol dataattribute="location" id = "selecttoolsoninvuse_select_table_tablebody_4"/>
				<tablecol dataattribute="siteid" id = "selecttoolsoninvuse_select_table_tablebody_5"/>
				<tablecol dataattribute="curbal" id = "selecttoolsoninvuse_select_table_tablebody_6"/>
				<tablecol dataattribute="assetnum" id="selecttoolsoninvuse_select_table_tablebody_7"/>
				<tablecol dataattribute="personid" id = "selecttoolsoninvuse_select_table_tablebody_8"/>
			</tablebody>
		</table>
		<buttongroup id="selecttoolsoninvuse_2">
			<pushbutton default="true" id="selecttoolsoninvuse_2_1" label="Aceptar" mxevent="COPYINVBALANCESTOINVUSE"/>
			<pushbutton id="selecttoolsoninvuse_2_2" label="Cancelar" mxevent="dialogcancel"/>
		</buttongroup>
	</dialog>

In the inventory usage application, the dialogue shows like this (filter field deactivated):

Can please someone tell me if I missed writing something on the code or what is going on?

Note: This same view is used in other dialogues and works properly.

Steven Shull's profile image
Steven Shull posted 10-04-2024 08:35

Without more details, my assumption is that the relationship CCNPINVBALCUSTOMTOOLS points to a non-persistent object. Non-persistent objects don't exist in the database and thus can't be filtered. When a user filters in Maximo it executes the search against the database directly. When you filter itemnum=1001 for example, that changes the query to select * from tablename where itemnum='1001';.

Related Content