column dataType at runtime | Infragistics Forums

815

column dataType at runtime

Anton Schnider posted over 12 years ago

Hi
If the dataTypes of grid columns are unknown at design time, can they be determined at runtime so that the appropriate column filters are made available on the grid?
Thanks

24671

Alexander Todorov posted over 12 years ago in reply to [Infragistics] Petar Ivanov

Hi Petar,

The grid automatically infers the data types when it auto generates the columns, they are not set to string by default.

Angel
Cancel
Reply

Cancel
49378

[Infragistics] Petar Ivanov posted over 12 years ago in reply to Anton Schnider

Hi ClassicFruitSalad,

Thank you for your reply.

Please feel free to contact me if any questions regarding this scenario arise.
Cancel
Reply

Cancel
815

Offline Anton Schnider posted over 12 years ago in reply to [Infragistics] Petar Ivanov

Hi Petar

Thanks for that. I think we will take this approach…
1. Store the iGrid’s column definitions in the DB i.e. headerText, Key, dataType and format
2. On iGrid Init programmatically build columns: attribute values
Hopefully that should be reasonably straight forward.
Thanks
Cancel
Reply

Cancel
49378

[Infragistics] Petar Ivanov posted over 12 years ago
Hello ClassicFruitSalad,

Thank you for posting in the community.

When columns are autogenerated in the igGrid, their dataType seems to be set to "string" by default. In order to display the desired filters you would need to infer the desired type of the column in some other manner. Note that you should be able to change the dataType of a column if needed, for instance on the rendered stage:

                rendered: function (evt, ui) {
                    $('#grid1').igGrid("option", "columns")[3].dataType = "numeric";
                }

Please feel free to contact me if you have any questions.
Cancel
Reply

Cancel