Issue: Data Not Loading in Grid – Kinetic Application Studio

[mohbatrai (Mohbat)]

facing an issue in Epicor Kinetic Application Studio where data is not loading into the grid.

Added the UD01 and UD02 views in Application Studio. Both views contain PO-related data, and the data is available when checked at the database level. However, the grid in Application Studio is not displaying any records.

Could you please review this issue and advise on the possible cause or required configuration changes to resolve it?

Added metafx-panel-card-grid
–>Data -->EpBinding =UD01
Grid Model–> Ep Binding =UD01

and Columns Added

data is not loading and even control not able to click on it

@aarong @Evan_Purdy @GabeFranco @Randy @dr_dan @glopez @Eric_Howell

[Evan_Purdy]

What are you loading the data with, a BAQ, an Epicor function, or a BO?

[mohbatrai (Mohbat)]

The data is loading directly from the UD01 table, and the table contains data. A view has been created based on the UD01 table.

[Evan_Purdy]

That is not how a dataview works, its just a variable to hold data. You have to load it somehow. The guided setup for a dataview can help you connect a BAQ or BO to load the data.

[mohbatrai (Mohbat)]

Alright, understood. Let me proceed with creating the required function.
Thank you.

[aarong (Aaron Gulley)]

What events do you have to pull the data in? Is it on AfterGetByID? RowChange?

The data doesn’t automatically auto populate.

[tpogue (Trudy Pogue)]

Try running the grid guided setup to connect the grid to the dataview. Then enter the BAQ ID in Data > Grid Model > Provider Model.

[ERPRanger (Joe Saville)]

Hi @mohbatrai,
When you set up a Data View in Application Studio using the ‘Data View Guided Setup’, the system automatically creates an event for you. You can then trigger that event however you prefer.

Here’s an example: I’ve configured a Data View that queries the UD01 table and returns the results into a new view (UD01). This event could be triggered in several ways — After Get By ID, After Row Change, etc. but for this demonstration I’ve added a button that retrieves the rows on demand.

Since the UD01 table is quite large in my environment, I’ve applied a filter of Number01 = 180. In your case, you’d more likely filter on something like Key1 = {POHeader.PONum}.

Step 1 creating the View:

Step 2 fill out the necessary options:

Step 3: Application Studio will now have generated two items, your Data View and the event that performs the REST call and populates the Data View based on the parameters you provided.

Now its up to you how this new event is called, here’s an example calling it from a new button:

Finally! map a grid or panel card grid to your view using the ‘Guided Setup’ at the top of the properties pane in application studio when your grid is in selection

Best wishes,

Clear Business Outcome
ERP & process improvement specialists
www.clearbusinessoutcome.com

Putting people and process first to enable business transformation.

[mohbatrai (Mohbat)]

Dear @ERPRanger ,

Thank you very much for this. I will incorporate your logic and update you once it is completed.