ShortChar Field in Work Queue grid

JarSie · August 9, 2019, 3:39pm

Hi,

Does anyone know in which table holds field ShortChar01 from the grid in Work Queue in MES.

Thanks for any help.

Chris_Conn · August 9, 2019, 3:45pm

You should be able to goto Help > Field Help to find out (right click context)

Most likely it’s JobOper

JarSie · August 9, 2019, 3:50pm

Hi Chris,

This is what I have on Field Help

Chris_Conn · August 9, 2019, 3:51pm

That is just a dataset that is created in memory, it is sourced by AvailableWork, so look at the table there.

JarSie · August 9, 2019, 4:08pm

I’m so sorry for my ignorance. Where I should look for Available Work?

Chris_Conn · August 9, 2019, 4:19pm

It’s another tab, but I just looked, it’s also blank. I’m pretty sure these fields are populated from JobOper

A.Baeisa · August 12, 2019, 9:27am

hi @JarSie,
have you checked the Data Tools / Custom Column Like tab, usually all customized view fields are detailed there, for example SetupGroup under AvailableWork tab, is called from JobOper table SetupGroup field, however some displayed fields are -on the fly- (calculated/compared) fields which means it has been used on Epicor Base Custom script when launching this screens like this one ShortChar02 and many other variables and there is no way to know without decompiling the UI DLL file and analyse the code to see how Epicor is getting these values of such displayed fields.

JarSie · August 13, 2019, 1:37pm

Hi,

Thank you very much for such a detailed explanation. In the future I will know where to look for answer for similar questions.

Thanks both of you for help.