Using EXPORTMI in M3 Metadata Publisher

elden-fenison

I am looking for some help on using a Select transaction. It's working for me but I need examples of the correct syntax of the QERY string.

jamie-forrester

Hey,

Here's an example for querying OOHEAD (Order Header) to retrieve all orders of a specific Order Type:
* from OOHEAD where ORTP = '165'

The only caveat that I'm aware of, is that when you're looking for specific column names, you need to use the table prefix. You can see what this is by checking MDP or just doing a select * from [TABLE], and looking at the two letter code that precedes the usual field names.

For the case of OOHEAD, if I only wanted the Order Number and the Type, I'd say:

OAORNO, OAORTP from OOHEAD where ORTP = '165'

You do not need to explicitly say the word "Select". That is presumed.

You cannot do Order By queries either.

You should also be able to access some more information about it here:

docs.infor.com/.../default.html