Grid row count

[gwilburn]

I have a grid that displays 9 rows, but the bottom of the grid reports "Displaying 1 - 10 of 10".

2023-07-25 13_32_31-Valence 6.2.png

[Johnny Major]

If you refresh the grid and then check the Errors application, do you see any errors?

[gwilburn]

No errors in the Errors application... the network response to the VVCALL is odd ( I removed name and address lines from data):

There are 9 addresses in the DSROOT array

{
"metaData": {
"totalProperty": "totalCount",
"root": "DSROOT",
"id": "readerDSROOT",
"fields": [
{
"name": "MFG_ID"
},
{
"name": "COM_NBR"
},
{
"name": "MFG_NAME"
},
{
"name": "VND_CUST"
},
{
"name": "BF_CUST"
},
{
"name": "AG_ID"
},
{
"name": "ORDER_ID"
},
{
"name": "BILL_NAME"
},
{
"name": "BILL_ADR1"
},
{
"name": "BILL_ADR2"
},
{
"name": "BILL_CITY"
},
{
"name": "BILL_ST"
},
{
"name": "BILL_ZIP"
},
{
"name": "BILL_PHN"
},
{
"name": "BILL_FAX"
}
]
},
"DSROOT": [
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "3659",
"AG_ID": "R-BIZ",
"ORDER_ID": "-846945711",


"BILL_CITY": "Oakley",
"BILL_ST": "CA",
"BILL_ZIP": "94561",
"BILL_PHN": "415-751-5767",
"BILL_FAX": "415-751-4287"
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "1372476429",
"AG_ID": "R-BIZ",
"ORDER_ID": "558543114",

"BILL_CITY": "Benicia",
"BILL_ST": "CA",
"BILL_ZIP": "94510",
"BILL_PHN": "925-443-1244",
"BILL_FAX": ""
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "4331",
"AG_ID": "R-BIZ",
"ORDER_ID": "-726559297",

"BILL_CITY": "Los Gatos",
"BILL_ST": "CA",
"BILL_ZIP": "95032-",
"BILL_PHN": "",
"BILL_FAX": "408-356-6220"
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "1434053290",
"AG_ID": "R-BIZ",
"ORDER_ID": "582528285",

"BILL_CITY": "Dana Point",
"BILL_ST": "CA",
"BILL_ZIP": "92629",
"BILL_PHN": "949-673-1646",
"BILL_FAX": ""
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "4264",
"AG_ID": "R-BIZ",
"ORDER_ID": "1675038030",

"BILL_CITY": "",
"BILL_ST": "CA",
"BILL_ZIP": "93412",
"BILL_PHN": "805-547-1733",
"BILL_FAX": "805-547-1723"
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "4228",
"AG_ID": "R-BIZ",
"ORDER_ID": "-1422833245",

"BILL_CITY": "Corona Del Mar",
"BILL_ST": "CA",
"BILL_ZIP": "92625-",
"BILL_PHN": "949-489-9202",
"BILL_FAX": ""
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "659610098",
"AG_ID": "R-BIZ",
"ORDER_ID": "2114688253",

"BILL_CITY": "Melrose",
"BILL_ST": "MN",
"BILL_ZIP": "56352",
"BILL_PHN": "320-256-8655",
"BILL_FAX": ""
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "3045",
"AG_ID": "R-BIZ",
"ORDER_ID": "-950864823",

"BILL_CITY": "Big Sur",
"BILL_ST": "CA",
"BILL_ZIP": "93920-",
"BILL_PHN": "831-667-2347",
"BILL_FAX": ""
},
{
"MFG_ID": "DAMLL",
"COM_NBR": "053",
"MFG_NAME": "DAM LLC",
"VND_CUST": "",
"BF_CUST": "3045",
"AG_ID": "R-BIZ",
"ORDER_ID": "1275848734",

"BILL_CITY": "Big Sur",
"BILL_ST": "CA",
"BILL_ZIP": "93920-",
"BILL_PHN": "831-667-2347",
"BILL_FAX": ""
}
],
"totalCount": 10
}

[robert.swanson]

Hi Greg,

Looking into this one for the next build... Could you paste your data source SQL statement?

[gwilburn]

SELECT
mfg_id,
substr(rfdta, 21, 3) AS com_nbr,
substr(rfdta, 1, 20) AS mfg_name,
vnd_cust,
ag_id,
bf_cust,
trim(ag_id) || bf_cust AS cust_id,
order_id,
bill_name,
bill_adr1,
bill_adr2,
bill_city,
bill_st,
bill_zip,
bill_phn,
bill_fax
FROM
bfordrs
LEFT JOIN referrf ON rfcat = '7074' and rfsq2 = 1 and rfslc = mfg_id
WHERE
(ast_com# = ' ')
GROUP BY
mfg_id,
rfdta,
vnd_cust,
ag_id,
bf_cust,
trim(ag_id) || bf_cust,
order_id,
bill_name,
bill_adr1,
bill_adr2,
bill_city,
bill_st,
bill_zip,
bill_phn,
bill_fax

[robert.swanson]

Okay thanks, I was hoping to see a Group By clause in there... I believe we have this issue resolved for the next build. If you need a patch in the meantime please send an email to support and we'll set it up for you.