Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>When the server side is the one setting the id, the workflow is this:</p> <ul> <li>Record added to the store without an id being assigned.</li> <li>Store syncs, so a Create request is being sent to the server.</li> <li>Server returns the sent record, with an id property set.</li> <li>ExtJS looks at the returned record and if it has an id set, it assignes it to the record.</li> </ul> <p>Notice, by the way, that for all CRUD operations, the store record will be updated with the data returned from the server so long the id matches. In the case of newly created records, ExtJS has an internalId mechanism to determine that the record returned is the one sent, but with its id set.</p> <p>The server side code might look something like this:</p> <pre><code>function Create( $aRecord ) { global $pdo; $iInsertClause = InsertClause::FromFields( self::$persistents ); $iStatement = $pdo-&gt;prepare( "INSERT INTO Tags $iInsertClause" ); $iStatement-&gt;execute( InsertClause::ObjectToParams( $aRecord, self::$persistents ) ); // Inject the id into the record and return it in the reader's root, // so client side record updates with the new id. $aRecord-&gt;id = $pdo-&gt;lastInsertId(); return array( 'success' =&gt; true, 'data' =&gt; $aRecord, ); } </code></pre> <p>Then within your app, your controller should hook on store write events. Something like this:</p> <pre><code>init: function() { this.getTasksStore().on({ write: this.onStoreWrite, scope: this }); }, </code></pre> <p>And within that function you can inspect the returned record (I assume <code>data</code> is the reader's root):</p> <pre><code>onStoreWrite: function ( aStore, aOperation ) { var iRecord = aOperation.response.result.data; console.log(iRecord.id); }, </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POIn ExtJs, how do I get an id after syncing a record to the store?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIzhaki
    1. USIzhaki
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIn ExtJs, how do I get an id after syncing a record to the store?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHello again :) I think I was unclear in my question, so I've updated it to clarify. The server is correctly returning the newly create id, but how do, on the client side, retrieve that newly created id?
      singulars
      1. PO
      1. USJames McMahon
    2. COThat's happens automatically, given a few things are satisfied. Could you perhaps provide the request sent to the server and the server response. I take it you haven't played with idProperty, and that the id field is `id`.
      singulars
      1. PO
      1. USIzhaki
    3. COHold on a second. Did you means something like aRecord.get("id")? You can listen to store write events and inspect `aOperation.response.result`
      singulars
      1. PO
      1. USIzhaki
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload