Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    13.0p summariesJoin sample does not concat correctly

    Hi Isomorphic,

    please see the modified summariesJoin sample (v13.0p_2022-04-14):

    This is what it looks like after a restart of the sample after editing the orderitems so that the 1st order has 2 items.
    The count column in the top ListGrid is OK, but the description column only shows one Description (not two as expected) and also only in the 1st row, not in all rows, although the .ds.xml says:
    Code:
    <field name="items" type="text"
                   includeFrom="aggregationJoin_orderItem.itemDescription" includeSummaryFunction="concat" />
    Click image for larger version

Name:	summariesJoin.png
Views:	125
Size:	37.3 KB
ID:	267885

    Best regards
    Blama


    Code:
    isc.ListGrid.create({
        ID: "orderList",
        dataSource: "aggregationJoin_order",
        width: 720,
        height: 300,
        showFilterEditor: true,
        alternateRecordStyles: true,
        autoFetchData: true,
        canEdit: true,
        canRemoveRecords: true,
        wrapHeaderTitles: true,
        wrapCells: true,
        sortField: "orderID",
        cellHeight: 40,
        headerSpans: [{
            fields: ["itemCount", "items"],
            title: "Items"
        }],
        headerHeight: 65,
        fields: [
            { name: "orderID", width: 90, title: "orderID"},
            { name: "orderDate", width: 100, title: "Date" },
            { name: "customerName", width: 180, title: "Customer" },
            { name: "itemCount", width: 80, title: "Count" },
            { name: "items", width: "*", title: "Description" }
        ]
    });
    isc.ListGrid.create({
        ID: "orderItemList",
        dataSource: "aggregationJoin_orderItem",
        width: 720,
        height: 300,
        top: 310,
        showFilterEditor: true,
        alternateRecordStyles: true,
        autoFetchData: true,
        canEdit: true,
        sortField: "orderID",
        canRemoveRecords: true,
        fields: [
            { name: "pk", width: 90, title: "PK", hidden:true},
            { name: "orderID", width: 100, title: "orderID", canEdit:true},
            { name: "itemDescription", width: 80, title: "Item description" },
            { name: "quantity", width: "*", title: "Quantity" },
            { name: "unitPrice", width: "*", title: "Unit price" }
        ]
    });

    #2
    Hi Isomorphic,

    looking at the Developer Console's RPC Tab this seems to be a serverside problem, as the expected data is not in the response.
    Also, the clientOnly-DS version of the sample seems to be OK.

    Best regards
    Blama

    Comment


      #3
      This is a regression caused by recent changes, which is fixed now. Thank you for the report.

      Comment


        #4
        Hi Isomorphic,

        I can see the display is fixed now using v13.0p_2022-04-18, but editing does not work, see also here.

        Out of interest, what was the issue here? I can't imagine a SQL that would come up with such a result like in the screenshot in #1.

        Best regards
        Blama

        Comment

        Working...
        X