Hi, Could you recommend me something for the subj:

I use the Join process to join sql and css data. for example I have 2 tables sql

id1    value
1	100
2	200
3	300

css

id2	value
1	10
2	20

What i wanna get is

id	valuesql	valuecss
1	100		10
2	200		20
3	300		n/a

I think I can use it... thank you so much

but for my understanding - what is the difference - join 2 sources and put in one DataStore vs put each source in the separate DataStore and join them after that? What are the advantages and disadvantages?

Do you have something like CalculatedColumn for DataStore?

The problem is that I need to do some calculations that used data from both tables and put the result in the new column.

If I do join on the process level (before i put data to any DataStore) - i can do it, but how to do the same with DataStore?

I think i can use process() for that and use CalculatedColumn but can i use function($data){...} for calculation?

Something went wrong :-(

I tried to update my report file using left join etc but get the empty table

What i have 1. Two DataStores dataStore('stock') and dataStore('from_csv')

$this->src('quinos')
            ->query($query)
            ->params($query_params)
            ->saveTo($fromsql)
            ->pipe($this->dataStore('stock'));

and

$this->src('fact')
                ->saveTo($fromcsv)
                ->pipe($this->dataStore('from_csv'));

1. this is the part of my report file

$tmp_store = $this->dataStore('stock')->leftJoin($this->dataStore('from_csv'),array(
                "name" => "name"
            ));
            $tmp_store->process (new CalculatedColumn(array(
                "diff" => function($data){
                    return $data["fact"]-$data["balance"];
                },
            )))
                ->pipe($this->dataStore("joined_stock"));

If i use the same CalculationColumn code after using $join = new Join($fromsql, $fromcsv, array("name" => "name")); everything is ok excepting that i need the left join

Ah so but what to do in the report view file in this case. I did

Table::create(array(
            "dataStore" => $this->dataStore('joined_stock'),

but it will not work more so how to link the $joined_stock_datastore with the Table?

Thank you it works.

Could you also suggest a way to merge 2 datastore with the same set of fields. i can do it via each() and append() but may be you have another way

I meant merge rows... like union all

ok thank you so much

Hi guys, I am trying to do LeftJoin of two data sets and I am getting error Message: Invalid argument supplied for foreach()

My code looks like this:

// 1st
$stanjeRobe = $this->src('automaker')
                        ->query($prodaja_radnje['priprema'])
                        ->params(array(
                            ":korisnik"=>$dodDobavljac
                        )) // ;
                        ->pipe($this->dataStore("stanjeRobe"));


// 2nd store
$prodajaRadnje = $this->src('automaker')
                    ->query($prodaja_radnje['sve'])
                    ->params(array(
                        ":korisnik"=>$dodDobavljac,
                        ":start"=>$this->params["dateRange"][0],
                        ":end"=>$this->params["dateRange"][1],
                    ))//;
                    ->pipe($this->dataStore("prometRobe"));


$new_store = $this->dataStore('prometRobe')->leftJoin($this->dataStore('stanjeRobe'),array(
                    "SifraMat"=>"SifraMat"
                ));

I have tried this way as well, same thig but a bit different:

// ## 1st
                $this->src('automaker')
                ->query($prodaja_radnje['priprema'])
                ->params(array(
                            ":korisnik"=>$dodDobavljac
                ))
                ->pipe($this->dataStore("stanjeRobe"));


// ## 2nd
                $this->src('automaker')
                ->query($prodaja_radnje['sve'])
                ->params(array(
                        ":korisnik"=>$dodDobavljac,
                        ":start"=>$this->params["dateRange"][0],
                        ":end"=>$this->params["dateRange"][1],
                ))
                ->pipe($this->dataStore("prodajaRadnje")); 


// this throws an error: Message:  Invalid argument supplied for foreach()
$new_store = $this->dataStore('prodajaRadnje')->leftJoin($this->dataStore('stanjeRobe'),array(
                    "SifraMat"=>"SifraMat"
                ));

I am using just Join as below and works fine but I need left join to have correct data.

$join = new Join($stanjeRobe,$prodajaRadnje,array(
"SifraMat"=>"SifraMat","BrojSklad"=>"BrojSklad"
)); 

Is there something different in documentation (https://www.koolreport.com/docs/datastore/overview/#join-methods-leftjoin) that I am missing or I did not use it properly here.