How to find number of records in each table in M3(cloudsuite)
You you can. See the screenshot below using EXPORTMI.Select
Use the admin tool -> m3 metadata publisher and the exportmi api.
Export mi will not return count. We can't write a query like "count(*) from MITMAS". Also, Export MI returns a max of 9999 records in terms of the result.
With JDBC.
ExportMI is not a solution...
JDBC can also be used to return a count -> select count(*) from MITMAS
This looks good. Once I used it and it didn't work. I believe now there is a solution.
It is working. Thank you, MarkP .
JDBC run's any SQL command compatible with the database in question...
JDBC is ONLY for the Datalake in MT Cloud!
You can also use JDBC in MEC in ST and other versions.....
After You can use Event Publisher or other solutions....
