App Store Widget: Data Grid Extension 2.4 (Inline Buttons, Flex headers, row Styling, Dynamic Paging buttons, Conditional visibly buttons, step trough)

32
This forum topic it to give feedback on the app store widget 'Data Grid Extension' created By Flock of Birds. The Mendix Data Grid Extention, Give the end user more flexibility how a grid should show data by giving to option to hide and move columns and allow them store there settings including column with and sort order. Please log any new issues at the GitHub issue tracker: https://github.com/Andries-Smit/DataGridExtention/issues New Features are added: Inline buttons in your data grid; have buttons in your data grid Content based Table Row Styling, FINALLY you can change the color of a row bases on a enumeration or boolean value of a object Control bar Button Visibility based on selection and data in table, Allows you to hide the buttons you can not use. Updates: Columns visibility can be changed with submenu. (On request of Mitchel Mol and Ronald Catersels ) Able to show columns that where hidden by the modeler can now made visible (set width 0) in modeler ( On Request of Herbert Vuijk) Hide first last paging button when there are less then (n) pages. Keep you GUI clean, so no more buttons than you really need No more Cookies! Flex header uses Html local storage. Cookie storage is limited and they are always send a request. Added Check if the configuration is valid. This feature is depending on Mendix 5.2 and up and will not work in older versions. Demo video, screen cast (version 1) Source code with demo Test project En please be kind to test and review the code and contribute on the source code or give feedback in this forum topic.
asked
17 answers
4

Updated the widget at Git Hub, submission in app store soon:

  • Added dynamic show off paging buttons, only show paging buttons when there are more pages
  • Added Empty table grid functions, plus fixes for Mx5
  • Display empty table messages as text (instead of a button)
  • Hide headers when table is empty.
answered
4

Update 2.1 in the app store Added:

  • Stepping trough data grid with a button (next previous selection)
  • Enable data grid extension to work on reference set selector too.
  • Can hide / show grid buttons when a grid is empty or not with the classes "hideOnEmpty" or "showOnEmpty" Empty table header can be hidden without showing a empty date grid button/link/msg.

Bug Fixes:

  • Support multiple widget instances on one page.
  • When paging is hidden in modeller and dynamic hiding is enabled resulted in an error

Tested with Mx 5.3

answered
3

Hi Andries,

An other idea for a much requested feature that would be a great addition to your widget.. Add an click event on a column that requests a microflow with the clicked object.

This makes it possible to trigger action directly form a row (like edit, duplicate row, order, e.t.c.)

answered
3

Hi Herbert,

On request I added new feature to the Data Grid Extension. Buttons inside grids (see also test project)

The update is placed in GitHub Data Grid Extension, (Click Raw) File be uploaded available in the appstore when Mendix fixes the broken file upload. (Ticket 101639)

Release notes Version 2.4

  • Added inline buttons; Allowing to add buttons into you grid cells
  • Tested with Mx 5.5
answered
1

Andries,

We tried using the conditional coloring of a datagrid, but we're using a non-persistant entity which is not allowed. What's the reason for this limitation, and is there any way to circumvent this?

Thanks!

answered
1

Hi Paul,

The update is placed in GitHub Data Grid Extenson, (Click Raw) File be uploaded available in the appstore when Mendix fixes the broken file upload. (Ticket 101639)

Release notes Version 2.3

  • When paging is hidden in modeller and dynamic hiding is enabled resulted in an error empty table header can be hidden without showing a button.
  • FIXED Mx5.4 Grid buttons where no working well; Mx renamed eventGridRowClicked to eventItemClicked in data grid.
  • Handler refresh of grid buttons on double click
  • When conditional visibility is set via the modeller the dg Extension overwrites, this should not happen.
  • Error configuration feedback in UI
  • Support Non Persistable Entities in Row Class Mapping.
answered
1

After updated from 5.9 to 5.11 the buttons for next row doesn't work anymore. The cursor jumps to the next row of the grid but after that it jumps directly to the first row.

