Automate

 View Only
  • 1.  Solution Data Library Use

    Posted 24 days ago

    Hello,

    I am wondering if its possible to utilize the solution data library within the workflow.  Here is my example of what I'm trying to accomplish.

    User submits Request A and the workflow logs the information in the Solution Data Library with the 'Update Solution Data' plugin and then the workflow proceeds with approvals for the SAP Routing Values.  User submits Requests B and because this request will also need to utilize the routing that is setup at the end of Request A, this request would go into a Loop that has a wait plugin of 24 hrs and checks the Solution Data Library each day to see if Request A is complete.  When Request A is removed from the Solution Data Library then Request B would exit the loop and proceed with direct creation (material assignments).

    I have not seen a way to reference the values in the Solution Data Library once its in the workflow and how to recheck this.  Any suggestions?



    ------------------------------
    Jamie Eberhart
    Sr Technical Data Analyst
    DS Technology Hub LLC
    MI
    ------------------------------


  • 2.  RE: Solution Data Library Use

    Posted 24 days ago

    As far as i understand, Solution Data Library is for non-structured data (files).

    I think it would be much easier and more reliable to use a supporting database for such mechanism. And then use data connection to read data from SQL database in workflow (using Set Form Data plugin and GetExternalConnection) to apply this wait logic.

    We have implemented something similar - we are waiting for user to complete required training (data coming from external system into database) before assigning security roles.



    ------------------------------
    Alexey Skotnikov
    GPO, Data Governance
    ABBOTT RAPID DX INTERNATIONAL LIMITED
    ------------------------------



  • 3.  RE: Solution Data Library Use

    Employee
    Posted 23 days ago
    Edited by Sigrid Kok 23 days ago
      |   view attached

    Hi Jamie

    You can get and update repeating data in an RDL (Reference Data List).  I have an example attached with the RDL I used and the solution which did a GET and SAVE.  Note save will overwrite, so you can both add and update.

    Import the RDL and create field mapping - reusing the fields from both get and save (if you only need save that is fine)

    copy the fields to the form and use a web service control to choose the RDL action and a button (or whatever you want) to do the save (or get).  Please see the documentation here:  https://help.precisely.com/r/Automate-Evolve/Latest/en-US/Automate-Evolve-User-Guide/Solution-Developer-Help/Reference-Data 

    You can also do this in SQL - I have a post on this: https://community.precisely.com/discussion/update-sql-table-records-via-evolve-form-workflow

    If you are doing parent child, there are places in a workflow plug to share both repeating and non-repeating data - please see the documentation:  https://help.precisely.com/r/Automate-Evolve/Latest/en-US/Automate-Evolve-User-Guide/References/Form-Process-Launch-Plug-in?section=plugins-form-process-launch

    Hope this gives you some ideas,

    Sigrid



    ------------------------------
    Sigrid Kok
    *Precisely Software Inc.
    ------------------------------

    Attachment(s)

    zip
    SKRDL-SolutionAndRDL.zip   30 KB 1 version


  • 4.  RE: Solution Data Library Use

    Employee
    Posted 23 days ago

    PS:  You can also run these "web services" on a Reference Data List through a workflow plugin - Automate Update

    FYI

    Sigrid



    ------------------------------
    Sigrid Kok
    *Precisely Software Inc.
    ------------------------------