question

kkhelif avatar image
kkhelif asked

Trigger or Stored procedure

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.

stored-procedurestriggers
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·

This 'workspace for approval' - is that implemented in the SQL database?

0 Likes 0 ·
kkhelif avatar image
kkhelif answered

KEV, Workspace is an adobe AEM web application where admins go to approve these forms

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

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.


0 Likes 0 ·
kkhelif avatar image
kkhelif answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·

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.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.