Loads only 1 record

WEB TMS WEB Core
1

This is My database
image

This is my load procedure
s1 := '?$filter=SpelDatum eq ' + QuotedStr(DateToStr(WebDateTimePicker_LogIN.Date));
s1 := s1 + ' and Bana eq ' + QuotedStr(WebDBComboBox_Bana.Text);

s1 := s1 + '&$top=100'; // ensure more records fetched
WDS_InkaPlayer.QueryString := s1;
whatsNext := C_DoNothing;
WDS_InkaPlayer.Load;

Speldatum = 2025-04-21
Bana = Fågelbro 18

The problem is that when looking in WDS_Player.AfterOpen I only get a recordcount of 1 but it should be 8. It is only the last one that is loaded

2

The dataset simply shows the JS objects parsed from the JSON returned from the server.

Thus, first step is to inspect the response from the server to see what is being returned in JSON. Is it one record, or the expected eight records?

3

I have checked only one record in respons

{
"value": [
{
"$id": 1,
"Dummy": 289,
"Speldatum": "2025-04-24",
"Bana": "Fågelbro 18",
"indianID": 6,
"FirstName": "Alf",
"LastName": "Råberg",
"Slag": 12,
"Boll": 0,
"Lag": null,
"Bortlottad": null,
"NettoSlagISpel": null,
"NettoSlagIBoll": 0,
"BollPlayerAntal": null,
"CheckChar": "b"
}
]
}
and when checking with RecordCound it also show 1 record

4

and it is the last one

5

Then now inspect and debug your server.

One suggestion maybe using the OnSqlExecuting event to check exactly which SQL Aurelius is using to retrieve data, and execute the same SQL manually to confirm you are bringing the same results.

I see you are filtering by date fields, be careful as date fields might have time parts.

6

where do i find OnSqlExecuting

7

Here:

intercepting the SQL code generated by the Aurelius - BIZ / BIZ Feature Requests - TMS Support Center

8

after testing I found out that it is the querystring that probably is the problem

my code
VAR
s1: STRING;
BEGIN
s1 := '?$filter=SpelDatum eq ' + QuotedStr(DateToStr(WebDateTimePicker_LogIN.Date));
s1 := s1 + ' and Bana eq ' + QuotedStr(WebDBComboBox_Bana.Text);
WDS_InkaPlayer.QueryString := s1;
WDS_InkaPlayer.load;

s1 looks like this before load
?$filter=SpelDatum eq '2025-04-24' and Bana eq 'Fågelbro 18'

my database
image

If I use the filter I get only 1 record(the last one)
If I take away the 'querystring' and just do 'Load' I get all 8 records
As You can see I have No time part in Speldatum

9

sorry s1 looks like this
?$filter=SpelDatum eq '2025-04-21' and Bana eq 'Fågelbro 18'

10

Check the SQL statement. There isn't much we can tell from provided information.
It's also always good to percent encode your values:

s1 := '?$filter=SpelDatum eq ' + QuotedStr(DateToStr(WebDateTimePicker_LogIN.Date));
s1 := s1 + ' and Bana eq ' + TBclUtils.PercentEncode(QuotedStr(WebDBComboBox_Bana.Text));