Re^6: Return value of Search::Elasticsearch search query

I will explain more clearly now. In the input I have formula field with this type of data. I am changing it into equivalent ES query through perl and want to replace in the ES

((column08=Submit | column10=Delivered | column09=Something) & (column
+08=Delivered | column09=Something))
[download]

Need to replace with

 
{'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'}}]}}]}}}}}
[download]

This is for one cell. In the input we can get multi sheets with multi cells in a single book (Excel). We have replace all cells in that.

I am changing the input into the format what i need as in the output.

{
    "sheets": {
        "sheet1": {
            "Sheet_Name": "Ex-Sheet",
            "forumle": [
                {
                    "0": {
                        "colName": "Ex-Col1",
                        "formula": "
[download]

((column08=Submit | column10=Delivered | column09=Something) & (column08=Delivered | column09=Something))

",
                        "total": "false"
                    },
                    "1": {
                        "colName": "Ex-Col1",
                        "formula": "
[download]

((column08=Submit | column10=Delivered | column09=Something) & (column08=Delivered | column09=Something))

",
                        "total": "false"
                    },
                    "2": {
                        "colName": "Ex-Col1",
                        "formula": "
[download]

(column08=Submit & column10=Delivered & column09=Something)

",
                        "total": "false"
                    }
                }
            ]
        }
    }
}
[download]

My code

getting the input into

$doc

from the ES

Loop for getting all the conditions

foreach my $sheet (keys %{ $doc->{'_source'}{'sheets'} })
{
    foreach my $columns (@{ $doc->{'_source'}{'sheets'}{$sheet}{'forum
+le'} })
    {
        foreach my $one (keys %{ $columns })
        {
                    $condition = $columns->{$one}{'formula'};
                    $return_value = function_to_change($condition); #H
+ere I am changing my condition into required output
                    $main_hash{"query"}{"constant_score"}{"filter"} = 
+{$return_value}; #Adding some more data for that 
                    $columns->{$one}{'formula'} = \%main_hash     #Wha
+t to replace that in the original doc
                 }
        }
}
[download]

In the last line of my code I am replacing the existing field with a hash. But its working only for the first iteration of the loop. In the second iteration its showing like

 
'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]]}
[download]

instead of

 
{"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"}}]}}]}}}}}
[download]

But When Dump the hash or converted into json & print Its looking fine. but When I assigned it to a hash It looking like that $var->. How do assign that

Comment on Re^6: Return value of Search::Elasticsearch search query Select or Download Code

Replies are listed 'Best First'.
Re^7: Return value of Search::Elasticsearch search query by Corion (Patriarch) on Jul 11, 2016 at 07:07 UTC
That is because you are assiging the same reference to `\%main_hash` in multiple places. Maybe you want to create a reference to a fresh copy of `%main_hash` every time? The following code will create a fresh copy of the contents of `%main_hash`: `{ %main_hash }` [download] I recommend that you trim down the amount of references you're diving around with until you understand references and data structures in general better.	[reply] [d/l] [select]
Re^8: Return value of Search::Elasticsearch search query by ravi45722 (Pilgrim) on Jul 13, 2016 at 07:09 UTC
Thanks. Now I understand how the references working. As you suggested I started from 0 and finally acheived. Thanks for the reply.	[reply]


XP is just a number
	PerlMonks