Question & Answer > View Question

Confluence User - 01 Nov, 2018

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

sql-error;apps

Confluence User •

02 Nov, 2018 •

confluenceUser •

•

confluenceUser •

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.

Confluence User •

19 Jan, 2019 •

confluenceUser •

1 •

confluenceUser •

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

1