Announcement

Collapse
No announcement yet.

Filter a grid the first time is opened

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Filter a grid the first time is opened

    Hello:
    I have a grid that starts with a search and displays the grid in a iframe, the initial state is yes.
    The search field is a date, which initialize with date ('Y-m-d'). (see de image)

    How I can filter the grid with the initial value of the search the first time I open the page, or how I can, using code, "press" Search button the first time the page is open?

    Regards

    ----------------------------------
    Hola:
    Tengo una grid que inicia con un search y despliega la grid en un iframe, el estado inicial es yes. El campo de busqueda es una fecha, la cual la inicializo con date('Y-m-d'). (ver la imagen)
    ¿Cómo puedo filtrar la grid con el valor inicial del search la primera vez que abro la pagina, es decir, como puedo, mediante código, "oprimir" el boton Search la primera vez que se abre la pagina?

    Saludos
    Attached Files

  • #2
    Hey, nice Ubuntu Unity there!

    Well... The first question is "How is defined the filter initial value?", this answer may give us a way to define the WHERE clause of the grid with the values used as default for the filter.

    The where Clause would look like this:

    SELECT
    field,
    something
    FROM
    table
    WHERE
    [ricks_var]


    Then we global variable would be filled with the where clause based on the filter fields or with "1 = 1" to not filter registers.
    http://www.frameworkphp.net/php/wp-c.../11/Ubarsc.jpg

    Comment


    • #3
      Thank you Henriqueb, I put WHERE Fecha = CURDATE() and solved my problem

      Regards

      Comment


      • #4
        Sorry it did not work, it is true that shows me today's date but when I want to filter out other conditions given priority to WHERE Date = CURDATE () :-(

        Comment


        • #5
          Anyone can help on this ? I'm stuck here as well. Thanks.

          Comment


          • #6
            Me too - my exact question is - How can I initialize the SEARCH criteria on a grid search with today's date, so that it shows today's values only, BUT can later be changed using the search button to show any date desired?

            I do not think using the where works here, because then the search criteria in the search box does not override the where clause... am I right?

            Thanks,
            Jamie

            Comment

            Working...
            X