set-workflow-stage problem

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

set-workflow-stage problem

meimeilu
Hi Alex:

        I have a new problem again.

        The version is 2020.1.2, I'm testing  workflow features.
        Reference:
https://blog.orbeon.com/2021/01/new-workflow-capabilities-in-orbeon.html
<https://blog.orbeon.com/2021/01/new-workflow-capabilities-in-orbeon.html>  
        "1.Employees start to fill an expense report, and submit it, at
which point the stage becomes submitted."
        "2.Managers can review expense reports with a submitted stage, and
use the Approve button to change the stage to approved, or the Reject button
to change the stage to rejected.
        "3.If rejected, the employee can edit the form, submit it again,
which changes the stage back to submitted."
       
        The first step is ok,the stage becomes "submitted" by the button ,
the button have set-workflow-stage() action, then I save/submit the form
data,then I enter the summary page, but when I open the   form data again,
the stage is null.
        I'm sure the stage becomes "submitted" because I added a control in
the form to display the value of the stage by fr:workflow-stage-value()
function,when I click the button the control value becomes "submitted",when
I open it again, the control value is null.
        This is my problem.
 
        So I  read the  document carefully,
https://doc.orbeon.com/release-notes/orbeon-forms-2020.1#workflow
<https://doc.orbeon.com/release-notes/orbeon-forms-2020.1#workflow>    
I see "The concept of stage is introduced at the database level ",  so I
guess it's because the database I'm using is eXist, so I started deploying
the PostgreSQL database, but I don't see the 2020.1.2 version of DDL in
https://doc.orbeon.com/form-runner/persistence/relational-db#postgresql-database-setup
<https://doc.orbeon.com/form-runner/persistence/relational-db#postgresql-database-setup>  
         This is another question.
       
Regards
Meimei

--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1616054186003-0.post%40n4.nabble.com.
Reply | Threaded
Open this post in threaded view
|

Re: set-workflow-stage problem

Alessandro  Vernet
Administrator
Hi Meimei,


meimeilu wrote
> I see "The concept of stage is introduced at the database level ",  so I
> guess it's because the database I'm using is eXist, so I started deploying
> the PostgreSQL database, but I don't see the 2020.1.2 version of DDL in
> https://doc.orbeon.com/form-runner/persistence/relational-db#postgresql-database-setup

You are correct, for the stage feature to work, you need to be using a
relational database. I updated the release notes to make that clearer. At
some point, we should also switch to using an embedded relational database,
as most new features are only developed for relational databases.

For the DDL, you need to use `postgresql-2019_1.sql`, as that DDL hasn't
changed since version 2019.1.

-Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1616473413830-0.post%40n4.nabble.com.
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: set-workflow-stage problem

Alessandro  Vernet
Administrator
Hi Meimei,

I also added a +1 on RFE #3321, which would solve the issue of those
features, like support for stage, which are not supported out of the box and
require you to set up a relational database.

https://github.com/orbeon/orbeon-forms/issues/3321

-Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1616541910373-0.post%40n4.nabble.com.
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: set-workflow-stage problem

meimeilu
In reply to this post by Alessandro Vernet
Hi Alex

        Thank you for your reply.I solved it.

Regards
Meimei

--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1616988802798-0.post%40n4.nabble.com.
Reply | Threaded
Open this post in threaded view
|

Re: set-workflow-stage problem

Alessandro  Vernet
Administrator
Perfect, and thank you for confirming the stage works for you.

-Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/1617037010901-0.post%40n4.nabble.com.
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet