User Selection by Field  
 
 
 
This sample displays the following features:
  • Header display -- whay you are reading
  • Displays results from a View (vwUsersComplete)
  • Dropdown Filter Selection display a static list of value
  • Text Search Filter that references Dropdown Filter value
  • User assigned display sequence of filters
  • Sortable Columns - initial sort on Username
  • Record Count Displayed
  • Default CSS classed applied
  • Display Generated SQL and parameter (used for testing)

Select Field 1 Select Value 1 Select Field 2 Select Value 2 
UsernameFirstNameLastNameCity
dream zyx tshierly 
123123123 
1qaz1QAZ 
2redline2redline2redline 
43rdworldBobBarker 
5503landisjzNewark
aaa 
a.esmatAhmedEsmat 
aalzehlaateikalzehla 
aangaAng 
aangelAlejandroAngel 
aasidorovAlexeySidorovMoscow
ababaralibabar 
abastiasalfonsobastiasSantiago
abcdefgqq 
abdelsalahsalahabdelmoujoud 
abdeveloperakbarbahrami 
AbeerAbeerFaisal 
abenerAKadirBener 
AbessinierkatzeAbessinierKatze 
abhishekabhishekjain 
abihn@mhsaa.comAnthonyBihn 
abimanyusaktiabimanyusaktiabimanyusakti 
abisyurfaabisyurfa 
ac123CavallariAndrea 
acandaelAnthonyCandaele 
accessbobBobLarson 
AChadburnAdamChadburn 
achiptaalbertchipta 
acorpFilipFilipov 
adam@omc-international.com.auAdamBrown 
adamcox27AdamCoxNorth York
adamhAdamHawke 
AdamtwlvAS 
adersonAdersonOliveiraAjax
adeschenesAlainDeschenes 
adigaganeshadigabangalore
AdityaBhushanAdityaBhushan 
adminAdministratorAccount 
AdrianAdrianAdrian 
adskiadskik-
advantagetitleGregRohman 
aerotechpatdonovan 
aerukovAlexEryukov 
aespinosaalmaespinosa 
afrothunder006mfdrdrmf 
agamennonedavide 
agrumbachAndreasGrumbachHarsewinkel
AGSHARAhmadJaber 
agustafsonAndrewGustafsonBurlington
AGVHAdriaanVan H 
ahangahangbaghschomali 
ahiiohahiiohahiioh 
ahmadsiarsadrsadr 
ahmadmohammadiahmadmohammadi 
ahmartinahm 
ahmetkuahmetkucuk 
ahoepfnerAndyHoepfner 
AhydeAndrewHyde 
Ainer v. FielenAinervon Fielen 
aismailyaneelismaily 
ajkainAlexKainMy City
ajuhosArpadJuhkoja 
AkkrapholAkkrapholThongdeeBangkok
akundinraoakundi 
alaaeddinalaaeddinalweish 
alammonsAnthonyLammons 
alan.duncan@bell.netAlanDuncan 
AlanJAlanJ 
alanmilletAlanMillet 
alanstantonAlanStanton 
albertogiuAlbertoGiudiz 
albertramsbottomasasdsaasdasdasd 
alejandroalejandromonroy 
alerts@setseg.orgInformationSystemsLansing
Alex.StalkerAlexStalker 
Alex1278AlessandroBaldari 
alex7777AlexAlexM 
alexewAlex Wielhouwer 
AlexFbuitragoAlex Buitrago 
alexmariAlessandroMarinoniMilano
alexnightingaleAlexNightingaleMoscow
AlexSciannaAlexScianna 
alfbuitragoALEXBUITRAGO 
alhildrethAlHildreth 
alhilm01hilmiali 
allenwfcAllenChiangCainta
alonalonalgrasi 
alouisAlisterLouisAuckland
alterego55BillBertovich 
amaraamarato 
amastroAngeloMastrogiacomo 
aminkovAlexMinkov 
amirbaghbanamirbaghban 
amirghayesAmirGhayes 
amontoyaadolfomontoya 
ananceANance 
andegalcaandyg 
andersonitcolinanderson 
andreacwsandreasmith 
 100 Total Records 

Display of SQL and Parameters shown as example of SQL actual processed - This option is typically disabled in normal conditions