Grid Column datafield naming problem

[stephanParticipant]

Hi,

We discovered a problem with grid columns where the “datatfield” name for the column corresponds to a JAVASCRIPT internal function name. Apparently jqxGrid thinks that the column already exists and complains about a duplicate column.

The following fiddle demonstrates the issue by attempting to create a column named “filter”:
http://jsfiddle.net/_stephan_/uHcF7/

Running the fiddle will not produce a grid. Instead you will find this error in the JAVASCRIPT console: “Error: jqxGrid: Invalid column ‘datafield’ setting. jqxGrid’s columns should be initialized with unique data fields'”

We stumbled across this problem because we auto-genrate a jqxGrid out of a database table and some of our database tables have columns named “filter”.

Regards,
Stephan

[Peter StoevKeymaster]

Hi Stephan,

You can put whatever datafield name you want. The important is to map your data correctly – http://jsfiddle.net/7rgxj/

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[stephanParticipant]

Hi Peter,

Your solution goes along the lines of what we are now testing as a workaround: to append an extra string to the database column name before feeding it into jqxGrid, in order to prevent unsuitable names (we append an underscore). Apparently we can not use whatever name we want because some names appear to be reserved names that cause the grid constructor to fail

As always this is mainly intended to be a heads up for you. It cost us well over an hour to find out why the table suddenly complains about duplicate columns when there are no duplicate columns. So I’m putting the result of that analysis to good use by posting it here.

Regards,
Stephan

[Peter StoevKeymaster]

Hi Stephan,

I think that you misunderstood the solution I sent you. It is not necessary to change your database column, it is necessary to change your datafield name and just specify the correct mapping to your database column.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts