Application Studio - Reorder Grid Columns - Help Needed

[dgreenEA (Dylan Green)]

Following the conversation had here:

Use textbox to filter a baq, kinetic dashboard

When you debug in the browser (Ctrl + Alt + 8), you can hit Ctrl + Alt + V to dump the data in all the data views - then you can see what the value of your TransView.Search value is - and confirm that it’s getting set and not getting cleared, etc It also helps to look at the Network tab and see what your ExecuteBAQ calls look like - to confirm that your where clause is getting set (or not)

I have made a dashboard that uses textboxes to filter a grid.

I have an issue where I cannot get the columns in the order I want.

First I tied putting the columns in the order I want them in the BAQ. Then I tried using the view options listed here:

Can you Hide Column in Grid based on View ( Dashboard)?

Good Morning All, Still working through migrations to Kinetic from Classic Dashboards. I took 1 dashboard and deployed it to an App. In Classic, this had 2 views on 1 of the grids. It seems to have converted ok, I get the 2 views above the grid but they are both displaying all of the columns. I cant seem to find a way to 'Hide" a column. Just for simplicity sake, this is the setup for the Dashboard( in Classic) BAQ 0 is the source for the “master” grid. BAQ 1 is the source for Grid 1 BA…

This makes it so no records show in the grid, but I still see data in the dataview. I also tried using the grid model columns and the provider model columns sections. This made it so that there is no data within the dataviews and the top section of the grid is grayed out.

Can someone please point me in the right direction on this?

[NateS (Nate Schoonover)]

The only thing that has worked consistently for me is to change the column order in the live form and then save layouts. I would love it if we could customize the column order properly from App studio!

[dcamlin (David Camlin)]

You should be able to drag/drop them in the grid WHILE IN APP STUDIO. Save. Preview.

Original

Drag them over in App Studio

Preview:

Also, once you drag them over in App Studio, you can reopen the Grid Model > Columns and you’ll see they’re now listed in the new order:

[Randy (Randy Stulce)]

What @dcamlin said but also you can use the Personalize columns from the grid menu and order the columns (hide them too) then save layouts.

[dcamlin (David Camlin)]

@Randy

you can use the Personalize columns from the grid menu

again… IN APP STUDIO.

[dgreenEA (Dylan Green)]

@dcamlin @NateS @Randy

Thank you all for the quick responses!

I went in and tried to use these options, but I didn’t see them available to me.

This is what my grid looks like within Application Studio. Its data is linked in the provider model panel like so:

The text box filters are applied as BAQ options under the where clause. When I look at the columns section listed within the provider model, it is blank. If I add columns to it, none of the data is put into the DataView, and I get ‘No records found.’

Is there a better way to do this? Or is there an option I’m not seeing here?

[Randy (Randy Stulce)]

Is your dataview setup correctly? I ask because your grid says, “No records available” which I haven’t seen.

[dgreenEA (Dylan Green)]

I believe it is. When I run the preview everything comes in as I would expect:

Here is what the setup for the data view looks like:

Let me know if I’m missing a set somewhere.

[dcamlin (David Camlin)]

My thoughts…

I’m assuming on your Grid Model properties, you have the “Auto Load Columns” checked.

OR… the Auto Load Grid in Provider Model:

I’m thinking that’s the case because your dataview has columns, you see them when you preview… but they’re not displaying IN app studio.

My recommendation is to uncheck that box and add them in the Grid Model columns. I know there is a “Columns” area in Provider Model as well… but to be honest, I don’t think I’ve ever used that one. Even when I do a BAQ in the provider model, I add my columns in the Grid Model.

[Randy (Randy Stulce)]

Perhaps re-run the grid’s guided setup so the grid will show in the designer?

[dgreenEA (Dylan Green)]

@dcamlin @Randy

It appears to be a little of column a and column b on my end.

Those checkboxes were checked, but after I unchecked them, nothing happened. Even signed out and back in to see if it was something in cache.

After I went in and did the Guided Setup, everything flowed through. I can reorder my columns as intended.

Thanks for the help, everyone!

[TDudek (Timothy Dudek)]

Everything in the Application Studio can be a little buggy, especially if you’re still in 2024.2 like I am. I’ve had a few instances where I unhide a column, shows up in the studio, commit/publish it, and it’s back to being hidden after I logout/log back in and launch the application and reopen Application Studio. Other times, I have no issue.

Kinetic tools seem to be very temperamental without rhyme or reason.