Custom Query to search for documents by Author

[Goncalo_Lourenc]

Hi All,

Our users are working with Unity 13 currently. 

I would like to create a custom query so users can search for documents that they uploaded.

It would take their login against db field AUTHOR in between a certain time range.

Is this possible?

Is there any inconvenient as it query directly OnBase DB?

I am aware of transaction logs but that is a solution only for admins so does not work for me.

Thanks for reading.

Regards,

[Goncalo_Lourenc]

Well this is working in the SQL side:
SELECT hsi.itemdata.itemname, hsi.itemdata.itemdate
FROM hsi.itemdata INNER JOIN hsi.useraccount
ON hsi.itemdata.usernum = hsi.useraccount.usernum
WHERE hsi.useraccount.username LIKE 'GONCALO%'
How do I translate this to any user?

[Goncalo_Lourenc]

I tried to give it a go but it seems that there are problems in the horizon:

[Goncalo_Lourenc]

As soon I got confirmation that action would not result in data loss I hit Yes.

But now need to retrieve current user value.

Anyone know how to do it? Or I got into a OnBase blackhole?