Application Studio. Performing a lookup using two different fields from two different tables

Kinetic ERP
1

Good day, Gentlefolk of EpiUsers! I have been killing myself over the best way to perform a lookup. The point of this post is to establish a high-level strategy regarding best practice.

I would like to lookup the part description based on a PartNum that is hand entered by the user. The catch is that Part # in the screen shot is actually UD20_ShortChar01.

image
image312×110 1.57 KB

DataView.UD20_ShortChar01 is part #

DataView.Part_PartDescription is part description

We are migrating an Epicor classic customization into application studio. The dataview already has data populated. But we want the user to be able to change the UD20_ShortChar01 (PartNum) and have Part Description auto populate with the description. Has anyone done this before?

I am considering two strategies:

  1. Creating a second dataview containing part data and using UD20_ShortChar01 (PartNum) to filter the dataview

  2. Using UD20_ShortChar01 (PartNum) to hit the PartSvc GetById API call and auto populating from there.

Has anyone done this before? Does my question make sense? Thank you in advance.

2

it sounds like you want an event,
in the event:
kinetic-rest: Part.GetRows or Part.GetByID where Part.PartNum = {DataView.UD20_ShortChar01}, pull that into DataView2
row-update: DataView.Part_PartDescription = {DataView2.PartDescription}

2 Likes
3

I am experimenting with the Rest API Part.GetByID. The Kinetic Rest widget is robust.