As per the error I am passing multi types(Hash & JSON). I am changing the ES query into JSON. Due to the error I am trying to pass the hash directly. This is my input doc 

 {
    "sheets": {
        "sheet1": {
            "Sheet_Name": "Ex-Sheet",
            "formulating": [
                {
                    "0": {
                        "colName": "Ex-Col1",
                        "formula": "((column08=Submit | column10=Deliv
+ered | column09=Something) & (column08=Delivered | column09=Something
+))",
                        "total": "false"
                    },
                    "1": {
                        "colName": "Ex-Col1",
                        "formula": "((column08=Submit | column10=Deliv
+ered | column09=Something) & (column08=Delivered | column09=Something
+))",
                        "total": "false"
                    },
                    "2": {
                        "colName": "Ex-Col1",
                        "formula": "(column08=Submit & column10=Delive
+red & column09=Something)",
                        "total": "false"
                    }
                }
            ]
        }
    }
}

[download]

From this input I am taking the formula field and changing into a ES query (hash). As Athanasius mentioned in the above reply I am replacing the formulae with my hash.

 $columns->{$one}{'formula'} = %main_hash; #main_hash contains ES query

But its replacing as '1/8'. So I passed that as a address

 $columns->{$one}{'formula'} = \%main_hash;

But now its working only for first element in the loop. For the second element its showing as 

 
[$VAR1->{'request'}{'body'}{'_source'}{'sheets'}{'sheet1'}{'forumle'}[
+0]{'1'}{'formula'}{'query'}{'constant_score'}{'filter'}{'bool'}{'shou
+ld'}[0],$VAR1->{'request'}{'body'}{'_source'}{'sheets'}{'sheet1'}{'fo
+rumle'}[0]{'1'}{'formula'}{'query'}{'constant_score'}{'filter'}{'bool
+'}{'should'}[1],{'....

[download]

How to replace my hash in the loop???? 

if {
   .....
}
else
{
    my %main_hash = ();
    $main_hash{"query"}{"constant_score"}{"filter"} = @condition_array
+[(int($condition)-1)];
    my $json = encode_json \%main_hash;
    print Dumper \%main_hash;                   #printing very fine he
+re
    $columns->{$one}{'formula'} = \%main_hash;  #$columns is a address
+ in $doc
    print Dumper $doc;                          #Working only for firs
+t element
        #exit;
    #print $json,$/;
}

[download]

In reply to Re^4: Return value of Search::Elasticsearch search query by ravi45722
in thread Return value of Search::Elasticsearch search query by ravi45722

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.