SAP FIORI Table filter shows wrong data

[riccardomiggi]

I’m using a Fiori standard table:

<Table id="table" mode="MultiSelect" busyIndicatorDelay="{worklistView>/tableBusyDelay}" growing="false" growingScrollToLoad="false"  noDataText="{worklistView>/tableNoDataText}" updateFinished="onUpdateFinished" width="auto" items="{modello>/LeaveRequestSet}" > <headerToolbar> <Toolbar> <Title id="tableHeader" titleStyle="H6" text="{i18n>worklistTableTitle}"/> <ToolbarSpacer/> <MultiComboBox id="searchUO" showSecondaryValues="true" width="16rem" placeholder="Unità Organizzativa" items="{modello6>/results}" selectionFinish="onSearch"><core:ListItem key="{modello6>Codice}" text="{modello6>Descrizione}"/></MultiComboBox> <MultiComboBox id="searchCID" showSecondaryValues="true" width="15rem" placeholder="Filtro per Dipendente" items="{modelloDipSubordinati>/results}" selectionFinish="onSearch"><core:ListItem key="{modelloDipSubordinati>Pernr}" text="{modelloDipSubordinati>NomeCompleto}"/></MultiComboBox> <MultiComboBox id="searchStato" showSecondaryValues="true" width="10rem" placeholder="Filtro per Stato" items="{modello4>/results}" selectionFinish="onSearch"><core:Item key="{modello4>Codice}" text="{modello4>Descrizione}"/> </MultiComboBox> <Button text="Approva Richiesta" type="Accept" press="onConfermaAccettazione"/><Button text="Rifiuta Richiesta" type="Reject" press="onConfermaRifiuto"/> </Toolbar> </headerToolbar> <columns> <Column id="cc2" width="7rem" hAlign="Center"> <Text id="Stato" text="Stato"/></Column> <Column id="c0" visible="false"><Text id="id" text="{i18n>cName}" /> </Column> <Column id="c1"> <Text id="Name" text="{i18n>cName}" /> </Column> <Column id="c3_b" width="20rem" demandPopin="true" minScreenWidth="Tablet"> <Text text="Unità Organizzativa"/> </Column> <Column id="c3" demandPopin="true" minScreenWidth="Tablet" hAlign="Center"><Text text="Data Richiesta del Giustificativo"/></Column> <Column id="c4" demandPopin="true" minScreenWidth="Tablet" hAlign="Center"><Text text="Data Fruizione Lavoro Agile"/></Column> </columns> <items> <ColumnListItem press="onPress"> <customData> <core:CustomData key="mydata" value="{modello>stato}" writeToDom="true"/> </customData> <cells> <Text text="{modello>DescrStato}"/> <Text text="{modello>RequestId}"/> <Text text="{modello>RequesterName}"/> <Text text="{modello>Uodescr}"/> <Text text="{ path: 'modello>FirstSubmDate', type: 'sap.ui.model.type.Date', formatOptions: { style: 'medium' } }"/> <Text text="{ path: 'modello>StartDate', type: 'sap.ui.model.type.Date', formatOptions: { style: 'medium' } }"/> </cells> </ColumnListItem> </items> </Table>

Binded with an oData model type V2 named “modello”

In the component

var oModelListaRichieste = this.getOwnerComponent().getModel("ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV");oModelListaRichieste.setUseBatch(false);oView.setModel(oModelListaRichieste, "modello");

On the first load the data are OK

If I apply a filter for example for Employee: RICHIEDENTETRE SMARTWORKING corresponding at the 3 items in the box.

The code to filter is

 var selectedStati = this.byId("searchStato").getSelectedItems(); var selectedUO = this.byId("searchUO").getSelectedItems(); var selectedCID = this.byId("searchCID").getSelectedItems(); for (var i = 0; i < selectedStati.length; i++) { var filter = new Filter("Stato", FilterOperator.EQ, selectedStati[i].getKey()); aTableSearchState.push(filter); } for (i = 0; i < selectedUO.length; i++) { filter = new Filter("Uo", FilterOperator.EQ, selectedUO[i].getKey()); aTableSearchState.push(filter); } for (i = 0; i < selectedCID.length; i++) { filter = new Filter("RequesterNumber", FilterOperator.EQ, selectedCID[i].getKey()); aTableSearchState.push(filter); } aTableSearchState.push(new Filter("StartDate", FilterOperator.EQ, _startDate)); aTableSearchState.push(new Filter("EndDate", FilterOperator.EQ, _endDate)); //oTable.getBinding("items").filter(aTableSearchState, "Application"); oTable.getBinding("items").filter(aTableSearchState, FilterType.Application);

