I have an application where I am displaying results to a grid. Here is the result of the API call (anonymized due to HIPAA):
{
"@odata.context": "http://localhost:5000/odata/NextGenData/$metadata#SpClaimSearch2s",
"value": [
{
"QUERY_ID": "1642458340894.7651",
"DailyClaimID": 1,
"ERRCD": 1,
"PLNID": "xxxx",
"CARDID": "xxxx ",
"FNAME": "xxxxx ",
"LNAME": "xxxxx",
"InsertTime": "2022-01-14T11:52:40.113Z",
"RXNO": "xxxx",
"FILLDT": "2020-11-17T00:00:00Z",
"PHAID": "ddd",
"PHA_Name": "CITY DRUG STORE ",
"LN": "xxx xx xxxx",
"STATUS": "Paid",
"NDCPROCDT": "2022-01-14T11:52:39.78Z",
"QTY": 30,
"DAYSUP": 30
},
{
"QUERY_ID": "1642458340894.7651",
"DailyClaimID": 4,
"ERRCD": 54,
"PLNID": "xxxx",
"CARDID": "xxx ",
"FNAME": "xxxxx ",
"LNAME": "xxx",
"InsertTime": "2022-01-14T11:52:42.713Z",
"RXNO": "xxxx",
"FILLDT": "2020-11-17T00:00:00Z",
"PHAID": "xxxx",
"PHA_Name": "CITY DRUG STORE ",
"LN": "xx xx 10 MG TABLET",
"STATUS": "Rejected",
"NDCPROCDT": "2022-01-14T11:52:42.7166667Z",
"QTY": 30,
"DAYSUP": 30
},
{
"QUERY_ID": "1642458340894.7651",
"DailyClaimID": null,
"ERRCD": null,
"PLNID": null,
"CARDID": null,
"FNAME": null,
"LNAME": null,
"InsertTime": null,
"RXNO": null,
"FILLDT": null,
"PHAID": null,
"PHA_Name": null,
"LN": null,
"STATUS": null,
"NDCPROCDT": null,
"QTY": null,
"DAYSUP": null
}
]
}
What is being displayed in the grid are the second item, and the third item (the one with all the null values). I'm still working on figuring out why all the null values are even there. But what could be causing the first result to not display in the grid?
Here is my invocation of the api:
Here are my grid properties:
And my results grid:
Note that below the item I've blocked data from, there is a row full of nulls that can be clicked.
Here is what I see in the dev tools for the value of getSpClaimSearchesResult when I break at that line:
0:
CARDID: "10031000 "
DAYSUP: 30
DailyClaimID: 4
ERRCD: 54
FILLDT: "2020-11-17T00:00:00Z"
FNAME: "RUBY "
InsertTime: "2022-01-14T11:52:42.713Z"
LN: "ZOLPIDEM TARTRATE 10 MG TABLET"
LNAME: "MORRIS"
NDCPROCDT: "2022-01-14T11:52:42.7166667Z"
PHAID: "1115321"
PHA_Name: "CITY DRUG STORE "
PLNID: "10031000"
QTY: 30
QUERY_ID: "1642460361126.8455"
RXNO: "000002779163"
STATUS: "Rejected"
[[Prototype]]: Object
1:
CARDID: null
DAYSUP: null
DailyClaimID: null
ERRCD: null
FILLDT: null
FNAME: null
InsertTime: null
LN: null
LNAME: null
NDCPROCDT: null
PHAID: null
PHA_Name: null
PLNID: null
QTY: null
QUERY_ID: "1642460361126.8455"
RXNO: null
STATUS: null
[[Prototype]]: Object
length: 2
[[Prototype]]: Array(0)
Notice that when it assigns the result.value to spGetClaimSearchesResult it skips the first result. A few lines above, where it assigns the ResponseId, there are three items in the array:
value: Array(3)
0:
CARDID: "10031000 "
DAYSUP: 30
DailyClaimID: 1
ERRCD: 1
FILLDT: "2020-11-17T00:00:00Z"
FNAME: "RUBY "
InsertTime: "2022-01-14T11:52:40.113Z"
LN: "ZOLPIDEM TARTRATE 10 MG TABLET"
LNAME: "MORRIS"
NDCPROCDT: "2022-01-14T11:52:39.78Z"
PHAID: "1115321"
PHA_Name: "CITY DRUG STORE "
PLNID: "10031000"
QTY: 30
QUERY_ID: "1642460663899.802"
RXNO: "000002779163"
STATUS: "Paid"
[[Prototype]]: Object
1:
CARDID: "10031000 "
DAYSUP: 30
DailyClaimID: 4
ERRCD: 54
FILLDT: "2020-11-17T00:00:00Z"
FNAME: "RUBY "
InsertTime: "2022-01-14T11:52:42.713Z"
LN: "ZOLPIDEM TARTRATE 10 MG TABLET"
LNAME: "MORRIS"
NDCPROCDT: "2022-01-14T11:52:42.7166667Z"
PHAID: "1115321"
PHA_Name: "CITY DRUG STORE "
PLNID: "10031000"
QTY: 30
QUERY_ID: "1642460663899.802"
RXNO: "000002779163"
STATUS: "Rejected"
[[Prototype]]: Object
2:
CARDID: null
DAYSUP: null
DailyClaimID: null
ERRCD: null
FILLDT: null
FNAME: null
InsertTime: null
LN: null
LNAME: null
NDCPROCDT: null
PHAID: null
PHA_Name: null
PLNID: null
QTY: null
QUERY_ID: "1642460663899.802"
RXNO: null
STATUS: null
[[Prototype]]: Object
length: 3
[[Prototype]]: Array(0)
[[Prototype]]: Object
It seems like after it goes through this line, it strips out the first result:
this.ResponseID = result.value.shift().QUERY_ID;
My question is what could be causing the form to not display the first record, when I can see (above) that the record is being returned to the browser in the Network tab of the browser tools? I didn't write the Radzen application, so I'm looking but not seeing any kind of filtering on the results.