Extensible Framework - Unable to filter grid

Hi everyone,

I am trying to get records from a grid and filter the grid in Extensible Framework.
I had a more complicated example where I am trying to get information from the parent part while on the manufacturer's tab (using a grid) and that did not work.
So I came up with a more simple example and hopefully someone can point out what I am doing wrong when trying to filter the grid to display only one WO Number (EVT_Code) – the one I’m on.
We are Infor EAM 11.3 Build 201804.

The Grid:
-> Record View tab
Grid ID: 101093
Grid Name: KUTEST
Grid Description: Test WO grid for EF
Grid Type: List View
FROM Clause: r5events
SELECT Clause: EVT_CODE wonumber
WHERE Clause: 1=1
-> Fields tab
Field: EVT_CODE
Alias: wonumber
Field Label: wonumber
Grid Key: checked

NOTE: The Default Dataspy has been created and the grid is active

On the validation tab the Default Dataspy is: select EVT_CODE wonumber FROM r5events WHERE 1=1
And if I run the query in SQL Developer it will give me the following result
10000
100000
100001

The code in Extensible Framework
Ext.define('EAM.custom.external_wsjobs', { extend : 'EAM.custom.AbstractExtensibleFramework',
  getSelectors : function () {
   return {
    '[extensibleFramework] [tabName=HDR][isTabView=true]': {
     afterloaddata: function() {
      console.log('HDR after load data');
      var vFormPanel = EAM.Utils.getCurrentTab().getFormPanel();

      var vWO = vFormPanel.getForm().findField("workordernum");
      var vWOValue = vWO.getValue();
      console.log('vWOValue: ' + vWOValue);
      response = EAM.Ajax.request({
       url: 'GRIDDATA',
       params: {
        GRID_NAME: 'KUTEST',
        REQUEST_TYPE: 'LIST.HEAD_DATA.STORED',
        LOV_ALIAS_NAME_1: 'wonumber',
        LOV_ALIAS_VALUE_1: vWOValue,
        LOV_ALIAS_TYPE_1: 'text'
       },
      async: false,
      method: 'POST'
      });
      var gridresult = response.responseData.pageData.grid.GRIDRESULT.GRID;
      var vCode = gridresult.DATA[0].wonumber;
      var vCode1 = gridresult.DATA[1].wonumber;
      var vCode2 = gridresult.DATA[2].wonumber;
      console.log('vCode: ' + vCode + ' ' + vCode1 + ' ' + vCode2);
     }
    }
   }
  }
});

In Google Chrome, if I press F12 (to look at the Console) no matter what WO I click I see the same result.
The output for "console.log('vCode: ' + vCode + ' ' + vCode1 + ' ' + vCode2);" is: vCode: 10000 100000 100001
Those are the same values from the result set in SQL Developer so obviously the grid is not filtered.

Can someone please point out what I am missing?

BTW If you think there is a better way to get information from the record view while on another tab feel free to share your thoughts.

Find more posts tagged with

UI Design

Accepted answers

Legacy Contributor

Hi Veronique Goulet,

As you mentioned your grid details above i found some issue with the type of grid. If your grid type is List view you can not create parameter in the grid and if you aware about the details mentioned below

LOV_ALIAS_NAME_1: 'wonumber', - filter parameter name – This parameter should be available in Grid fields

LOV_ALIAS_VALUE_1: vWOValue, - filter value – Value on which the column above to be filtered

LOV_ALIAS_TYPE_1: 'text' – datatype of the filter field

this section refer to your parameter tab in the grid thus Make a grid with type "Alert Management" and create parameter same as you mentioned (wonumber) and except :-

var vCode = gridresult.DATA[0].wonumber;

var vCode1 = gridresult.DATA[1].wonumber;

var vCode2 = gridresult.DATA[2].wonumber;

just call array with index 0 once because you want filtered work order number based on value passed in the field or parameter thus no need to use array with one and two index . let me know if it work or not.

Regards,

Manoj Dubey

All comments

Legacy Contributor

HI,
You can use filter in the following way.
vHDR = EAM.Ajax.request({
url: "GRIDDATA",
params: {
USER_FUNCTION_NAME: 'KUTEST',
SYSTEM_FUNCTION_NAME: 'WSJOBS',
CURRENT_TAB_NAME: 'HDR',
MADDON_FILTER_ALIAS_NAME_1: 'wonumber',
MADDON_FILTER_OPERATOR_1: '=',
MADDON_FILTER_JOINER_1: 'AND',
MADDON_FILTER_SEQNUM_1: '1',
MADDON_FILTER_VALUE_1: vWOValue
}
}),
vRows = vHDR.responseData.pageData.grid.GRIDRESULT.GRID.DATA,
vCountRows = vRows.length;

Thanks,
Ravikiran S

0811181026417683.xls

Legacy Contributor

Thanks to everyone who shared their knowledge!

First I tried the solution proposed by Ravikiran.

I was not able to make it work at first so I moved to the solution proposed by Manoj (thinking that if I can at least make one work I would have a starting point to understand both proposed solutions).

This is what ended up working (I will get back to proposed solution one later and post my findings):

The Grid:

-> Record View tab

Grid ID: 101094

Grid Name: KU0001

Grid Description: Test WO grid for EF test 2

Grid Type: Alert Management

FROM Clause: r5events

SELECT Clause: EVT_CODE wonumber

WHERE Clause: evt_status = 'R' and evt_code = :pwonumber

-> Fields tab

Field: EVT_CODE

Alias: wonumber

Field Label: wonumber

Grid Key: checked

-> Parameters tab

Data Type: String

NOTE: In the WHERE Clause I had to add a filter like evt_status = 'R' otherwise I was getting an error on grid save: The Dataspy has violated the performance limit. The Dataspy must have a score below 2500 , but its current score is 8195. Please modify the Dataspy.

On the validation tab the Default Dataspy is: select EVT_CODE wonumber FROM r5events WHERE evt_status = 'R' and evt_code = 'X'

The Default Dataspy is created and the grid is Active

In Screen Extensible Framework:

Name: wsjobs

Screen: WSJOBS

Active: checked

Source:

Ext.define('EAM.custom.external_wsjobs', { extend : 'EAM.custom.AbstractExtensibleFramework',

getSelectors : function () {

return {

'[extensibleFramework] [tabName=HDR][isTabView=true]': {

afterloaddata: function() {

console.log('HDR after load data');

var vFormPanel = EAM.Utils.getCurrentTab().getFormPanel();

var vWO = vFormPanel.getForm().findField("workordernum");

var vWOValue = vWO.getValue();

console.log('vWOValue: ' + vWOValue);

response = EAM.Ajax.request({

url: 'GRIDDATA',

params: {

GRID_NAME: 'KU0001',

REQUEST_TYPE: 'LIST.HEAD_DATA.STORED',

LOV_ALIAS_NAME_1: 'pwonumber',

LOV_ALIAS_VALUE_1: vWOValue,

LOV_ALIAS_TYPE_1: ''

},

async: false,

method: 'POST'

});

var gridresult = response.responseData.pageData.grid.GRIDRESULT.GRID;

var vStr = gridresult.DATA[0].wonumber;

console.log('vStr: ' + vStr);

}

}

}

}

});

NOTE:

LOV_ALIAS_NAME_1: needs the parameter name 'pwonumber'

LOV_ALIAS_VALUE_1: needs the value of the evt_code I am looking for

Copyright © 2025 Infor. All rights reserved.