IDM XQuery how to get documents created by current user

Hi all, In the widgets "IDM Documents" or "IDM Document Monitor", is it possible to only show the documents that were created by the user logged in in Infor/M3? Basically looking for a parameter to use for the "Created By" parameter.

Kind regards, Erik

Find more posts tagged with

Infor Document Management (IDM)

Accepted answers

All comments

Brandon Watson

Have you tried the XQuery of "/ICR_MyDocuments"? This will show created and modified by the user.

Erik van der Vlugt

Hi Brandon, thank you, that sort of works but not quite what I am trying to achieve:

This: /ICR_MyDocuments SORTBY(@LASTCHANGEDTS DESCENDING)

works fine and shows me my documents, newest (changed) first.

What I'd like to do is combine that with a document type. So something like:

/M3_OrderConfirmation[@LASTCHANGEDTS >= date(0)] SORTBY(@LASTCHANGEDTS DESCENDING)

but for the user executing the query. Any clue how to get this done?

Gr, Erik

Aaron Roma

Not sure if there's a way to do what your wanting (show docs of a specific type created by current user) with existing widgets. Could be done via API, but would require you to create a custom widget. Using APIs, you could retrieve the ID of the current user, then use that ID in an IDM search API to retrieve the list of documents you wanted.

Christiaan Rentier

Some examples of the syntax that can be used for the Xquery:

@RESOURCENAME LIKE "Picture%" OR @ITEMID = "38" OR @CREATETS <= 2021-02-20

/Item_Image[@RESOURCENAME LIKE "Picture%"] UNION /Item_Image[@ITEMID = "38" ] UNION /Item_Image[@CREATETS <= 2021-02-20]

/ICR_RecentlyModified SORTBY(@LASTCHANGEDTS DESCENDING)

/Item_Image[@Item_Name LIKE "%a%"] SORTBY(@Item_Name DESCENDING)

@displayName LIKE "%Code"

/Images[@Image_Type = "Item" AND @Image_Status = "40"] SORTBY(@CREATETS DESCENDING)

Copyright © 2025 Infor. All rights reserved.