VbzCart/queries: Revision history

15 March 2008

• curprev 16:0616:06, 15 March 2008 Woozle talk contribs 27,407 bytes +33 →qryCtg_Items_updates: added "gt.ID_Source AS ID_TGSource"

11 March 2008

• curprev 11:4511:45, 11 March 2008 66.93.241.126 talk 27,374 bytes +230 →qryStk_lines_remaining_forSale: qryStk_lines_Title_info
• curprev 02:2402:24, 11 March 2008 Woozle talk contribs 27,144 bytes +205 →Catalog: qryCbx_Titles

29 February 2008

• curprev 03:1203:12, 29 February 2008 Woozle talk contribs 26,939 bytes +9 →Catalog Sources: isActive condition belongs in qryCtg_build_sub
• curprev 02:5102:51, 29 February 2008 Woozle talk contribs 26,930 bytes +4 →qryCtg_Items_updates_joinable: mysql apparently doesn't like the name "primary" for an index
• curprev 02:5002:50, 29 February 2008 Woozle talk contribs 26,926 bytes +303 →qryCtg_Items_updates_joinable: quasi-temp table _qryCtg_Items_updates
• curprev 02:4602:46, 29 February 2008 Woozle talk contribs 26,623 bytes +13 →qryCtg_build: isInPrint also requires isActive

28 February 2008

• curprev 22:5022:50, 28 February 2008 Woozle talk contribs 26,610 bytes +16 →qryCtg_build_sub: s.isActive
• curprev 00:3600:36, 28 February 2008 Woozle talk contribs 26,594 bytes +14 →qryCtg_build: isCloseOut can be NULL; needs to equate to FALSE when this happens.
• curprev 00:3300:33, 28 February 2008 Woozle talk contribs 26,580 bytes +293 →qryCtg_build_sub: added qry_ctg_titles_active to fix qryCtg_build_sub

27 February 2008

• curprev 22:0622:06, 27 February 2008 Woozle talk contribs 26,287 bytes −1 →qryCtg_Items_updates_joinable: IDS_Update -> IDS_Item
• curprev 21:2121:21, 27 February 2008 Woozle talk contribs 26,288 bytes +1,612 →qryCtg_Items_updates_joinable: qryCtg_build_sub, qryCtg_build
• curprev 15:1415:14, 27 February 2008 Woozle talk contribs 24,676 bytes +12 →qryCtg_Items_updates: added NULLIF so CatSfx will be NULL instead of empty prevents catalog numbers & join keys ending in '-'
• curprev 14:5314:53, 27 February 2008 Woozle talk contribs 24,664 bytes +1,096 →Catalog Sources: qryCtg_Items_updates and _joinable
• curprev 12:5912:59, 27 February 2008 Woozle talk contribs 23,568 bytes +2 →qryCtg_Sources_active: "Now" -> "NOW()" (MySQL syntax)
• curprev 01:0801:08, 27 February 2008 Woozle talk contribs 23,566 bytes +253 →qryItems_prices: Catalog Sources: qryCtg_Sources_active

25 February 2008

• curprev 18:0018:00, 25 February 2008 Woozle talk contribs 23,313 bytes +215 →qryOrdLines_status_union: qryStk_lines_remaining_forSale
• curprev 17:0417:04, 25 February 2008 Woozle talk contribs m 23,098 bytes +2 →qryStock_forOpenOrders: replaced missing semicolon
• curprev 17:0217:02, 25 February 2008 Woozle talk contribs 23,096 bytes +23 more dependencies
• curprev 17:0017:00, 25 February 2008 Woozle talk contribs 23,073 bytes +4 →qryCat_Depts: depts -> cat_depts, suppliers -> cat_supp
• curprev 16:5416:54, 25 February 2008 Woozle talk contribs 23,069 bytes −1,857 moved more views below other views upon which they depend
• curprev 13:4113:41, 25 February 2008 Woozle talk contribs 24,926 bytes +62 moved qryItems_ord_status to satisfy dependency on qryOrdLines_status_union
• curprev 13:3513:35, 25 February 2008 Woozle talk contribs 24,864 bytes 0 →qryCbx_Items: qryCbx_Items_data needs to go first, else mysql complains
• curprev 12:5812:58, 25 February 2008 Woozle talk contribs m 24,864 bytes +2 →v_items: another missing semicolon
• curprev 12:4812:48, 25 February 2008 Woozle talk contribs m 24,862 bytes +1 →v_titles: added missing semicolon
• curprev 01:0501:05, 25 February 2008 Woozle talk contribs m 24,861 bytes +1,394 →Views: added transcludable sections for all SQL

