Followup fix for: Unable to invoke getForms after adding FormField to

dkayiwa · dkayiwa · commit b25df4b81f2b · 2014-02-17T12:31:08.000+03:00
containingAnyFormField - TRUNK-4189
diff --git a/api/src/main/java/org/openmrs/api/db/hibernate/HibernateFormDAO.java b/api/src/main/java/org/openmrs/api/db/hibernate/HibernateFormDAO.java
@@ -446,7 +446,7 @@ private Criteria getFormCriteria(String partialName, Boolean published, Collecti
 			subquery.add(Restrictions.eqProperty("ff.form", "form"));
 			subquery.add(Restrictions.in("ff.formFieldId", anyFormFieldIds));
 			
-			crit.add(Subqueries.gt(0L, subquery));
+			crit.add(Subqueries.lt(0L, subquery));
 		}
 		
 		//select * from form where len(containingallformfields) = (select count(*) from form_field ff where ff.form_id = form_id and form_field_id in (containingallformfields);

Original file line number	Diff line number	Diff line change
`@@ -446,7 +446,7 @@ private Criteria getFormCriteria(String partialName, Boolean published, Collecti`
`446`	`446`	`subquery.add(Restrictions.eqProperty("ff.form", "form"));`
`447`	`447`	`subquery.add(Restrictions.in("ff.formFieldId", anyFormFieldIds));`
`448`	`448`
`449`		`- crit.add(Subqueries.gt(0L, subquery));`
	`449`	`+ crit.add(Subqueries.lt(0L, subquery));`
`450`	`450`	`}`
`451`	`451`
`452`	`452`	`//select * from form where len(containingallformfields) = (select count(*) from form_field ff where ff.form_id = form_id and form_field_id in (containingallformfields);`