Available in the Full Version

Data Grid - Column Format Function

Product IDProduct NameProduct NumberMake Flag
1Adjustable RaceAR-5381No
2Bearing BallBA-8327No
3BB Ball BearingBE-2349Yes
4Headset Ball BearingsBE-2908No
316BladeBL-2036Yes
317LL CrankarmCA-5965No
318ML CrankarmCA-6738No
319HL CrankarmCA-7457No
320Chainring BoltsCB-2903No
321Chainring NutCN-6137No
322ChainringCR-7833No
323Crown RaceCR-9981No
324Chain StaysCS-2812Yes
325Decal 1DC-8732No
326Decal 2DC-9824No
327Down TubeDT-2377Yes
328Mountain End CapsEC-M092Yes
329Road End CapsEC-R098Yes
330Touring End CapsEC-T209Yes
331Fork EndFE-3760Yes
332FreewheelFH-2981No
341Flat Washer 1FW-1000No
342Flat Washer 6FW-1200No
343Flat Washer 2FW-1400No
344Flat Washer 9FW-3400No
345Flat Washer 4FW-3800No
346Flat Washer 3FW-5160No
347Flat Washer 8FW-5800No
348Flat Washer 5FW-7160No
349Flat Washer 7FW-9160No
350Fork CrownFC-3654Yes
351Front Derailleur CageFC-3982No
352Front Derailleur LinkageFL-2301No
355Guide PulleyGP-0982No
356LL Grip TapeGT-0820No
357ML Grip TapeGT-1209No
358HL Grip TapeGT-2908No
359Thin-Jam Hex Nut 9HJ-1213No
360Thin-Jam Hex Nut 10HJ-1220No
361Thin-Jam Hex Nut 1HJ-1420No
362Thin-Jam Hex Nut 2HJ-1428No
363Thin-Jam Hex Nut 15HJ-3410No
364Thin-Jam Hex Nut 16HJ-3416No
365Thin-Jam Hex Nut 5HJ-3816No
366Thin-Jam Hex Nut 6HJ-3824No
367Thin-Jam Hex Nut 3HJ-5161No
368Thin-Jam Hex Nut 4HJ-5162No
369Thin-Jam Hex Nut 13HJ-5811No
370Thin-Jam Hex Nut 14HJ-5818No
371Thin-Jam Hex Nut 7HJ-7161No
372Thin-Jam Hex Nut 8HJ-7162No
373Thin-Jam Hex Nut 12HJ-9080No
374Thin-Jam Hex Nut 11HJ-9161No
375Hex Nut 5HN-1024No
376Hex Nut 6HN-1032No
377Hex Nut 16HN-1213No
378Hex Nut 17HN-1220No
379Hex Nut 7HN-1224No
380Hex Nut 8HN-1420No
381Hex Nut 9HN-1428No
382Hex Nut 22HN-3410No
383Hex Nut 23HN-3416No
384Hex Nut 12HN-3816No
385Hex Nut 13HN-3824No
386Hex Nut 1HN-4402No
387Hex Nut 10HN-5161No
388Hex Nut 11HN-5162No
389Hex Nut 2HN-5400No
390Hex Nut 20HN-5811No
391Hex Nut 21HN-5818No
392Hex Nut 3HN-6320No
393Hex Nut 14HN-7161No
394Hex Nut 15HN-7162No
395Hex Nut 4HN-8320No
396Hex Nut 18HN-9161No
397Hex Nut 19HN-9168No
398Handlebar TubeHT-2981Yes
399Head TubeHT-8019Yes
400LL HubHU-6280Yes
401HL HubHU-8998Yes
402Keyed WasherKW-4091No
403External Lock Washer 3LE-1000No
404External Lock Washer 4LE-1200No
405External Lock Washer 9LE-1201No
406External Lock Washer 5LE-1400No
407External Lock Washer 7LE-3800No
408External Lock Washer 6LE-5160No
409External Lock Washer 1LE-6000No
410External Lock Washer 8LE-7160No
411External Lock Washer 2LE-8000No
412Internal Lock Washer 3LI-1000No
413Internal Lock Washer 4LI-1200No
414Internal Lock Washer 9LI-1201No
415Internal Lock Washer 5LI-1400No
416Internal Lock Washer 7LI-3800No
417Internal Lock Washer 6LI-5160No
418Internal Lock Washer 10LI-5800No
419Internal Lock Washer 1LI-6000No
420Internal Lock Washer 8LI-7160No
421Internal Lock Washer 2LI-8000No
422Thin-Jam Lock Nut 9LJ-1213No
423Thin-Jam Lock Nut 10LJ-1220No
424Thin-Jam Lock Nut 1LJ-1420No
425Thin-Jam Lock Nut 2LJ-1428No
426Thin-Jam Lock Nut 15LJ-3410No
427Thin-Jam Lock Nut 16LJ-3416No
428Thin-Jam Lock Nut 5LJ-3816No
429Thin-Jam Lock Nut 6LJ-3824No
430Thin-Jam Lock Nut 3LJ-5161No
431Thin-Jam Lock Nut 4LJ-5162No
432Thin-Jam Lock Nut 13LJ-5811No
433Thin-Jam Lock Nut 14LJ-5818No
434Thin-Jam Lock Nut 7LJ-7161No
435Thin-Jam Lock Nut 8LJ-7162No
436Thin-Jam Lock Nut 12LJ-9080No
437Thin-Jam Lock Nut 11LJ-9161No
438Lock Nut 5LN-1024No
439Lock Nut 6LN-1032No
440Lock Nut 16LN-1213No
441Lock Nut 17LN-1220No
442Lock Nut 7LN-1224No
443Lock Nut 8LN-1420No
444Lock Nut 9LN-1428No
445Lock Nut 22LN-3410No
446Lock Nut 23LN-3416No
447Lock Nut 12LN-3816No
448Lock Nut 13LN-3824No
449Lock Nut 1LN-4400No
450Lock Nut 10LN-5161No
451Lock Nut 11LN-5162No
452Lock Nut 2LN-5400No
453Lock Nut 20LN-5811No
454Lock Nut 21LN-5818No
455Lock Nut 3LN-6320No
456Lock Nut 14LN-7161No
457Lock Nut 15LN-7162No
458Lock Nut 4LN-8320No
459Lock Nut 19LN-9080No
460Lock Nut 18LN-9161No
461Lock RingLR-2398No
462Lower Head RaceLR-8520No
463Lock Washer 4LW-1000No
464Lock Washer 5LW-1200No
465Lock Washer 10LW-1201No
466Lock Washer 6LW-1400No
467Lock Washer 13LW-3400No
468Lock Washer 8LW-3800No
469Lock Washer 1LW-4000No
470Lock Washer 7LW-5160No
471Lock Washer 12LW-5800No
472Lock Washer 2LW-6000No
473Lock Washer 9LW-7160No
474Lock Washer 3LW-8000No
475Lock Washer 11LW-9160No
476Metal AngleMA-7075No
477Metal Bar 1MB-2024No
478Metal Bar 2MB-6061No
479Metal Plate 2MP-2066No
480Metal Plate 1MP-2503No
481Metal Plate 3MP-4960No
482Metal Sheet 2MS-0253No
483Metal Sheet 3MS-1256No
484Metal Sheet 7MS-1981No
485Metal Sheet 4MS-2259No
486Metal Sheet 5MS-2341No
487Metal Sheet 6MS-2348No
488Metal Sheet 1MS-6061No
489Metal Tread PlateMT-1000No
490LL NippleNI-4127No
491HL NippleNI-9522No
492Paint - BlackPA-187BNo
493Paint - RedPA-361RNo
494Paint - SilverPA-529SNo
495Paint - BluePA-632UNo
496Paint - YellowPA-823YNo
497Pinch BoltPB-6109No
504Cup-Shaped RaceRA-2345No
505Cone-Shaped RaceRA-7490No
506ReflectorRF-9198No
507LL Mountain RimRM-M464No
508ML Mountain RimRM-M692No
509HL Mountain RimRM-M823No
510LL Road RimRM-R436No
511ML Road RimRM-R600No
512HL Road RimRM-R800No
513Touring RimRM-T801No
514LL Mountain Seat AssemblySA-M198Yes
515ML Mountain Seat AssemblySA-M237Yes
516HL Mountain Seat AssemblySA-M687Yes
517LL Road Seat AssemblySA-R127Yes
518ML Road Seat AssemblySA-R430Yes
519HL Road Seat AssemblySA-R522Yes
520LL Touring Seat AssemblySA-T467Yes
521ML Touring Seat AssemblySA-T612Yes
522HL Touring Seat AssemblySA-T872Yes
523LL Spindle/AxleSD-2342No
524HL Spindle/AxleSD-9872No
525LL ShellSH-4562No
526HL ShellSH-9312No
527SpokesSK-9283No
528Seat LugSL-0931No
529StemSM-9087Yes
530Seat PostSP-2981No
531SteererSR-2098Yes
532Seat StaysSS-2985Yes
533Seat TubeST-9828Yes
534Top TubeTO-2301Yes
535Tension PulleyTP-0923No
679Rear Derailleur CageRC-0291No
680HL Road Frame - Black, 58FR-R92B-58Yes
706HL Road Frame - Red, 58FR-R92R-58Yes
707Sport-100 Helmet, RedHL-U509-RNo
708Sport-100 Helmet, BlackHL-U509No
709Mountain Bike Socks, MSO-B909-MNo
710Mountain Bike Socks, LSO-B909-LNo
711Sport-100 Helmet, BlueHL-U509-BNo
712AWC Logo CapCA-1098No
713Long-Sleeve Logo Jersey, SLJ-0192-SNo
714Long-Sleeve Logo Jersey, MLJ-0192-MNo
715Long-Sleeve Logo Jersey, LLJ-0192-LNo
716Long-Sleeve Logo Jersey, XLLJ-0192-XNo
717HL Road Frame - Red, 62FR-R92R-62Yes
718HL Road Frame - Red, 44FR-R92R-44Yes
719HL Road Frame - Red, 48FR-R92R-48Yes
720HL Road Frame - Red, 52FR-R92R-52Yes
721HL Road Frame - Red, 56FR-R92R-56Yes
722LL Road Frame - Black, 58FR-R38B-58Yes
723LL Road Frame - Black, 60FR-R38B-60Yes
724LL Road Frame - Black, 62FR-R38B-62Yes
725LL Road Frame - Red, 44FR-R38R-44Yes
726LL Road Frame - Red, 48FR-R38R-48Yes
727LL Road Frame - Red, 52FR-R38R-52Yes
728LL Road Frame - Red, 58FR-R38R-58Yes
729LL Road Frame - Red, 60FR-R38R-60Yes
730LL Road Frame - Red, 62FR-R38R-62Yes
731ML Road Frame - Red, 44FR-R72R-44Yes
732ML Road Frame - Red, 48FR-R72R-48Yes
733ML Road Frame - Red, 52FR-R72R-52Yes
734ML Road Frame - Red, 58FR-R72R-58Yes
735ML Road Frame - Red, 60FR-R72R-60Yes
736LL Road Frame - Black, 44FR-R38B-44Yes
737LL Road Frame - Black, 48FR-R38B-48Yes
738LL Road Frame - Black, 52FR-R38B-52Yes
739HL Mountain Frame - Silver, 42FR-M94S-42Yes
740HL Mountain Frame - Silver, 44FR-M94S-44Yes
741HL Mountain Frame - Silver, 48FR-M94S-52Yes
742HL Mountain Frame - Silver, 46FR-M94S-46Yes
743HL Mountain Frame - Black, 42FR-M94B-42Yes
744HL Mountain Frame - Black, 44FR-M94B-44Yes
745HL Mountain Frame - Black, 48FR-M94B-48Yes
746HL Mountain Frame - Black, 46FR-M94B-46Yes
747HL Mountain Frame - Black, 38FR-M94B-38Yes
748HL Mountain Frame - Silver, 38FR-M94S-38Yes
749Road-150 Red, 62BK-R93R-62Yes
750Road-150 Red, 44BK-R93R-44Yes
751Road-150 Red, 48BK-R93R-48Yes
752Road-150 Red, 52BK-R93R-52Yes
753Road-150 Red, 56BK-R93R-56Yes
754Road-450 Red, 58BK-R68R-58Yes
755Road-450 Red, 60BK-R68R-60Yes
756Road-450 Red, 44BK-R68R-44Yes
757Road-450 Red, 48BK-R68R-48Yes
758Road-450 Red, 52BK-R68R-52Yes
759Road-650 Red, 58BK-R50R-58Yes
760Road-650 Red, 60BK-R50R-60Yes
761Road-650 Red, 62BK-R50R-62Yes
762Road-650 Red, 44BK-R50R-44Yes
763Road-650 Red, 48BK-R50R-48Yes
764Road-650 Red, 52BK-R50R-52Yes
765Road-650 Black, 58BK-R50B-58Yes
766Road-650 Black, 60BK-R50B-60Yes
767Road-650 Black, 62BK-R50B-62Yes
768Road-650 Black, 44BK-R50B-44Yes
769Road-650 Black, 48BK-R50B-48Yes
770Road-650 Black, 52BK-R50B-52Yes
771Mountain-100 Silver, 38BK-M82S-38Yes
772Mountain-100 Silver, 42BK-M82S-42Yes
773Mountain-100 Silver, 44BK-M82S-44Yes
774Mountain-100 Silver, 48BK-M82S-48Yes
775Mountain-100 Black, 38BK-M82B-38Yes
776Mountain-100 Black, 42BK-M82B-42Yes
777Mountain-100 Black, 44BK-M82B-44Yes
778Mountain-100 Black, 48BK-M82B-48Yes
779Mountain-200 Silver, 38BK-M68S-38Yes
780Mountain-200 Silver, 42BK-M68S-42Yes
781Mountain-200 Silver, 46BK-M68S-46Yes
782Mountain-200 Black, 38BK-M68B-38Yes
783Mountain-200 Black, 42BK-M68B-42Yes
784Mountain-200 Black, 46BK-M68B-46Yes
785Mountain-300 Black, 38BK-M47B-38Yes
786Mountain-300 Black, 40BK-M47B-40Yes
787Mountain-300 Black, 44BK-M47B-44Yes
788Mountain-300 Black, 48BK-M47B-48Yes
789Road-250 Red, 44BK-R89R-44Yes
790Road-250 Red, 48BK-R89R-48Yes
791Road-250 Red, 52BK-R89R-52Yes
792Road-250 Red, 58BK-R89R-58Yes
793Road-250 Black, 44BK-R89B-44Yes
794Road-250 Black, 48BK-R89B-48Yes
795Road-250 Black, 52BK-R89B-52Yes
796Road-250 Black, 58BK-R89B-58Yes
797Road-550-W Yellow, 38BK-R64Y-38Yes
798Road-550-W Yellow, 40BK-R64Y-40Yes
799Road-550-W Yellow, 42BK-R64Y-42Yes
800Road-550-W Yellow, 44BK-R64Y-44Yes
801Road-550-W Yellow, 48BK-R64Y-48Yes
802LL ForkFK-1639Yes
803ML ForkFK-5136Yes
804HL ForkFK-9939Yes
805LL HeadsetHS-0296Yes
806ML HeadsetHS-2451Yes
807HL HeadsetHS-3479Yes
808LL Mountain HandlebarsHB-M243Yes
809ML Mountain HandlebarsHB-M763Yes
810HL Mountain HandlebarsHB-M918Yes
811LL Road HandlebarsHB-R504Yes
812ML Road HandlebarsHB-R720Yes
813HL Road HandlebarsHB-R956Yes
814ML Mountain Frame - Black, 38FR-M63B-38Yes
815LL Mountain Front WheelFW-M423Yes
816ML Mountain Front WheelFW-M762Yes
817HL Mountain Front WheelFW-M928Yes
818LL Road Front WheelFW-R623Yes
819ML Road Front WheelFW-R762Yes
820HL Road Front WheelFW-R820Yes
821Touring Front WheelFW-T905Yes
822ML Road Frame-W - Yellow, 38FR-R72Y-38Yes
823LL Mountain Rear WheelRW-M423Yes
824ML Mountain Rear WheelRW-M762Yes
825HL Mountain Rear WheelRW-M928Yes
826LL Road Rear WheelRW-R623Yes
827ML Road Rear WheelRW-R762Yes
828HL Road Rear WheelRW-R820Yes
829Touring Rear WheelRW-T905Yes
830ML Mountain Frame - Black, 40FR-M63B-40Yes
831ML Mountain Frame - Black, 44FR-M63B-44Yes
832ML Mountain Frame - Black, 48FR-M63B-48Yes
833ML Road Frame-W - Yellow, 40FR-R72Y-40Yes
834ML Road Frame-W - Yellow, 42FR-R72Y-42Yes
835ML Road Frame-W - Yellow, 44FR-R72Y-44Yes
836ML Road Frame-W - Yellow, 48FR-R72Y-48Yes
837HL Road Frame - Black, 62FR-R92B-62Yes
838HL Road Frame - Black, 44FR-R92B-44Yes
839HL Road Frame - Black, 48FR-R92B-48Yes
840HL Road Frame - Black, 52FR-R92B-52Yes
841Men's Sports Shorts, SSH-M897-SNo
842Touring-Panniers, LargePA-T100No
843Cable LockLO-C100No
844MinipumpPU-0452No
845Mountain PumpPU-M044No
846Taillights - Battery-PoweredLT-T990No
847Headlights - Dual-BeamLT-H902No
848Headlights - WeatherproofLT-H903No
849Men's Sports Shorts, MSH-M897-MNo
850Men's Sports Shorts, LSH-M897-LNo
851Men's Sports Shorts, XLSH-M897-XNo
852Women's Tights, STG-W091-SNo
853Women's Tights, MTG-W091-MNo
854Women's Tights, LTG-W091-LNo
855Men's Bib-Shorts, SSB-M891-SNo
856Men's Bib-Shorts, MSB-M891-MNo
857Men's Bib-Shorts, LSB-M891-LNo
858Half-Finger Gloves, SGL-H102-SNo
859Half-Finger Gloves, MGL-H102-MNo
860Half-Finger Gloves, LGL-H102-LNo
861Full-Finger Gloves, SGL-F110-SNo
862Full-Finger Gloves, MGL-F110-MNo
863Full-Finger Gloves, LGL-F110-LNo
864Classic Vest, SVE-C304-SNo
865Classic Vest, MVE-C304-MNo
866Classic Vest, LVE-C304-LNo
867Women's Mountain Shorts, SSH-W890-SNo
868Women's Mountain Shorts, MSH-W890-MNo
869Women's Mountain Shorts, LSH-W890-LNo
870Water Bottle - 30 oz.WB-H098No
871Mountain Bottle CageBC-M005No
872Road Bottle CageBC-R205No
873Patch Kit/8 PatchesPK-7098No
874Racing Socks, MSO-R809-MNo
875Racing Socks, LSO-R809-LNo
876Hitch Rack - 4-BikeRA-H123No
877Bike Wash - DissolverCL-9009No
878Fender Set - MountainFE-6654No
879All-Purpose Bike StandST-1401No
880Hydration Pack - 70 oz.HY-1023-70No
881Short-Sleeve Classic Jersey, SSJ-0194-SNo
882Short-Sleeve Classic Jersey, MSJ-0194-MNo
883Short-Sleeve Classic Jersey, LSJ-0194-LNo
884Short-Sleeve Classic Jersey, XLSJ-0194-XNo
885HL Touring Frame - Yellow, 60FR-T98Y-60Yes
886LL Touring Frame - Yellow, 62FR-T67Y-62Yes
887HL Touring Frame - Yellow, 46FR-T98Y-46Yes
888HL Touring Frame - Yellow, 50FR-T98Y-50Yes
889HL Touring Frame - Yellow, 54FR-T98Y-54Yes
890HL Touring Frame - Blue, 46FR-T98U-46Yes
891HL Touring Frame - Blue, 50FR-T98U-50Yes
892HL Touring Frame - Blue, 54FR-T98U-54Yes
893HL Touring Frame - Blue, 60FR-T98U-60Yes
894Rear DerailleurRD-2308Yes
895LL Touring Frame - Blue, 50FR-T67U-50Yes
896LL Touring Frame - Blue, 54FR-T67U-54Yes
897LL Touring Frame - Blue, 58FR-T67U-58Yes
898LL Touring Frame - Blue, 62FR-T67U-62Yes
899LL Touring Frame - Yellow, 44FR-T67Y-44Yes
900LL Touring Frame - Yellow, 50FR-T67Y-50Yes
901LL Touring Frame - Yellow, 54FR-T67Y-54Yes
902LL Touring Frame - Yellow, 58FR-T67Y-58Yes
903LL Touring Frame - Blue, 44FR-T67U-44Yes
904ML Mountain Frame-W - Silver, 40FR-M63S-40Yes
905ML Mountain Frame-W - Silver, 42FR-M63S-42Yes
906ML Mountain Frame-W - Silver, 46FR-M63S-46Yes
907Rear BrakesRB-9231No
908LL Mountain Seat/SaddleSE-M236No
909ML Mountain Seat/SaddleSE-M798No
910HL Mountain Seat/SaddleSE-M940No
911LL Road Seat/SaddleSE-R581No
912ML Road Seat/SaddleSE-R908No
913HL Road Seat/SaddleSE-R995No
914LL Touring Seat/SaddleSE-T312No
915ML Touring Seat/SaddleSE-T762No
916HL Touring Seat/SaddleSE-T924No
917LL Mountain Frame - Silver, 42FR-M21S-42Yes
918LL Mountain Frame - Silver, 44FR-M21S-44Yes
919LL Mountain Frame - Silver, 48FR-M21S-48Yes
920LL Mountain Frame - Silver, 52FR-M21S-52Yes
921Mountain Tire TubeTT-M928No
922Road Tire TubeTT-R982No
923Touring Tire TubeTT-T092No
924LL Mountain Frame - Black, 42FR-M21B-42Yes
925LL Mountain Frame - Black, 44FR-M21B-44Yes
926LL Mountain Frame - Black, 48FR-M21B-48Yes
927LL Mountain Frame - Black, 52FR-M21B-52Yes
928LL Mountain TireTI-M267No
929ML Mountain TireTI-M602No
930HL Mountain TireTI-M823No
931LL Road TireTI-R092No
932ML Road TireTI-R628No
933HL Road TireTI-R982No
934Touring TireTI-T723No
935LL Mountain PedalPD-M282No
936ML Mountain PedalPD-M340No
937HL Mountain PedalPD-M562No
938LL Road PedalPD-R347No
939ML Road PedalPD-R563No
940HL Road PedalPD-R853No
941Touring PedalPD-T852No
942ML Mountain Frame-W - Silver, 38FR-M63S-38Yes
943LL Mountain Frame - Black, 40FR-M21B-40Yes
944LL Mountain Frame - Silver, 40FR-M21S-40Yes
945Front DerailleurFD-2342Yes
946LL Touring HandlebarsHB-T721Yes
947HL Touring HandlebarsHB-T928Yes
948Front BrakesFB-9873No
949LL CranksetCS-4759Yes
950ML CranksetCS-6583Yes
951HL CranksetCS-9183Yes
952ChainCH-0234No
953Touring-2000 Blue, 60BK-T44U-60Yes
954Touring-1000 Yellow, 46BK-T79Y-46Yes
955Touring-1000 Yellow, 50BK-T79Y-50Yes
956Touring-1000 Yellow, 54BK-T79Y-54Yes
957Touring-1000 Yellow, 60BK-T79Y-60Yes
958Touring-3000 Blue, 54BK-T18U-54Yes
959Touring-3000 Blue, 58BK-T18U-58Yes
960Touring-3000 Blue, 62BK-T18U-62Yes
961Touring-3000 Yellow, 44BK-T18Y-44Yes
962Touring-3000 Yellow, 50BK-T18Y-50Yes
963Touring-3000 Yellow, 54BK-T18Y-54Yes
964Touring-3000 Yellow, 58BK-T18Y-58Yes
965Touring-3000 Yellow, 62BK-T18Y-62Yes
966Touring-1000 Blue, 46BK-T79U-46Yes
967Touring-1000 Blue, 50BK-T79U-50Yes
968Touring-1000 Blue, 54BK-T79U-54Yes
969Touring-1000 Blue, 60BK-T79U-60Yes
970Touring-2000 Blue, 46BK-T44U-46Yes
971Touring-2000 Blue, 50BK-T44U-50Yes
972Touring-2000 Blue, 54BK-T44U-54Yes
973Road-350-W Yellow, 40BK-R79Y-40Yes
974Road-350-W Yellow, 42BK-R79Y-42Yes
975Road-350-W Yellow, 44BK-R79Y-44Yes
976Road-350-W Yellow, 48BK-R79Y-48Yes
977Road-750 Black, 58BK-R19B-58Yes
978Touring-3000 Blue, 44BK-T18U-44Yes
979Touring-3000 Blue, 50BK-T18U-50Yes
980Mountain-400-W Silver, 38BK-M38S-38Yes
981Mountain-400-W Silver, 40BK-M38S-40Yes
982Mountain-400-W Silver, 42BK-M38S-42Yes
983Mountain-400-W Silver, 46BK-M38S-46Yes
984Mountain-500 Silver, 40BK-M18S-40Yes
985Mountain-500 Silver, 42BK-M18S-42Yes
986Mountain-500 Silver, 44BK-M18S-44Yes
987Mountain-500 Silver, 48BK-M18S-48Yes
988Mountain-500 Silver, 52BK-M18S-52Yes
989Mountain-500 Black, 40BK-M18B-40Yes
990Mountain-500 Black, 42BK-M18B-42Yes
991Mountain-500 Black, 44BK-M18B-44Yes
992Mountain-500 Black, 48BK-M18B-48Yes
993Mountain-500 Black, 52BK-M18B-52Yes
994LL Bottom BracketBB-7421Yes
995ML Bottom BracketBB-8107Yes
996HL Bottom BracketBB-9108Yes
997Road-750 Black, 44BK-R19B-44Yes
998Road-750 Black, 48BK-R19B-48Yes
999Road-750 Black, 52BK-R19B-52Yes

