Menu

Source Commit Log


Commit Date  
[r6324] by tutasrinivas

Updated JUnit Tests with TestCases to test the enhancement to support aggregates within atomic criteria. Following TestCases are added and updated Wrapper class to create dataset for new Testcases

1. testAtomicInnerJoinQuery
2. testNestedAtomicInnerJoinQuery
3. testTwoAtomicInnerJoinQuery

2012-08-26 20:41:32 Tree
[r6323] by tutasrinivas

Enhanced to support aggregates within atomic criteria. A query such as follows now can be built with the sample code below.

SELECT ITEMS.* FROM ITEMS,PARTS T1,CONDITIONS T2 WHERE (((((ITEMS.PART LIKE 'ZP1%') OR (ITEMS.SEGREGATION_CODE LIKE 'ZC1%')) AND T1.PART = ITEMS.PART AND (T1.CAGE LIKE 'Z-TESTNOUN%'))) OR ((((ITEMS.PART LIKE 'ZCP1%') OR (ITEMS.CAGE LIKE 'ZCC1%')) AND T2.CONDITION_CODE = ITEMS.CONDITION_CODE))) ORDER BY ITEMS.ITEM_ID ASC

Criteria c1 = new Criteria();
c1.setTable(PartMeta.getName());
c1.addInnerCriteria(PartMeta.PART, ItemMeta.PART);
c1.addCriteria(PartMeta.CAGE, Criteria.RELATIONAL_BEGINS_WITH, "Z-TESTNOUN");

AtomicCriteria ac2 = new AtomicCriteria();
ac2.addCriteria(ItemMeta.PART, Criteria.RELATIONAL_BEGINS_WITH, "ZP1");
ac2.addOrCriteria(ItemMeta.SEGREGATION_CODE, Criteria.RELATIONAL_BEGINS_WITH, "ZC1");
AtomicCriteria cac2 = new AtomicCriteria();
cac2.addAtomic(ac2);
cac2.addAggregate(c1);

AtomicCriteria mac2 = new AtomicCriteria();
mac2.addAtomic(cac2);

Criteria c2 = new Criteria();
c2.setTable(ConditionMeta.getName());
c2.addInnerCriteria(ConditionMeta.CONDITION_CODE, ItemMeta.CONDITION_CODE);

AtomicCriteria ac1 = new AtomicCriteria();
ac1.addCriteria(ItemMeta.PART, Criteria.RELATIONAL_BEGINS_WITH, "ZCP1");
ac1.addOrCriteria(ItemMeta.CAGE, Criteria.RELATIONAL_BEGINS_WITH, "ZCC1");
AtomicCriteria cac1 = new AtomicCriteria();
cac1.addAtomic(ac1);
cac1.addAggregate(c2);

AtomicCriteria mac1 = new AtomicCriteria();
mac1.addAtomic(cac1);

AtomicCriteria ac = new AtomicCriteria();
ac.addAtomic(mac2);
ac.addOrAtomic(mac1);

Criteria c = new Criteria();
c.setTable(ItemMeta.getName());
c.addAtomic(ac);
c.addOrderBy(ItemMeta.ITEM_ID, Criteria.ORDER_BY_ASC);

2012-08-26 20:39:42 Tree
[r6322] by prudhvireddy

Added CheckboxField and MultiRowUpdate to jawr bundle

2012-08-24 18:44:38 Tree
[r6321] by SeanZ

Made Jaffa.data.JsonDWRQueryResponseReader for LoadController.

2012-08-23 22:54:19 Tree
[r6320] by prudhvireddy

Created MultiRowUpdate plugin to support batch update of multiple rows on the grid

2012-08-23 17:28:57 Tree
[r6319] by prudhvireddy

Created a new component called CheckBoxField. This will render checkbox adjacent to form field.

2012-08-23 17:26:10 Tree
[r6318] by b_calderwood

Mandatory fields on grids that have not been set should cause errors at the UI. UI will also try display the grid that caused the error by selection the appropriate tabs on the screen.

2012-08-22 23:31:30 Tree
[r6317] by prudhvireddy

Extracted field meta rules application login into a new method called applyFieldMetaRules (Refactor)

2012-08-22 22:56:05 Tree
[r6316] by b_calderwood

If there are errors on some records when deleting multiple rows, then deselect the records that were successfully deleted, leaving the failed records highlighted.

2012-08-22 18:17:12 Tree
[r6315] by SeanZ

Added addResultsPanel() and removeResultsPanel().

2012-08-22 03:30:41 Tree
Older >
MongoDB Logo MongoDB