Does any one have a good SQL query or BAQ that will show if the wrong plant method (Ops/Resources) are on a Job? If not what are the best table to pull for this info.
thanks kim
Does any one have a good SQL query or BAQ that will show if the wrong plant method (Ops/Resources) are on a Job? If not what are the best table to pull for this info.
thanks kim
I’m not sure about E9, but in E10, there is the ability to show info about a field on a form.
put the cursor in the form’s field, then choose Technical Details in the Field Help pane.
Here is a simple BAQ I use to list ResourceGrps, Resources and Capabilities.
I’m not sure how you’ll determine which plant your resource resides.