|++Kami Nikki | v002 test | Wassr jquery | jQuery › Downloads › Plugins › csv2table | › jQchart | [Japanese]

setting.where

WHERE
E.g.1 where : [ { 'ColName' : 'condition' } , '&&' , { 'ColNmae' : 'condition' } , ...n ]
E.g.2 where : [ [ ColNum : 'condition' ] , '&&' , [ ColNum : 'condition' ] , ...n ]


Number

Number (3 digit commmas)

String

Plural conditions ('&&' is AND, '||' is OR)

NOT


like

like Percentage (% is Wild card, ambiguous searching)

like Underscore (_ accords with one letter)

like Escape (\\ are escape % or _ )

./data/where1-en.csv

NO,Name,Kinds,Age,Yen
1,AI,Monkey,10,"100,000"
2,Tama,Cat,5,"80,000"
3,Char,Dog,12,"5,000,000"
4,AA,Pig,3,"50,000"
5,Ii,Weasel,2,"50,000"
6,Gar,goldfish3%da,1,"5,000"
7,Mike,Tortoise,5,"20,000"
8,Pochi,_t_ig_e_r_,2,"10,000"
9,Tom,Lion,2,"2,000"
10,Mary,Dog,5,"80,000"
11,ToTo,Salmon,2,"60,000"
12,Ponta,Racoon,2,"60,000"
13,Bee,goldfish300%nanoda,3,"50,000"
14,Poh,Pig_Dog,8,"10,000"
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="content-script-type" content="text/javascript">
<meta http-equiv="content-style-type" content="text/css">

 
<script src="./js/jquery-.min.js" type="text/javascript"></script>
<script src="./js/jquery.-.js" type="text/javascript" charset="utf-8"></script>

<hr>Number<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Age':'==5'}]
                });"
       value="where : [{'Age':'==5'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Age':'<11'}]
                });"
       value="where : [{'Age':'<11'}]">
<hr>Number (3 digit commmas)<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Yen':'<=20000'}]
                });"
       value="where : [{'Yen':'<=20000'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Yen':'<=20,000'}]
                });"
       value="where : [{'Yen':'<=20,000'}]">
<hr>String<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Name':'==AI'}]
                });"
       value="where : [{'Name':'==AI'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'==Dog'}]
                });"
       value="where : [{'Kinds':'==Dog'}]">

<hr>Plural conditions ('&&' is AND, '||' is OR)<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'NO':'<5'},'&&',{'Age':'>=10'}]
                });"
       value="where : [{'NO':'<5'},'&&',{'Age':'>=10'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'NO':'==5'},'||',{'Kinds':'==Tortoise'}]
                });"
       value="where : [{'NO':'==5'},'||',{'Kinds':'==Tortoise'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'NO':'==5'},'||',{'Kinds':'==Tortoise'},'&&',{'Age':'<3'}]
                });"
       value="where : [{'NO':'==5'},'||',{'Kinds':'==Tortoise'},'&&',{'Age':'<3'}]">
<hr>NOT<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'NO':'!=5'}]
                });"
       value="where : [{'NO':'!=5'}]">

<hr>

<div style="padding:5px;margin:5px;border:5px solid gold">

  <!-- Table is output to here -->
  <div id="viewSettingWhere"></div></div>

</div>

<hr>like<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like Weasel'}]
                });"
       value="where : [{'Kinds':'like Weasel'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like Weas'}]
                });"
       value="where : [{'Kinds':'like Weas'}]">
<hr>like Percentage  (% is Wild card, ambiguous searching)<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like Weas%'}]
                });"
       value="where : [{'Kinds':'like Weas%'}]">

<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like %eas%'}]
                });"
       value="where : [{'Kinds':'like %eas%'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Yen':'like 5%0'}]
                });"
       value="where : [{'Yen':'like 5%0'}]">


<hr>like Underscore (_ accords with one letter)<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like Raco__'}]
                });"
       value="where : [{'Kinds':'like Raco__'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Name':'like Ch_r'}]
                });"
       value="where : [{'Name':'like Ch_r'}]">

<hr>like Escape (\\ are escape % or _ )<br>
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like goldfish3%da'}]
                });"
       value="where : [{'Kinds':'like goldfish3%da'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like goldfish3\\%da'}]
                });"
       value="where : [{'Kinds':'like goldfish3\\%da'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like %_ig%'}]
                });"
       value="where : [{'Kinds':'like %_ig%'}]">
<input
       class="btn1"
       type    =  "button"
       onclick="$('#viewSettingWhere').csv2table('./data/where1-en.csv',{
                    where : [{'Kinds':'like \\_t\\_ig\\_e\\_r\\_'}]
                });"
       value="where : [{'Kinds':'like \\_t\\_ig\\_e\\_r\\_'}]">
<hr>

<!-- Table is output to here -->
<div id="viewSettingWhere"></div>

|++Kamo Nikki | v002 test | jQuery › Downloads › Plugins › csv2table |