Using save, restore Grid State

Question

Hello all,

Is it possible to provide with a sample application that uses the API functions 'getgridstate' and 'setgridstate' ,the new feature of Formspider 1.4.0.

Thanks

Suranga

Accepted Answer

0	Hi Suranga, Yes, we will prepare examples for both locked columns and grid state soon. link answered 21 Jun '13, 06:49 Yalim Gerger ♦♦ 1.8k●5 accept rate: 15% Thanks Yalim, (21 Jun '13, 06:57) suranga

Answer 2

0

Hi Suranga,

Here is the URL for the tutorial:

http://theformspider.com/learningcenter/tutorial-47-how-to-save-restore-grid-state/

link

answered 22 Jun '13, 07:47

Yalim ♦♦
2.8k●5
accept rate: 22%

Hello Yalim,

The answer given here depends on session variables. I would like to know if it's possible to keep the state of the grid even after the user logs off from the application. Thus, when the users logs in again the data grid can be loaded to the previous state.

Thanks

Suranga

(24 Jun '13, 06:54) suranga

Hi Suranga, Yes of course. Just save the state information to a table along with a user id and you are done. I didn't do the example with a table to keep it simple. In hindsight, maybe I should tell at the end that the same logic can be replicated with a table.

(24 Jun '13, 07:00) Yalim ♦♦

Hello Yalim,

The example works fine. But, it seems to mix the order of the columns when the state is restored. Could you please tell me the reason for this.

Thanks

Suranga

(25 Jun '13, 09:59) suranga

The columns stays out of order unless column lock is set.

(25 Jun '13, 10:06) suranga

We cannot replicate this problem here in the sample application explained in the tutorial. Could you tell us the steps to reproduce it?

(25 Jun '13, 10:10) Yalim Gerger ♦♦

Hello Yalim,

Can you try by increasing the number of columns such as check boxes. I'm doing the exact same procedure as mentioned in the example.

Thanks

Suranga

(25 Jun '13, 13:14) suranga

Hi Suranga, can you put design xml of your Grid here?

(25 Jun '13, 13:16) oskansavli ♦♦

We replicated the problem and opened a ticked on our issue tracking system. It will be fixed on next minor release (v1.4.1) of Formspider.

(26 Jun '13, 04:40) oskansavli ♦♦

showing 5 of 8 show 3 more comments

Answer 3

 <grid name="grid_vw_ps_sdst3" dataSource="VW_PS_SDST3VW1" enableColumnResize="Y" enableColumnMove="Y" enableColumnSort="Y" enableColumnFilter="Y" enableColumnFunctions="Y" enableColumnHide="Y" enableColumnLock="Y">
      <column headerLabel="Selection">
        <checkBox column="CHECKED_YN">
          <events>
            <valueChanged action="SDST3RowMarked"/>
          </events>
        </checkBox>
      </column>
      <column headerLabel="LagerPlatz">
        <textField name="LagerPlatz" column="PS_LGPLATZ_KOORDINATE"/>
      </column>
      <column headerLabel="SE">
        <checkBox column="PS_LGPLATZ_SPERR_EINL_KNZ" checkedValue="1" uncheckedValue="0"/>
      </column>
      <column headerLabel="SA">
        <checkBox column="PS_LGPLATZ_SPERR_AUSL_KNZ" checkedValue="1" uncheckedValue="0"/>
      </column>
      <column headerLabel="Platz-Stat">
        <textField column="PS_LGPLATZ_STATUS"/>
      </column>
      <column headerLabel="Larger Zone">
        <textField column="PS_LGZ_ZONE"/>
      </column>
      <column headerLabel="HOEHE CM">
        <textField column="PS_LGPLATZ_HOEHE_CM"/>
      </column>
      <column headerLabel="M ANZ Paletten">
        <textField column="PS_LGPLATZ_MAX_ANZ_LHM"/>
      </column>
      <column headerLabel="Pl-str P">
        <textField column="PS_LGPLATZ_STRUKTUR_POS"/>
      </column>
      <column headerLabel="Pl-str L">
        <textField column="PS_LGPLATZ_STRUKTUR_LAENGE"/>
      </column>
      <column headerLabel="Pl-str S" visible="N">
        <textField column="PS_LGPLATZ_STRUKTUR_STATUS"/>
      </column>
      <column headerLabel="PRÜEFZIFFER" visible="N">
        <textField column="PS_LGPLATZ_PRUEFZIFFER"/>
      </column>
      <column headerLabel="GASSE" visible="N">
        <textField column="PS_LGPLATZ_GASSE"/>
      </column>
      <column headerLabel="ABC KL" visible="N">
        <textField column="PS_LGPLATZ_ABC_KLASSE"/>
      </column>
      <column headerLabel="M GEW KG" visible="N">
        <textField column="PS_LGPLATZ_MAX_GEWICHT_KG"/>
      </column>
      <column headerLabel="BSW ZUORD" visible="N">
        <checkBox column="BSW_ZUORDNUNG_KNZ" checkedValue="1" uncheckedValue="0"/>
      </column>
      <column headerLabel="HOEHE_CM" visible="N">
        <textField column="PS_LGPLATZ_HUB_HOEHE_CM"/>
      </column>
      <column headerLabel="Kommissionier-Lauf-Nr" visible="N">
        <textField column="PS_LGPLATZ_KOMM_ORDER"/>
      </column>
      <column headerLabel="SKQ K" visible="N">
        <checkBox column="PS_TOUR_KUERZEL" checkedValue="1" uncheckedValue="0"/>
      </column>
      <column headerLabel="SKB K" visible="N">
        <checkBox column="PS_TOUR_BEZ" checkedValue="1" uncheckedValue="0"/>
      </column>
  </grid>

Using save, restore Grid State

Follow this question

Related questions