Yes the option "Select first" = Yes. But it was also the situation in 5.9

answered
0

Andries, we use your widget in our project(s). But we encountered one thing:

Setup

  • Datagrid with property: Show Paging Buttons: No
  • Widget with: Hide unused Paging: Yes.

This causes an infinite loop while loading the page with the widget on it.

Workaround is to disable one of these settings. However, would be nice if the widget didn't hang because of this.

answered
0

I am trying to implement this widget and I am not having any luck, how does one implement this widget?

I have 1 entity (this is all just created for testing on how this widget works.) 1 data-grid.

That menu that is shown on the video, does it need to be created manually?

Any help will be appreciated.

answered
0

Hi Charl,

Please check the test project on github (note that this is version 2.1, in the appstore had v2.0) https://github.com/Andries-Smit/DataGridExtention/blob/master/Test/TestProject_DataGridExtension.mpk

In the widget you need to enable the feature you like to have: In the tab 'Header' the option 'Flex Header' (When true, columns can Moved, store sort order and hidden. Can not be used in combination with responsive Columns)

answered
0

Andries,

Maybe I looked in the wrong place, but I noticed v2.1 isn't available yet?

answered
0

Thanks Andries,

Some really nice features, and a must-have widget for any project if you ask me! Keep up the good work!

answered
0

Hi Andries,

Thanks again for this amazing widget. It should be part of the Mendix standard framework to make it a bit easier to configure.

Anyway, I have a little problem. Probably a CSS issue, but maybe you have some ideas. When right clicking on a column header, the dropdown I get my browser menu and the menu from the widget is loaded some where in de middle of the screen.

What can be done about this? alt text

answered
0

@Shruthi Rao, please ask a questions in a new 'answer' not in a 'comment' to keep the thread clean .

Shruthi Rao: This widget works well. To achieve control bar button visibility, I am not getting where to use showOnRowSelect and how to use it. Could you please help me out?

Andries Smit: please update your widget from gid hub, it has probably a fix for your issue.

Shruthi Rao: It worked!! Thanks! Shruthi Rao: But, even after updating the widget its not working in popup. For popups is there any extra config needed?

Andries Smit: no, there is no extra setting needed. It should work, but have not tested it with a popup. Please create an issue on github. https://github.com/Andries-Smit/DataGridExtention/issues

Tested in the sample project. And pop-up seems to work. Make sure you have the widget in the popup as well (placed correctly in a table in the cell below the datagrid)

answered
0

Hi - we are experimenting with this widget and it looks great so far. Is there anyway of displaying the 'Columns' menu option on a button click rather than as part of a menu. This is the list of columns to show/hide - would be great to get this as a separate feature rather than having to click through to a sub menu?

Thanks again - great work.

Cheers

Adrian

answered
0

Hi Andries,

Thank you for this great widget! I use it for every datagrid I implement. I 'm trying to set the background color for a table row when an boolean attribute in the row is true. So I set the grid entity the same as the entity of the above datagrid and select my boolean attribute. In the Class Mapping I set the key to true and I set the CSS Class.

  <tr class="mx-name-index-1" data-id="291" tabindex="1"><td data-id="292" class="mx-name-column4 mx-right-aligned" title="1001">

Now I can't find the CSS class on the row when I try to find it in the browser through 'inspect element'. Do I do something wrong? Or is Mendix version 5.13.1 not supported?

Thank in advance

Gerard

answered
0

Hi Andries,

We're having trouble with the widget (without context) in Mendix version 5.15.1. It gives the error 'error in create widget:TypeError: Cannot read property 'undefined' of undefined' when used in a new test project. When used in an existing project, the error is slightly different: 'error in create widget:TypeError: Cannot read property 'declaredClass' of undefined'.

Any thoughts on possible causes of this error?

PS: I've also tried the widget in a new test project in Mx 6.1.0, but that results in the entire application not rendering in the browser once the widget is added to a page (all pages are blank).

Screenhost in 5.15.1 test project:

alt text

answered