Answers

• allan Posts: 63,552Questions: 1Answers: 10,476 Site admin

  October 2017

  What code are you using to populate the list of options for the select list?

  Allan
• rompeplatos Posts: 20Questions: 4Answers: 0

  October 2017

  in server:

  <?php
  
  // DataTables PHP library
  include( "php/DataTables.php" );
  
  // Alias Editor classes so they are easy to use
  use DataTables\Editor,
      DataTables\Editor\Field,
      DataTables\Editor\Format,
      DataTables\Editor\Mjoin,
      DataTables\Editor\Options,
      DataTables\Editor\Upload,
      DataTables\Editor\Validate;
  
  /*
   * Example PHP implementation used for the joinSelf.html example - the basic idea
   * here is that the join performed is simply to get extra information about the
   * 'manager' (in this case, the name of the manager). To alter the manager for
   * a user, you would change the 'manager' value in the 'users' table, so the
   * information from the join is read-only.
   */
  
  $id = $_GET["id"];
  
  Editor::inst( $db, 'program' )
      ->field(
          Field::inst( 'program.id' ),
          Field::inst( 'program.text' ),
          Field::inst( 'program.id_sala' )
              ->options( Options::inst()
                  ->table( 'sala' )
                  ->value( 'id' )
                  ->label( 'text' )
              ),
          Field::inst( 'sala.text' )
  
       )
      ->leftJoin( 'sala', 'sala.id', '=', 'program.id_sala' )
      ->where( 'sala.id_congress', $id ) //this not work
      ->process($_POST)
      ->json();
  
  

  js:

   editor = new $.fn.dataTable.Editor({
              ajax: "server.php?id=3",
              table: "#table",
              fields: [{
                          label: "Text:",
                          name: "program.text"
                      },{
                          label: "Nombre Sala:",
                          name: "program.id_sala",
                          type: "select",
                          placeholder: "Select sala"
                      }    
          });
  
• allan Posts: 63,552Questions: 1Answers: 10,476 Site admin

  October 2017 Answer ✓

  Move your where condition into the Options instance's chain - e.g.:

  Options::inst()
    ->table( 'sala' )
    ->value( 'id' )
    ->label( 'text' )
    ->where( function ($q) use ($id) {
      $q->where( 'sala.id_congress', $id )
    } )
  

  Note that I've wrapped it in a function. The Options->where() method accepts a function that provides access to the underlying query object. Some more information about that is available here.

  Allan
• rompeplatos Posts: 20Questions: 4Answers: 0

  October 2017

  It´s work fine!
  Thank very much!