Clearing App Data (Process Instances, Form Data .. etc)

 
1
0
-1

Sometimes I want to clear all data of an app in the development phase. Here's how I do it:

1. I delete all running and completed processes using "monitor" of the admin bar

2. I clear all form tables using a database management tool

 

Sometimes, I came across this error, and I haven't been able to understand why it happens: Column 'id' in where clause is ambiguous Query

 

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      It turns out that dropping form tables of the app was the problem. I usually drop the tables instead of truncating them when I clear the app

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, do you have some kind of custom SQL or HQL filter condition that you can check? I have not come across such a cross join statement in use before.

          CommentAdd your comment...