Sorting issues with listGrid and PHP

20 December, 2007 - 17:15 — janderson

I have a listgrid, which I initially tested with an XML file, and now I'm trying to populate via PHP. It worked great with the XML, but doesn't sort at all from the PHP source.

<b:xhtml>

<p>Recent Supply Orders</p>

</b:xhtml>

<b:listGrid id="recentSupplyGrid" align="center" width="720" height="auto" readonly="true" rowClasses="rowClass1, rowClass2">

        <b:dataSource e:behavior="b:localData" dataType="application/xml">

              <b:dataContainer>

                 <xi:include href="supplies/supply.php?mode=recent" />

              </b:dataContainer>

        </b:dataSource>

        <b:listGridCol select="@po" label="PO Number" width="100px" />

        <b:listGridCol select="@supplier" label="Supplier" width="200px" />

        <b:listGridCol select="@description" label="Description" width="300px" />

        <b:listGridCol select="@order_status" label="Status" width="100px" align="right" />

</b:listGrid>

Is there something I'm overlooking?

remote data sources

21 December, 2007 - 12:00 — timothy

to work with a remote data source e:behavior should be set to b:remoteData

also consider using the url attribute to define the src in place of the b:dataContainer tag i.e.

<b:dataSource e:behavior="b:remoteData" url="supplies/supply.php?mode=recent" dataType="application/xml"/>

remote sorting, paging, CRUD

24 December, 2007 - 15:56 — TedBeer

see the example here: http://bdn.backbase.com/node/4062

Ok, here's my new grid using

27 December, 2007 - 18:23 — janderson

Ok, here's my new grid using the remote method. I'm getting the same problem, the sort arrow highlights, but no sorting occurs.

<b:dataSource name="remote" e:behavior="b:remoteData" dataType="application/xml" url="supplies/supply.php?mode=recent" method="POST" />

<b:listGrid dataSource="remote" id="recentSupplyGrid" align="center" width="720" readonly="true" rowClasses="rowClass1, rowClass2">

        <b:listGridCol select="po" label="PO Number" width="100px" />

        <b:listGridCol select="supplier" label="Supplier" width="200px" />

        <b:listGridCol select="description" label="Description" width="300px" />

        <b:listGridCol select="order_status" label="Status" width="100px" align="right" />

</b:listGrid>

I made an unsort button, like in the example, which does remove the arrow.

Most of the other script in the example doesn't seem to apply to my current situation, as I just want to display data.

Is there anything else I should have to do with the remote data, or should it sort out of box?

Sort parameters to remote dataSource

18 August, 2008 - 15:20 — ghica

To finally answer your question:
You will find sortField and sortDirection as parameters in the request send to the server.
Look for a simple example of how to handle this, in the http://bdn.backbase.com/client/examples/remoteListGrid2
examples page. In essence, the sortField indicates which field to sort on, the sortDirection gives the direction.

Because this is a remote datasource, you must return the right data in the right order with your PHP script.
Only when the data is local on the client, the Backbase client can sort the data for you.

Client Framework