ianreeves

GOT 2000 MES Function

2 posts in this topic

Hi, Does anyone have much experience with the MES function on the GT2000 series HMI's I'm no expert but we can get the unit to connect to our server, but I would like to run what would be a fairly normal SQL Query. This is the actual Query I need to run... SELECT A.Operation, A.Material, CASE WHEN (B.[skill Level] IS NOTNULL) THEN B.[skill Level] ELSE 0 END AS 'Skill' FROM rvxCurrentMaterials A LEFT OUTER JOINrvxCurrentMaterialsWithEmpSkills B ON A.Item = B.Item AND A.Operation = B.Operation AND A.Material = B.Material AND B.[Employee ID] ='user' AND B.[skill Status] ='Pending' WHERE A.Operation IN ( SELECT Operation FROM rvxCurrentMaterials WHERE Item = 'PARTXYZ' AND Material = 'RIGID' ) AND A.Item Obviously the items in Red will be variables based on my criteria. Just wondered if any one had any experience of using it. Cheers Ian

Share this post


Link to post
Share on other sites
I have no experience with the GOT MES function, only the MES-IT module. However, do you have succesful connection to your DB? Or maybe you've solved it already?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now