The use case i am trying to implement is :-
- There is an external oracle database containing archived documents, which Joget users might want to upload them during a workflow.
- this external database is not part of the Joget workflow database.
- what i need to do is during certain workflow activity to allow the users to retrieve all the archived documents from the database that have the "creator_name" column = the login user. The sql statement should be something similar to "select data from document where creator_name = #requestor.username#."
But me question is how i can implement the above use case and where i should write the sql to retrieve the related documents?
Best Regards