Help for this page

Select Code to Download


  1. or download this
    ((column08=Submit | column10=Delivered | column09=Something) & (column
+08=Delivered | column09=Something))
  2. or download this
     
{'query' => {'constant_score' => {'filter' => {'bool' => {'should' => 
+[{'bool' => {'must' => [{'term' => {'column08' => 'Submit'}},{'term' 
+=> {'column10' => 'Delivered'}},{'term' => {'column09' => 'Something'
+}}]}},{'bool' => {'must' => [{'term' => {'column08' => 'Delivered'}},
+{'term' => {'column09' => 'Something'}}]}}]}}}}}
  3. or download this
    {
    "sheets": {
...
                    "0": {
                        "colName": "Ex-Col1",
                        "formula": "
  4. or download this
    ",
                        "total": "false"
                    },
                    "1": {
                        "colName": "Ex-Col1",
                        "formula": "
  5. or download this
    ",
                        "total": "false"
                    },
                    "2": {
                        "colName": "Ex-Col1",
                        "formula": "
  6. or download this
    ",
                        "total": "false"
                    }
...
        }
    }
}
  7. or download this
    foreach my $sheet (keys %{ $doc->{'_source'}{'sheets'} })
{
    foreach my $columns (@{ $doc->{'_source'}{'sheets'}{$sheet}{'forum
+le'} })
...
                 }
        }
}
  8. or download this
     
'bool' => {
                'should' => [
                              $VAR1->{'_source'}{'sheets'}{'sheet1'}{'
+forumle'}[0]{'1'}{'formula'}{'query'}{'constant_score'}{'filter'}{'bo
+ol'}{'should'}[0],
                             $VAR1->{'_source'}{'sheets'}{'sheet1'}{'f
+orumle'}[0]{'1'}{'formula'}{'query'}{'constant_score'}{'filter'}{'boo
+l'}{'should'}[1]]}
  9. or download this
     
{"query":{"constant_score":{"filter":{"bool":{"should":[{"bool":{"must
+":[{"term":{"column08":"Submit"}},{"term":{"column10":"Delivered"}},{
+"term":{"column09":"Something"}}]}},{"bool":{"must":[{"term":{"column
+08":"Delivered"}},{"term":{"column09":"Something"}}]}},{"bool":{"must
+":[{"term":{"column08":"Submit"}},{"term":{"column10":"Delivered"}},{
+"term":{"column09":"Something"}}]}},{"bool":{"must":[{"term":{"column
+08":"Delivered"}},{"term":{"column09":"Something"}}]}}]}}}}}