How to identify the last modification date of each table for a given DIVI ?

Hello,

I would like to know how, in a Cloud M3 environment, it would be possible to identify the last modification date of each table for a given DIVI?

Thank you for your suggestions.

Regards

Find more posts tagged with

SELECT one line (TOP 1 *) order by DESC timestamp field (LMTS)

Hi Antonio,

Thank you for your help.7

I am not familiar wih SQL request in an M3 Context.

What do you use as tool in a Cloud Environement to execute your request ?

I only have access to the API ExportMI.

Do you think that it could be achieved by this channel ?

Regards

with EXPORT.Select is not possible because You cannot use "order by".

QUERY:

SELECT TOP 1 XXLMTS FROM <TABLE>

WHERE XXCONO = ? AND XXDIVI = ?

ORDER BY XXCONO,XXDIVO,XXLMTS DESC

Sorry but with which tool are you running this query on a cloud environment?