This sample is designed for a larger screen size.

On mobile, try rotating your screen, view full size, or email to another device.

This sample shows how to format column values before displaying them in the grid. The Make Flag boolean column has a formatter function which transforms the true/false values into Yes/No values.

Code View

Copy to Clipboard
<!DOCTYPE html>
<html>
<head>
    <title></title>

    <!-- Ignite UI for jQuery Required Combined CSS Files -->
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet" />
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/structure/infragistics.css" rel="stylesheet" />

    <script src="http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-2.8.3.js"></script>
    <script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
    <script src="http://code.jquery.com/ui/1.11.1/jquery-ui.min.js"></script>

    <!-- Ignite UI for jQuery Required Combined JavaScript Files -->
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.core.js"></script>
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.lob.js"></script>
</head>
<body>
    <table id="grid"></table>
    <script src="/data-files/adventureworks.min.js"></script>
    <script>
        $(function () {
            $("#grid").igGrid({
                autoGenerateColumns: false,
                width: "100%",
                height: "500px",
                columns: [
                    { headerText: "Product ID", key: "ProductID", dataType: "number", width: "15%" },
                    { headerText: "Product Name", key: "Name", dataType: "string", width: "40%" },
                    { headerText: "Product Number", key: "ProductNumber", dataType: "string", width: "30%" },
                    { headerText: "Make Flag", key: "MakeFlag", dataType: "bool", width: "15%", formatter: makeFlagFormatter }
                ],
                dataSource: adventureWorks
            });
        });
        function makeFlagFormatter(val) {
            if (val === true)
                return "Yes";
            return "No";
        }
    </script>
</body>
</html>