Hey guys,
We have a .Net core application that was written to replace an ADOBE AEM Application and one of the requirements is to add the form automatically to the Database after let say 15 days of not being approved. How can we achieve such a requirement through SQL.
Form gets submitted and goes to workspace for approval - after 15 days it should get added to the database automatically.
Thanks
Your help is appreciated.
This 'workspace for approval' - is that implemented in the SQL database?
KEV, Workspace is an adobe AEM web application where admins go to approve these forms
Your going to have to give more information about Workspace & this database. Is Workspace hooked up to the database? Is there any middleware.
If Workspace cannot see the database, then how will it know that there is something for the database to process. Your going to have to put in a piece of middleware to extract things from Workspace which pass the 15 day mark and then insert that into the database.
Adobe AEM has a SQL back end and Workspace is aware of the form when it gets submitted by the counties. An initial submission goes to workspace to be processed and upon approval or denial it goes to the DB. So in the case where the forms are sitting in Workspace for awhile without being looked at, should insert to the DB automatically after number of days mark.
So whatever technology is behind Workspace, is where you need to implement this workflow. If that is outside of SQL, then nothing in SQL (trigger, SP, Job) can make this happen.
15 People are following this question.
