Como gerar relatórios e exportar para xls/csv?

Ask the community Using Jestor
1

@eduardo has asked:

Is it possible to export a table to xls?

To export data, just create a report with the information you would like to see! For this, access the Reports area (if it’s not in the menu, just press (CMD + K) or (CTRL + k) or click on the “Jump in” option next to Tabs on the left menu , then click on “see all tabs” and search for Reports. It’s this one:

image
image1203×247 21.4 KB

Para exportar uma tabela, é só criar um relatório com as informações que você gostaria de ver!Basta acessar a área de Relatórios (se não estiver no menu, basta apertar a tecla (A) ou clicar nos três pontinhos ao lado de Tabs, ver todas as abas e pesquisar por Relatórios/Reports). É essa aqui:

3 Likes
3

@marcos.figueiredo @dammon.burden About that, it is possible to export these data automaticaly every day or other period? Could be with lowCode or something.

7

Hey @vinimenezes

It’s not possible to activate the Reports via lowcode, but you can create your own files if you know how to format them. For example, I created these two tables:

image
image1432×740 45 KB

image
image1450×736 26 KB

And using the following code, I was able to create a .csv file that brings me all the Active records from the first table.

$search = Jestor.loadData('customreports',['where' => ['status' => 'Active']]);
$report = "";
$headers = json_decode($search[0],true);
foreach($headers as $header => $value){
    $report = $report.$header.",";
}
$report = $report."\n";
foreach($search as $record){
    $record = json_decode($record,true);
    foreach($record as $fields){
        $report = $report.$fields.",";
    }
    $report = $report."\n";
}
$file = Jestor.createNewFile($report,"csv");
$objectNew['file'] = $file;

Then I can open this .csv in Excel.

image
image1234×188 25.5 KB

So you could have a scheduled trick running a function that assembles these reports. It can be harder for other formats such as .xlsx, though.

8

@fernando.nakandakari Ok, Thanks!

9

With this new interface, how to create a new report?

10

Hey @jean

To export data, just create a report with the information you would like to see! For this, access the Reports area clicking on the Jump in bar or pressing (CMD + K) or (CTRL + k) and search for reports ou relatórios
image

1 Like
13

Atualizando, agora você consegue acessar os relatórios diretamente pela seção do connector no seu menu esquerdo.

Aqui está a nossa documentação: Reports

image
image1920×1056 160 KB