CodeThatGrid - Selective export, search from url
Search from url: Search in grid for "Skip"
//GLOBAL VARS var DATE_FORMAT = "dd.mm.yyyy", CURRENCY_FORMAT = "$", EMPTY_ROW = "", DEFAULT_COLDEF = { title : "", titleClass : "", type : "String", //the default type width : 80, alignment : "", compareFunction : compare, isVisible : 1, isReadOnly : 0, useAutoIndex : 0, useAutoFilter : 0 }; //Example of use user-type (Discount) in CodeThatGrid var DISCOUNT_FORMAT = "%"; function formatDiscount(data, format) { return data + " " + format; }; function parseDiscount(data) { if (Undef(data)) return 0; data = parseFloat(data.replace(/[^0 - 9-\ + \.]/ig, '')); if (isNaN(data) || data < 0) data = 0; if (data > 100) data = 100; return new Number(data); }; function compareDiscount(op1, op2) { if (Undef(op1) && Undef(op2)) return 0; else if (Undef(op1)) return 1; else if (Undef(op2)) return - 1; if (op1 > op2) return 1; else if (op1 < op2) return - 1; else return 0; }; //GRID DEFINITION var gridDef = { useExportBar : false, useMultiSort : true, useColTitle : true, datatype : 1, data : "0;Stiles James;01.01.2002;jstiles@necasting.com;270\n 1;Alexander Jacklynn;12.05.2003;speedracer1979@iwon.com;1\n 2;Martin Barney;01.01.2002;bmartin1@maine.rr.com;92\n 3;Gelinas Patricia;18.07.2003;pattigelinas@hotmail.com;364\n 4;Cooke Dee;02.05.2002;findDeeCooke@aol.com;74\n 5;Greiner Andrew;08.01.2003;andy_greiner@hotmail.com;0\n 6;Maillet Chad;01.01.2002;ChadRM@rccw.com;265\n 7;Batson Alecia;01.01.2002;acbatson@yahoo.com;0\n 8;Gato Timothy;01.01.2002;tgato2@maine.rr.com;60\n 9;Wheeler Skip;01.01.2002;skipw47@aol.com;59", colDef : [ { title : "ID", titleClass : "", type : "Number", width : 50, alignment : "center", compareFunction : compare, isVisible : true, useAutoIndex : true, useAutoFilter : false }, { title : "Name", titleClass : "", type : "String", width : 150, alignment : "", compareFunction : compare, isVisible : true, useAutoIndex : true, useAutoFilter : false }, { title : "Reg. date", titleClass : "", type : "Date", width : 100, alignment : "center", compareFunction : compare, isVisible : true, useAutoIndex : true, useAutoFilter : false }, { title : "E-mail", titleClass : "", type : "Email1", width : 100, alignment : "center", compareFunction : compare, isVisible : true, useAutoIndex : false, useAutoFilter : false }, { title : "Discount", titleClass : "", type : "Discount", width : 0, alignment : "right", compareFunction : compareDiscount, isVisible : true, useAutoIndex : true, useAutoFilter : false } ], tableStyle : { tableClass : { borderwidth : 0, bordercolor : "#bbbbbb", borderstyle : "solid" }, bgcolor : "#ffffff", x : 10, y : 10, width : 467, height : 360, overflow : "visible" }, rowStyle : { defaultClass : { fontfamily : "Verdana", fontsize : "11px", backgroundcolor : "#ffffee" }, markClass : { fontfamily : "Verdana", fontsize : "11px", backgroundcolor : "#ffffcc", borderwidth : "1", borderstyle : "outset", bordercolor : "#ffffee" }, dragClass : { cursor : "move", borderwidth : "0" }, width : 20, height : 21 }, colStyle : { defaultClass : { fontfamily : "Verdana", fontsize : "12px", backgroundcolor : "#ffffee" }, markClass : { fontfamily : "Verdana", fontsize : "12px", backgroundcolor : "#ffffcc", borderwidth : "1", borderstyle : "outset", bordercolor : "#ffffee" }, dragClass : { cursor : "move", borderwidth : "0" }, width : 100, height : 21 }, cellStyle : { defaultClass : { borderwidth : "0", borderstyle : "solid", bordercolor : "#cfcfcf", fontfamily : "Arial", fontsize : "12px", backgroundcolor : "#ffffff", color : "#000000" }, markClass : { borderwidth : "0", borderstyle : "outset", bordercolor : "#ffffee", fontfamily : "Arial", fontsize : "12px", backgroundcolor : "#ffffcc", color : "#000000" }, currClass : { borderwidth : "1", borderstyle : "solid", bordercolor : "#000000", fontfamily : "Arial", fontsize : "12px", backgroundcolor : "#ffffcc", color : "#000000" } }, toolBar : { height : 29, bgcolor : "#ffffff", defaultClass : { borderwidth : 0, bordercolor : "#bbbbbb", borderstyle : "solid" }, buttons : [ { name : "sortasc", img_on : { src : "img/sortasc.gif", width : "16", height : "16" }, img_off : { src : "img/sortasc_off.gif", width : "16", height : "16" }, text : "Sort data in current column in ascending order" }, { name : "sortdesc", img_on : { src : "img/sortdesc.gif", width : "16", height : "16" }, img_off : { src : "img/sortdesc_off.gif", width : "16", height : "16" }, text : "Sort data in current column in descending order" }, { name : "multisortasc", img_on : { src : "img/multisortasc.gif", width : "16", height : "16" }, img_off : { src : "img/multisortasc_off.gif", width : "16", height : "16" }, text : "Keep current order and sort data in current column in ascending order" }, { name : "multisortdesc", img_on : { src : "img/multisortdesc.gif", width : "16", height : "16" }, img_off : { src : "img/multisortdesc_off.gif", width : "16", height : "16" }, text : "Keep current order and sort data in current column in descending order" }, { name : "resetsort", img_on : { src : "img/resetsort.gif", width : "16", height : "16" }, img_off : { src : "img/resetsort_off.gif", width : "16", height : "16" }, text : "Reset sort" }, { }, { name : "formatbold", img_on : { src : "img/formatbold.gif", width : "16", height : "16" }, img_off : { src : "img/formatbold_off.gif", width : "16", height : "16" }, text : "Format bold" }, { name : "formatitalic", img_on : { src : "img/formatitalic.gif", width : "16", height : "16" }, img_off : { src : "img/formatitalic_off.gif", width : "16", height : "16" }, text : "Format italic" }, { name : "formatunderline", img_on : { src : "img/formatunderline.gif", width : "16", height : "16" }, img_off : { src : "img/formatunderline_off.gif", width : "16", height : "16" }, text : "Format underline" }, { }, { name : "alignleft", img_on : { src : "img/alignleft.gif", width : "16", height : "16" }, img_off : { src : "img/alignleft_off.gif", width : "16", height : "16" }, text : "Align left" }, { name : "aligncenter", img_on : { src : "img/aligncenter.gif", width : "16", height : "16" }, img_off : { src : "img/aligncenter_off.gif", width : "16", height : "16" }, text : "Align center" }, { name : "alignright", img_on : { src : "img/alignright.gif", width : "16", height : "16" }, img_off : { src : "img/alignright_off.gif", width : "16", height : "16" }, text : "Align right" }, { }, { name : "setsearch", img_on : { src : "img/setsearch.gif", width : "16", height : "16" }, text : "Search in grid" }, { name : "resetsearch", img_on : { src : "img/resetsearch.gif", width : "16", height : "16" }, text : "Reset search. Show all records." }, { name : "setamount", img_on : { src : "img/setamount.gif", width : "16", height : "16" }, text : "Set count of records per page" } ] }, statusBar : { height : 15, bgcolor : "#ffffff", defaultClass : { color : "#000000", fontfamily : "Verdana", fontsize : "11px" }, messageClass : { color : "#0000ff", fontfamily : "Verdana", fontsize : "11px" }, fieldText : "Field", valueText : "Value" }, pageTurnBar : { defaultClass : { backgroundcolor : "#ffffff", fontsize : "11px", fontfamily : "Verdana,Arial" }, activeClass : { backgroundcolor : "#D4D0C8", fontsize : "11px", fontfamily : "Verdana,Arial" }, img_on : { src : "img/t_on.gif" }, img_off : { src : "img/t_off.gif" }, text : "Page", width : 65, height : 14 } };