// src/HBM/FooBundle/Controller/BarController.php

  public function indexAction($page, $mode) {

    // ...
    
    $om = $this->container->get('doctrine')->getManager();
    $qb = $om->getRepository('HBMFooBundle:Bar')->createQueryBuilder('b');
    
    $datagridHelper = $this->getDatagridHelper();
    $datagridHelper->setQueryBuilder($qb);
    $datagridHelper->createSimpleDatagrid(
      new Route('name_of_a_route', [ 'page' => $page ]),
      [ 'page' => $page, 'num' => 12 ]
    );
    
    return $this->render('HBMFooBundle:Bar:index.html.twig', [
      'datagrid' => $datagridHelper->paginate(),
    ]);
  }

// src/HBM/FooBundle/Controller/BarController.php

  public function listAction($page, $num, $sort) {
    // DEFAULTS
    $defaults = [
      'page' => 1,
      'num' => 50,
      'sort' => NULL,
    ];

    // DATAGRID
    $datagridHelper = $this->getDatagridHelper();
    $datagridHelper->initDatagrid('name_of_a_route', $defaults, $page, $num, $sort);

    // QUERY BUILDER
    $om = $this->container->get('doctrine')->getManager();
    $qb = $om->getRepository('HBMFooBundle:Bar')->createQueryBuilder('b');
    $datagridHelper->setQueryBuilder($qb);

    // MISC
    $datagridHelper->getDatagrid()->setCells($this->getTableCellsList());

    return $this->render('HBMFooBundle:Bar:list.html.twig', [
      'datagrid' => $datagridHelper->paginate(),
    ]);
  }

// src/HBM/FooBundle/Controller/BarController.php

  public function listAction(Request $request, $page, $num, $sort, $search, $extended) {
    // DEFAULTS
    $defaults = [
      'page' => 1,
      'num' => 50,
      'sort' => NULL,
      'search' => NULL,
      'extended' => NULL,
    ];

    // SEARCH FIELDS
    $searchFields = [
      'value1'  => ['type' => 'text',   'label' => 'Value 1'],
      'value2'  => ['type' => 'number', 'label' => 'Value 2'],
      'value3'  => ['type' => 'text', 'label' => 'Value 3', 'placeholder' => 'Search for ...'],
      'value4'  => ['type' => 'select', 'label' => 'Value 4', 'extended' => 1, 'values' => ['yes' => 'with something', 'no' => 'without something']],
    ];

    // DATAGRID
    $datagridHelper = $this->container->get('hbm.helper.datagrid')
    $datagridHelper->setSession($this->getSession(), 'an_additional_session_prefix:');
    $datagridHelper->initDatagrid('name_of_a_route', $defaults, $page, $num, $sort, $search, $extended);

    // SEARCH
    if ($res = $datagridHelper->handleSearch($request, $searchFields)) return $res;

    // QUERY BUILDER
    $om = $this->container->get('doctrine')->getManager();
    $qb = $om->getRepository('HBMFooBundle:Bar')->createQueryBuilder('b');
        
    $qb = $this->prepareQueryBuilderList($datagridHelper->getSortations(), $datagridHelper->getSearchValues());
    $datagridHelper->setQueryBuilder($qb);

    // MISC
    $datagridHelper->getDatagrid()->setCells($this->getTableCells());
    $datagridHelper->getDatagrid()->getMenu()->setSearchFields($searchFields);

    // EXPORT
    if ($res = $datagridHelper->handleExport($request, 'Orders_'.date('Y-m-d'), $om, $this->getSession()->getFlashBag())) return $res;

    return $this->render('HBMFooBundle:Bar:list.html.twig', [
      'datagrid' => $datagridHelper->paginate(),
    ]);
  }

  protected function prepareQueryBuilderList($sortations, $searchValues) {
    $searchValue1 = [];
    if (isset($searchValues['value1'])) {
      $searchValue1 = array_diff(array_map('trim', explode(' ', $searchValues['value1'])), ['']);
    }
  
    $searchValue2 = [];
    if (isset($searchValues['value2']) && !empty($searchValues['value2'])) {
      $searchValue2 = array_diff(array_map('trim', explode(' ', $searchValues['value2'])), ['']);
    }
  
    $om = $this->container->get('doctrine')->getManager();
    $qb = $om->getRepository('HBMFooBundle:Bar')->search($searchValue1, $searchValue2);
  
    if (isset($searchValues['value3']) && ($searchValues['value3'] === 'yes')) {
      $qb->andWhere('b.fieldXYZ IS NOT NULL');
    } elseif (isset($searchValues['value3']) && ($searchValues['value3'] === 'no')) {
      $qb->andWhere('b.fieldXYZ IS NULL');
    }
  
    // QUERY BUILDER SORT
    if (count($sortations) == 0) {
      $qb->addOrderBy('b.id', 'DESC');
    }
    foreach ($sortations as $key => $value) {
      $qb->addOrderBy($key, $value);
    }
  
    return $qb;
  }

  protected function getTableCells(){
    return [
      // Simple text/numeric value (not sortable).
      new TableCell('field', 'Column 1', NULL, TableCell::VISIBLE_ALL, [
      ]),
      
      // Simple text/numeric value (sortable).
      new TableCell('field', 'Column 2', NULL, TableCell::VISIBLE_EXTENDED, [
        "sort_key" => "g.field",
      ]),

      // Button (with static value)
      new TableCell('field', 'Column 3', new Route('name_of_another_route'), FALSE, [
        'value' => '<i class="fa fa-wrench"></i>',
        'a_attr' => ['class' => 'btn btn-primary btn-xs'],
        'params' => function(Bar $obj) {
          return ['id' => $obj->getId()];
        },
      ]),

      // Button (with dynamic value)
      new TableCell('field', 'Column 4', new Route('name_of_another_route'), TableCell::VISIBLE_NORMAL, [
        'a_attr' => ['class' => 'btn btn-primary btn-xs'],
        'params' => function(Bar $obj) {
          return ['id' => $obj->getId()];
        },
        "sort_key" => "g.id",
      ]),
      
      // Template ( "obj" is always available in the template).
      new TableCell('field', 'Column 5', NULL, TableCell::VISIBLE_BOTH, [
        'template' => 'HBMFooBundle:Bar:table-column-template1.html.twig',
      ]),

      // Template (with additional params).
      new TableCell('field', 'Column 6', NULL, TableCell::VISIBLE_BOTH, [
        'template' => 'HBMFooBundle:Bar:table-column-template1.html.twig',
        'templateParams' => ['mode' => 'thisAndthat'],
        'th_attr' => ['style' => 'width:265px;']
      ]),

      // Value callable.
      new TableCell('field', 'Column 7:<br />Subtitle', NULL, TableCell::VISIBLE_EXTENDED, [
        'value' => function(Bar $obj) {
          return implode(' / ', [$obj->someFunction(), $obj->someOtherFunction()]);
        },
      ]),

      // Value callable with multiple sortation possibilities.
      new TableCell('views', 'Column 8:<br />', NULL, TRUE, [
        'value' => function(Bar $obj) {
          return implode(' / ', [$obj->someFunction(), $obj->someOtherFunction(), $obj->someOtherFunction2()]);
        },
        'sort_key' => ['b.field1' => 'Bla1', 'b.field2' => 'Bla2', 'b.field3' => 'Bla3'],
        'sort_key_sep' => '&nbsp;|&nbsp;'
      ]),
    ];
  }