VbzCart/docs/queries: Revision history

16 November 2008

• curprev 22:0822:08, 16 November 2008‎ imported>Woozle‎ m 38,305 bytes +73‎ →‎qtyOrderItems_Active: history
• curprev 22:0822:08, 16 November 2008‎ imported>Woozle‎ m 38,232 bytes +1‎ →‎qryOrderLines_Active: history
• curprev 22:0822:08, 16 November 2008‎ imported>Woozle‎ m 38,231 bytes +72‎ →‎qryOrderLines_Active: history
• curprev 22:0422:04, 16 November 2008‎ imported>Woozle‎ m 38,159 bytes +77‎ →‎new version: history
• curprev 22:0222:02, 16 November 2008‎ imported>Woozle‎ m 38,082 bytes +14‎ →‎qryCbx_Restocks: tidying
• curprev 21:5821:58, 16 November 2008‎ imported>Woozle‎ 38,068 bytes +106‎ →‎qryOrdLines_status_union: history
• curprev 21:5621:56, 16 November 2008‎ imported>Woozle‎ 37,962 bytes +97‎ →‎qryItems_ord_status: history
• curprev 21:3621:36, 16 November 2008‎ imported>Woozle‎ 37,865 bytes +2,928‎ →‎qryOrders_Active: new queries for restocking process (list of open items; now need to add in items to order for stock minima)

13 November 2008

• curprev 13:4813:48, 13 November 2008‎ imported>Woozle‎ m 34,937 bytes +112‎ →‎qryStock_forOpenOrders: dependency links

6 November 2008

• curprev 00:4800:48, 6 November 2008‎ imported>Woozle‎ m 34,825 bytes +3‎ →‎qryOrdLines_to_restock: fixed dependency link
• curprev 00:4300:43, 6 November 2008‎ imported>Woozle‎ m 34,822 bytes +5‎ →‎qryOrdLines_to_restock: dependency link
• curprev 00:3700:37, 6 November 2008‎ imported>Woozle‎ m 34,817 bytes +46‎ →‎qryFrm_OrdLines_to_restock: dependency link

3 November 2008

• curprev 02:3202:32, 3 November 2008‎ imported>Woozle‎ 34,771 bytes +10‎ →‎qryItems_ord_status: mods to accomodate rewritten source data
• curprev 02:2502:25, 3 November 2008‎ imported>Woozle‎ 34,761 bytes −31‎ →‎qryOrdLines_status_union: changed When field names
• curprev 02:2202:22, 3 November 2008‎ imported>Woozle‎ m 34,792 bytes 0‎ →‎qryItems_ord_status: corrected dependency
• curprev 02:2102:21, 3 November 2008‎ imported>Woozle‎ m 34,792 bytes +6‎ →‎qryItems_ord_status: dependency link
• curprev 02:2002:20, 3 November 2008‎ imported>Woozle‎ m 34,786 bytes +6‎ →‎qryItems_to_restock: dependency link
• curprev 02:1902:19, 3 November 2008‎ imported>Woozle‎ 34,780 bytes +29‎ →‎new version: +WhenNeeded, +WhenStarted
• curprev 02:1402:14, 3 November 2008‎ imported>Woozle‎ 34,751 bytes −186‎ →‎qryCbx_Restocks: update: creates the query just fine; ignore error.
• curprev 02:1202:12, 3 November 2008‎ imported>Woozle‎ m 34,937 bytes +41‎ →‎new version: section markers
• curprev 02:1102:11, 3 November 2008‎ imported>Woozle‎ 34,896 bytes +11‎ →‎new version: +QtyDone,
• curprev 02:0102:01, 3 November 2008‎ imported>Woozle‎ 34,885 bytes +476‎ →‎qryOrdLines_open: rewrite

1 November 2008

• curprev 16:5016:50, 1 November 2008‎ imported>Woozle‎ m 34,409 bytes +6‎ →‎qryOrdLines_PkgdQtys: dependency link
• curprev 16:5016:50, 1 November 2008‎ imported>Woozle‎ m 34,403 bytes +5‎ →‎qryOrdLines_open: dependency link

4 October 2008

• curprev 19:5719:57, 4 October 2008‎ imported>Woozle‎ 34,398 bytes +13‎ →‎qryOrdLines_to_restock: fixed MS Access dependencies
• curprev 17:2317:23, 4 October 2008‎ imported>Woozle‎ 34,385 bytes 0‎ →‎qryFrm_OrdLines_to_restock: updated name of data source query

4 July 2008