22 January 2008

• curprev 19:0519:05, 22 January 2008 Woozle talk contribs 23,467 bytes +174 →qryCat_Titles: added CatKey_Title for catalog-building form

14 January 2008

• curprev 00:5400:54, 14 January 2008 Woozle talk contribs 23,293 bytes +71 →qryItems_prices: more fields, so we can use it for items.lst as well

13 January 2008

• curprev 14:2714:27, 13 January 2008 Woozle talk contribs 23,222 bytes +680 qryItems_prices

14 December 2007

• curprev 23:3123:31, 14 December 2007 Woozle talk contribs 22,542 bytes +24 →qryStock_Titles_most_recent: tweaks to get quantities right (they still aren't quite, but they're more realistic now)
• curprev 22:5522:55, 14 December 2007 Woozle talk contribs 22,518 bytes +30 →qryStock_Titles_most_recent: grouping by Title to eliminate duplication

12 December 2007

• curprev 15:4515:45, 12 December 2007 Woozle talk contribs 22,488 bytes +10 →v_titles: t.Name
• curprev 14:3414:34, 12 December 2007 Woozle talk contribs 22,478 bytes +666 →v_titles: new v_titles
• curprev 02:4902:49, 12 December 2007 Woozle talk contribs 21,812 bytes +60 →qryStock_Titles_most_recent: qtys *not* summed; join with v_stk_titles_remaining to get stock totals
• curprev 00:5400:54, 12 December 2007 Woozle talk contribs 21,752 bytes +325 →v_stk_items_remaining: v_stk_titles_remaining
• curprev 00:4000:40, 12 December 2007 Woozle talk contribs 21,427 bytes +435 →qryStock_byOpt_andType: qryStock_Titles_most_recent

4 December 2007

• curprev 15:3015:30, 4 December 2007 Woozle talk contribs 20,992 bytes +36 →qryStock_byOpt_andType: sort to end by default (is there more elegant way to do this?)
• curprev 01:4401:44, 4 December 2007 Woozle talk contribs 20,956 bytes +665 →qryStock_forOpenOrders: qryStock_byOpt_andType

29 November 2007

• curprev 20:1220:12, 29 November 2007 Woozle talk contribs 20,291 bytes +166 →qryCbx_Items: tweaks - sorting, filtering; also qtyCbx_Items_for_sale

26 November 2007

• curprev 20:0020:00, 26 November 2007 Woozle talk contribs 20,125 bytes +1,101 →Catalog Items: qryItems_ord_status, qryItems_to_restock
• curprev 19:2919:29, 26 November 2007 Woozle talk contribs 19,024 bytes +2,383 →qryOrdLines_status_union: alternate typecast version; line numbering
• curprev 18:3218:32, 26 November 2007 Woozle talk contribs m 16,641 bytes −10 →qryOrdLines_status_union: ok, the query did actually get created; go figure
• curprev 18:0718:07, 26 November 2007 Woozle talk contribs 16,651 bytes +1,350 →qryOrdLines_open: qryOrdLines_status_union
• curprev 17:3517:35, 26 November 2007 Woozle talk contribs 15,301 bytes −18 →qryOrderLines_open: ID_OrdItem ( -> ID_OrdLine, then thought better of it) -> ID, because this is already a listing of "OrderLines"; shortened name
• curprev 17:0017:00, 26 November 2007 Woozle talk contribs 15,319 bytes +449 →Restocks: qryRstkLines_en_route
• curprev 16:5416:54, 26 November 2007 Woozle talk contribs 14,870 bytes +11 →Orders: rearranged & fixed
• curprev 16:4316:43, 26 November 2007 Woozle talk contribs m 14,859 bytes −1 moved qryOrdLines_PkgdQtys to Orders section
• curprev 16:4116:41, 26 November 2007 Woozle talk contribs 14,860 bytes +1 →qryOrdLines_PkgdQtys: tweaks
• curprev 16:2116:21, 26 November 2007 Woozle talk contribs 14,859 bytes +345 some rearranging
• curprev 16:1016:10, 26 November 2007 Woozle talk contribs 14,514 bytes +446 →qryOrderLines_open: qryPkgLines_byOrdLine_andItem