Zapatec DHTML Grid Widget - Phone Bill Example

This phone bill example shows a few more advanced capabilities of the Zapatec AJAX grid.

Using the controls on the left, you can filter which rows to display.
Filter Rate Periods - Click the checkboxes to include or exclude different rate periods
Range of Items - Show all rows whose Item column is between the minimum and maximum values.
Range of Minutes - Show all rows whose Minutes column is between the minimum and maximum values.
Filter Minutes - Click the checkboxes to include or exclude different minutes
Notice the difference between controls for filters versus ranges. The filter control allows you to display rows whose column value is selected and the Range Control allows you to display rows whose column value is in the user-defined range.
You can search using regular expressions. For example, "504|000" will show you all phone numbers starting from 504 or 000; "^\." will show you all lines where Total Charges less than 1. Note that regular expressions have some special chars that must be escaped with "\". See documentation for JavaScript built-in RegExp object for details.
You can sort the rows both before and after filtering.

Item	Date	Time	Rate Period	Phone Number	Minutes	Total Charges
1	11/08/2006	09:30AM	P	(911)504-7207	1	.50
2	11/08/2006	10:39AM	P	(910)525-7522	3	1.50
3	11/08/2006	12:11PM	P	(981)483-3140	5	.70
4	11/08/2006	03:41PM	P	(910)504-8168	2	.20
5	11/09/2006	09:50AM	P	(910)642-8345	1	.10
6	11/09/2006	02:49PM	P	(000)000-0086	1	1.23
7	11/09/2006	03:05PM	P	(910)504-8168	6	.40
8	11/09/2006	03:53PM	P	(910)873-0894	5	2.00
9	11/10/2006	11:35AM	P	(910)525-7522	5	1.00
10	11/10/2006	09:41PM	O	(000)000-0086	1	.10
11	11/10/2006	09:42PM	O	(910)292-6349	2	.10
12	11/11/2006	11:14AM	P	(910)525-7522	1	.10
13	11/12/2006	04:24PM	W	(926)485-8854	1	.10
14	11/12/2006	04:36PM	W	(926)485-8854	1	.10
15	11/13/2006	02:46PM	W	(910)776-3005	1	.10
16	11/14/2006	10:45AM	P	(910)504-7207	1	.10
17	11/14/2006	11:27AM	P	(910)504-2167	1	.10
18	11/14/2006	01:25PM	P	(910)525-7522	4	.10
19	11/14/2006	06:41PM	P	(000)000-0086	1	.10
20	11/15/2006	01:19PM	P	(910)504-7207	2	.10
21	11/15/2006	01:26PM	P	(910)504-7207	2	.10
22	11/15/2006	01:27PM	P	(910)717-4984	3	.10
23	11/15/2006	03:21PM	P	(910)504-8168	2	.10
24	11/15/2006	04:52PM	P	(910)525-7522	3	.10
25	11/15/2006	05:54PM	P	(910)504-7207	1	.10
26	11/15/2006	05:55PM	P	(910)504-2167	1	.10
27	11/15/2006	05:58PM	P	(910)527-0883	1	.10
28	11/15/2006	05:59PM	P	(910)710-1325	1	.10
29	11/15/2006	06:00PM	P	(910)710-1325	2	.10
30	11/16/2006	09:41AM	P	(910)525-7522	2	.10
31	11/16/2006	10:44AM	P	(866)522-7941	1	.10
32	11/16/2006	04:08PM	P	(910)525-7522	1	.10
33	11/16/2006	06:49PM	P	(910)525-7522	1	.10
34	11/17/2006	02:42PM	P	(910)525-7522	9	.10
35	11/17/2006	02:55PM	P	(910)525-7522	3	.10
36	11/17/2006	03:04PM	P	(910)525-7522	2	.10
37	11/17/2006	03:17PM	P	(910)504-8168	1	.10
38	11/17/2006	05:45PM	P	(910)776-3005	1	.10
39	11/17/2006	05:56PM	P	(910)525-7522	1	.10
40	11/18/2006	09:03AM	P	(910)504-7207	2	.10
41	11/18/2006	09:15AM	P	(973)785-3080	1	.10
42	11/18/2006	09:24AM	P	(913)960-1457	1	.10
43	11/18/2006	11:45AM	P	(925)791-2200	9	.10
44	11/18/2006	12:12PM	P	(925)791-2200	1	.10
45	11/18/2006	02:40PM	P	(910)717-4984	1	.10
46	11/18/2006	03:01PM	P	(866)522-7941	5	.10
47	11/19/2006	04:14PM	W	(910)504-7207	3	.10
48	11/20/2006	11:31AM	W	(000)000-0086	1	.10
49	11/20/2006	11:32AM	W	(000)000-0086	1	.10
50	11/20/2006	11:35AM	W	(910)525-7522	2	.10
51	11/20/2006	11:50AM	W	(910)525-7522	2	.10
52	11/20/2006	12:11PM	W	(910)525-7522	1	.10
53	11/20/2006	12:53PM	W	(910)504-8168	2	.10
54	11/20/2006	05:49PM	W	(910)525-7522	1	.10
55	11/20/2006	05:53PM	W	(910)504-8168	1	.10
56	11/21/2006	12:20PM	P	(910)642-1714	1	.10
57	11/21/2006	01:43PM	P	(910)717-4984	2	.10
58	11/21/2006	05:46PM	P	(910)559-6688	1	.10
59	11/22/2006	09:49AM	P	(000)000-0086	2	.10
60	11/23/2006	12:58PM	P	(910)525-7522	2	.10
61	11/23/2006	02:02PM	P	(866)522-7941	1	.10
62	11/23/2006	02:22PM	P	(911)852-6217	1	.10
63	11/23/2006	02:43PM	P	(910)776-3005	2	.10
64	11/23/2006	02:57PM	P	(910)525-7522	2	.10
65	11/23/2006	03:36PM	P	(866)522-7941	3	.10
66	11/23/2006	03:45PM	P	(866)522-7941	9	.10
67	11/25/2006	02:12PM	P	(000)000-0086	1	.10
68	11/28/2006	12:01PM	P	(910)525-7522	2	.10
69	11/28/2006	03:26PM	P	(866)522-7941	5	.10
70	11/28/2006	05:05PM	P	(910)525-7522	2	.10
71	11/28/2006	06:16PM	P	(910)504-8168	2	.10
72	11/29/2006	10:30AM	P	(911)374-9561	5	.10
73	11/29/2006	10:42AM	P	(910)525-7522	2	.10
74	11/29/2006	04:32PM	P	(910)642-8345	1	.10
75	11/30/2006	12:00PM	P	(930)426-3661	1	.10
76	11/30/2006	12:07PM	P	(930)426-3661	3	.10
77	11/30/2006	12:12PM	P	(930)587-0557	2	.10
78	11/30/2006	02:10PM	P	(930)386-2557	4	.10
79	11/30/2006	03:24PM	P	(910)525-7522	2	.10
80	12/01/2006	09:52AM	P	(910)525-7522	4	.10
81	12/01/2006	09:57AM	P	(866)522-7941	4	.10
82	12/01/2006	11:59AM	P	(910)528-6402	1	.10
83	12/01/2006	12:00PM	P	(910)525-7522	1	.10
84	12/01/2006	12:03PM	P	(910)528-6402	1	.10
85	12/01/2006	12:51PM	P	(910)525-7522	1	.10
86	12/01/2006	03:11PM	P	(866)522-7941	2	.10
87	12/01/2006	05:08PM	P	(866)522-7941	2	.10
88	12/02/2006	09:49AM	P	(910)504-7204	1	.10
89	12/02/2006	09:49AM	P	(910)504-7207	1	.10
90	12/02/2006	10:15AM	P	(910)525-7522	3	.10
91	12/02/2006	02:02PM	P	(910)504-7207	1	.10
92	12/02/2006	02:19PM	P	(910)504-2167	1	.10
93	12/02/2006	03:43PM	P	(934)846-5561	4	.10
94	12/02/2006	04:46PM	P	(910)504-7207	2	.10
95	12/02/2006	05:06PM	P	(000)000-0086	1	.10
96	12/02/2006	05:07PM	P	(910)710-1325	3	.10
97	12/02/2006	06:04PM	P	(910)710-1325	2	.10
98	12/02/2006	06:06PM	P	(910)504-7207	1	.10
99	12/02/2006	06:10PM	P	(910)504-7207	1	.10
100	12/02/2006	06:16PM	P	(910)504-7207	1	.10
101	12/02/2006	06:30PM	P	(910)504-7207	2	.10
102	12/02/2006	06:32PM	P	(910)220-0883	2	.10
103	12/02/2006	06:37PM	P	(910)220-0883	1	.10
104	12/02/2006	06:40PM	P	(930)400-2929	2	.10
105	12/02/2006	06:45PM	P	(910)504-7207	2	.10
106	12/02/2006	07:10PM	P	(910)504-7207	1	.10
107	12/02/2006	07:15PM	P	(910)504-7207	1	.10
108	12/02/2006	07:18PM	P	(930)400-2929	1	.10
109	12/02/2006	07:20PM	P	(910)220-0883	2	.10
110	12/02/2006	07:24PM	P	(930)400-2929	3	.10
111	12/02/2006	07:40PM	P	(930)400-2929	1	.10
112	12/02/2006	07:47PM	P	(930)400-2929	2	.10
113	12/03/2006	09:12AM	W	(910)710-1325	3	.10
114	12/03/2006	09:29AM	W	(930)400-2929	1	.10
115	12/03/2006	12:25PM	W	(910)504-2167	1	.10
116	12/03/2006	01:06PM	W	(910)504-2167	1	.10
117	12/03/2006	01:33PM	W	(000)000-0086	1	.10
118	12/03/2006	04:06PM	W	(930)400-2929	2	.10
119	12/03/2006	04:08PM	W	(910)710-1325	1	.10
120	12/03/2006	04:11PM	W	(910)504-7207	2	.10
121	12/03/2006	04:21PM	W	(000)000-0086	1	.10
122	12/03/2006	04:22PM	W	(000)000-0086	1	.10
123	12/03/2006	04:22PM	W	(930)386-2628	1	.10
124	12/03/2006	04:23PM	W	(930)386-2628	1	.10
125	12/03/2006	04:55PM	W	(910)504-7207	2	.10
126	12/03/2006	05:06PM	W	(930)386-2628	2	.10
127	12/03/2006	06:15PM	W	(930)386-2628	2	.10
128	12/03/2006	06:21PM	W	(930)386-2628	3	.10
129	12/04/2006	11:36AM	W	(910)504-7207	1	.10
130	12/04/2006	01:20PM	W	(910)504-7207	1	.10
131	12/05/2006	12:10PM	P	(866)522-7941	4	.10
132	12/05/2006	12:47PM	P	(910)504-7207	1	.10
133	12/05/2006	02:09PM	P	(910)525-7522	5	.10
134	12/05/2006	02:11PM	P	(910)504-7207	2	.10
135	12/06/2006	04:45PM	P	(910)504-8168	6	.10
136	12/06/2006	06:48PM	P	(000)000-0086	1	.10
137	12/06/2006	06:49PM	P	(910)504-8168	2	.10
138	12/06/2006	06:50PM	P	(910)525-7522	1	.10
139	12/07/2006	05:53PM	P	(910)527-4777	2	.10

Controls