• curprev 23:1823:18, 4 July 2008‎ imported>Woozle‎ 34,385 bytes −2‎ →‎qryOrdLines_ord_status: now works with MySQL, though not tested for accuracy
• curprev 19:2119:21, 4 July 2008‎ imported>Woozle‎ 34,387 bytes +835‎ →‎Stock: qryOrdLines_ord_status (Access version), and moved/revised 2 new queries which actually depend on this one
• curprev 12:4612:46, 4 July 2008‎ imported>Woozle‎ m 33,552 bytes 0‎ →‎Stock: moved 2 new queries so they come in order of dependency

1 July 2008

• curprev 22:1122:11, 1 July 2008‎ imported>Woozle‎ 33,552 bytes +1,166‎ →‎Stock: qryOrdLines_to_restock, qryFrm_OrdLines_to_restock : Access versions, not rewritten for MySQL yet

28 May 2008

• curprev 14:1314:13, 28 May 2008‎ imported>Woozle‎ 32,386 bytes +344‎ →‎Orders: qryCustAddrs

23 May 2008

• curprev 19:3719:37, 23 May 2008‎ imported>Woozle‎ 32,042 bytes +14‎ →‎qryCat_Titles_web: CAST AS CHAR, otherwise problems happen
• curprev 16:0116:01, 23 May 2008‎ imported>Woozle‎ 32,028 bytes +27‎ →‎qryCat_Titles_Item_stats: +DateAdded
• curprev 15:5615:56, 23 May 2008‎ imported>Woozle‎ 32,001 bytes +411‎ →‎qryCat_Titles_Item_stats: qryCat_Titles_web
• curprev 15:4015:40, 23 May 2008‎ imported>Woozle‎ 31,590 bytes +4‎ →‎qryCat_Titles_Item_stats: ID_Supp -> ID_Supplier

22 May 2008

• curprev 20:3220:32, 22 May 2008‎ imported>Woozle‎ 31,586 bytes +65‎ →‎v_titles: deprecated
• curprev 20:3020:30, 22 May 2008‎ imported>Woozle‎ 31,521 bytes +702‎ →‎qryCat_Titles: qryCat_Titles_Item_stats

4 April 2008

• curprev 19:0719:07, 4 April 2008‎ imported>Woozle‎ 30,819 bytes +401‎ →‎qryTitles_ItTyps_grpItems: ok, we *don't* want to group by Grp*
• curprev 18:2118:21, 4 April 2008‎ imported>Woozle‎ 30,418 bytes +385‎ →‎qryTitles_ItTyps_grpItems: more explanation for necessity
• curprev 18:1918:19, 4 April 2008‎ imported>Woozle‎ 30,033 bytes +56‎ →‎qryTitles_ItTyps_grpItems: also group by GrpCode and associated fields
• curprev 14:0514:05, 4 April 2008‎ imported>Woozle‎ 29,977 bytes 0‎ →‎Catalog Sources: moved qryCtg_Items_active to be with other qryCtg_Items_*

30 March 2008

• curprev 15:3815:38, 30 March 2008‎ imported>Woozle‎ 29,977 bytes +208‎ →‎qryTitles_ItTyps_grpItems: removed filtering for in-stock only
• curprev 02:0202:02, 30 March 2008‎ imported>Woozle‎ 29,769 bytes +68‎ →‎qryCat_Titles: +CatWeb so we can use this to update cat_pages
• curprev 01:5901:59, 30 March 2008‎ imported>Woozle‎ 29,701 bytes +107‎ →‎qryCat_Depts: more fields so we can use this to update cat_pages

28 March 2008

• curprev 21:3321:33, 28 March 2008‎ imported>Woozle‎ 29,594 bytes +17‎ →‎qryTitles_ItTyps_grpItems: only isForSale items, otherwise price range includes items not available
• curprev 20:5620:56, 28 March 2008‎ imported>Woozle‎ 29,577 bytes +2,050‎ →‎v_titles: several queries for generating page displays (gradually replacing data management/caching system cuz it's a PitB); +ID_Dept in v_titles

23 March 2008

• curprev 20:1520:15, 23 March 2008‎ imported>Woozle‎ m 27,527 bytes +1‎ →‎qryCtg_Items_active: put in missing semicolon
• curprev 20:1420:14, 23 March 2008‎ imported>Woozle‎ 27,526 bytes +428‎ →‎qryCtg_Titles_active: qryCtg_Items_active

15 March 2008

• curprev 16:5816:58, 15 March 2008‎ imported>Woozle‎ m 27,098 bytes −2‎ →‎qry_ctg_titles_active: -> qryCtg_Titles_active (more canonical)
• curprev 16:3716:37, 15 March 2008‎ imported>Woozle‎ m 27,100 bytes +8‎ →‎qryCtg_Items_updates_joinable: closed mysql tag