I have as result form the backend the correct data:

{ "d": { "results": [ { "__metadata": { "id": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBDA2E049F1D533DB',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-09-06T00%3A00%3A00',EndDate=datetime'2021-09-06T21%3A00%3A00')","uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBDA2E049F1D533DB',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-09-06T00%3A00%3A00',EndDate=datetime'2021-09-06T21%3A00%3A00')", "type": "ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV.LeaveRequest" }, "Pernr": "00030667", "RequestId": "0050569A52421EDBBDA2E049F1D533DB", "ApproverName": "", "Uo": "50023857", "ApproverNumber": "00000000", "Uodescr": "CDG SI Prog e Instal Impianti e Sistemi", "RequesterName": "RICHIEDENTETRE SMARTWORK", "Stato": "02", "DescrStato": "Approvata","RequesterNumber": "00030667", "FirstSubmDate": "/Date(1628035200000)/", "FirstSubmTime": "", "InfoType": "2002", "LeaveType": "P058", "LeaveTypeDesc": "Lavoro Agile", "StartDate": "/Date(1630886400000)/", "EndDate": "/Date(1630962000000)/", "BeginTime": "", "EndTime": "", "AbsenceHours": "0.00", "AllDayFlag": false, "AbsenceDays": "0.00", "CalendarDays": "0.00", "Deduction": "0.00000", "Note": "", "Version": 0, "StatusCode": "", "StatusName": "", "ChangeDate": null, "ChangeTime": "", "ChangePersName": "", "FilterGetAllRequests": "", "LeaveRequestType": 0, "Overlaps": 0, "OverlapList": "", "NotesCounter": 0, "TaskDefinitionID": "", "CurrentBalance": "0.00000", "CurrentBalanceTimeUnit": "", "CurrentBalTimeUnitCode": "", "CurrentBalanceWarning": "", "CalculateOverlaps": "", "WorkitemID": "000000000000", "AttachmentsCounter": 0, "Fileattachments": "", "ActionCode": "", "ActionText": "", "TeamCalendar": { "__deferred": { "uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBDA2E049F1D533DB',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-09-06T00%3A00%3A00',EndDate=datetime'2021-09-06T21%3A00%3A00')/TeamCalendar" } }, "LeaveRequestFileAttachment": { "__deferred": { "uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBDA2E049F1D533DB',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-09-06T00%3A00%3A00',EndDate=datetime'2021-09-06T21%3A00%3A00')/LeaveRequestFileAttachment" } } }, { "__metadata": { "id": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBC8EFF2D6F1E9302',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-05T00%3A00%3A00',EndDate=datetime'2021-08-05T21%3A00%3A00')","uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBC8EFF2D6F1E9302',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-05T00%3A00%3A00',EndDate=datetime'2021-08-05T21%3A00%3A00')", "type": "ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV.LeaveRequest" }, "Pernr": "00030667", "RequestId": "0050569A52421EDBBC8EFF2D6F1E9302", "ApproverName": "", "Uo": "50023857", "ApproverNumber": "00000000", "Uodescr": "CDG SI Prog e Instal Impianti e Sistemi", "RequesterName": "RICHIEDENTETRE SMARTWORK", "Stato": "02", "DescrStato": "Approvata","RequesterNumber": "00030667", "FirstSubmDate": "/Date(1628035200000)/", "FirstSubmTime": "", "InfoType": "2002", "LeaveType": "P058", "LeaveTypeDesc": "Lavoro Agile", "StartDate": "/Date(1628121600000)/", "EndDate": "/Date(1628197200000)/", "BeginTime": "", "EndTime": "", "AbsenceHours": "0.00", "AllDayFlag": false, "AbsenceDays": "0.00", "CalendarDays": "0.00", "Deduction": "0.00000", "Note": "", "Version": 0, "StatusCode": "", "StatusName": "", "ChangeDate": null, "ChangeTime": "", "ChangePersName": "", "FilterGetAllRequests": "", "LeaveRequestType": 0, "Overlaps": 0, "OverlapList": "", "NotesCounter": 0, "TaskDefinitionID": "", "CurrentBalance": "0.00000", "CurrentBalanceTimeUnit": "", "CurrentBalTimeUnitCode": "", "CurrentBalanceWarning": "", "CalculateOverlaps": "", "WorkitemID": "000000000000", "AttachmentsCounter": 0, "Fileattachments": "", "ActionCode": "", "ActionText": "", "TeamCalendar": { "__deferred": { "uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBC8EFF2D6F1E9302',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-05T00%3A00%3A00',EndDate=datetime'2021-08-05T21%3A00%3A00')/TeamCalendar" } }, "LeaveRequestFileAttachment": { "__deferred": { "uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBC8EFF2D6F1E9302',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-05T00%3A00%3A00',EndDate=datetime'2021-08-05T21%3A00%3A00')/LeaveRequestFileAttachment" } } }, { "__metadata": { "id": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBD87D980FF1DA050',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-04T00%3A00%3A00',EndDate=datetime'2021-08-04T21%3A00%3A00')","uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBD87D980FF1DA050',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-04T00%3A00%3A00',EndDate=datetime'2021-08-04T21%3A00%3A00')", "type": "ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV.LeaveRequest" }, "Pernr": "00030667", "RequestId": "0050569A52421EDBBD87D980FF1DA050", "ApproverName": "ApprovatoreSM Richieste SM", "Uo": "50023857", "ApproverNumber": "00026096", "Uodescr": "CDG SI Prog e Instal Impianti e Sistemi", "RequesterName": "RICHIEDENTETRE SMARTWORK", "Stato": "01", "DescrStato": "Da Approvare (Ritiro)","RequesterNumber": "00030667", "FirstSubmDate": "/Date(1627948800000)/", "FirstSubmTime": "114013", "InfoType": "2002", "LeaveType": "P058", "LeaveTypeDesc": "Lavoro Agile Ordinario", "StartDate": "/Date(1628035200000)/", "EndDate": "/Date(1628110800000)/", "BeginTime": "000000", "EndTime": "000000", "AbsenceHours": "7.20", "AllDayFlag": true, "AbsenceDays": "1.00", "CalendarDays": "1.00", "Deduction": "0.00000", "Note": "::NEW::00021631::::APPROVATOREUNO SMARTW::::SMWOAPP::::20210804::::132550::::CET", "Version": 2, "StatusCode": "SENT", "StatusName": "Inviato", "ChangeDate": "/Date(1628035200000)/", "ChangeTime": "132550", "ChangePersName": "", "FilterGetAllRequests": "", "LeaveRequestType": 3, "Overlaps": 0, "OverlapList": "", "NotesCounter": 1, "TaskDefinitionID": "", "CurrentBalance": "8.00000", "CurrentBalanceTimeUnit": "Giorni", "CurrentBalTimeUnitCode": "010", "CurrentBalanceWarning": "", "CalculateOverlaps": "X", "WorkitemID": "000000000000", "AttachmentsCounter": 0, "Fileattachments": "", "ActionCode": "", "ActionText": "", "TeamCalendar": { "__deferred": { "uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBD87D980FF1DA050',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-04T00%3A00%3A00',EndDate=datetime'2021-08-04T21%3A00%3A00')/TeamCalendar" } }, "LeaveRequestFileAttachment": { "__deferred": { "uri": "https://ess-svil.stradeanas.it/sap/opu/odata/sap/ZHCM_LAVORO_AGILE_REQ_APPROVE_SRV/LeaveRequestSet(RequestId='0050569A52421EDBBD87D980FF1DA050',RequesterName='RICHIEDENTETRE%20SMARTWORK',RequesterNumber='00030667',StartDate=datetime'2021-08-04T00%3A00%3A00',EndDate=datetime'2021-08-04T21%3A00%3A00')/LeaveRequestFileAttachment" } } } ] }}

But in the table wrong data shown:

But the number of entries correspond exactly with the Odata Response.