List in column

Stimulsoft Reports.JS discussion
Post Reply
kayzumi
Posts: 2
Joined: Thu Nov 03, 2022 1:31 pm

List in column

Post by kayzumi »

I need to fill a report with this information but when it comes to "niveisAcessoPermanente" which has an array, the column is empty.
See in the example:

Code: Select all

{
  "data": {
    "usuarioPessoaInterna": {
      "nodes": [
        {
          "nome": "ALLANA CLARA ISADORA BARROS",
          "identificador": "0145987",
          "grupoId": 1576,
          "grupo": {
            "id": 1576,
            "pessoaGrupo": "FUNCIONÁRIO"
          },
          "areaId": 1477399,
          "area": {
            "id": 1477399,
            "nome": "AREA 02 - SETOR 01"
          },
          "niveisAcessoPermanente": [
            {
              "nivelAcessoId": 1,
              "nivelAcesso": {
                "id": 1,
                "nome": "NÍVEL TESTE REINALDO 01"
              }
            },
            {
              "nivelAcessoId": 6,
              "nivelAcesso": {
                "id": 6,
                "nome": "NÍVEL ACESSO 01"
              }
            },
            {
              "nivelAcessoId": 10,
              "nivelAcesso": {
                "id": 10,
                "nome": "NÍVEL ACESSO 02"
              }
            }
          ]
        }
      ]
    }
  }
}
fdash.jpg
fdash.jpg (142.73 KiB) Viewed 690 times
Attachments
dfsadg.mrt
(26.04 KiB) Downloaded 80 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: List in column

Post by Lech Kulikowski »

Hello,

The dictionary structure in the Report and in the JSON file are different.
You should remove all data sources and then call Synchronize action (Actions - Synchronize)

Or use the correct JSON file.

Thank you.
kayzumi
Posts: 2
Joined: Thu Nov 03, 2022 1:31 pm

Re: List in column

Post by kayzumi »

I removed all data sources and called the Synchronize action (Actions - Synchronize).
But brought only the first information of "niveisAcessoPermanente" from JSON, I need to bring them all "NÍVEL TESTE REINALDO 01", "NÍVEL ACESSO 01", "NÍVEL ACESSO 02" in the same column.

Code: Select all

	{
   "header": {              
	 "titulo": "Relatório de Pessoa Interna",
               "subtitulo": "Filtrado pelo Nome (MARIA OLIVEIRA), pelo Documento (RG 12345678) e ordenado por Data/Hora Identificação",
               "periodo": "Periodo: 11/04/2021 08:00 - 11/04/2021 23:59",
	 "organizacao": "NEXCODE SYSTEMS",
               "contador": "Total de registros: 1000",
	 "logoAplicacao": "",
               "logoOrganizacao": "" 
            },
    "data": {
    "usuarioPessoaInterna": {
      "nodes": [
        {
          "id": 156,
          "nome": "ALLANA CLARA ISADORA BARROS",
          "identificador": "0145987",
          "grupoId": 1576,
          "grupo": {
            "id": 1576,
            "pessoaGrupo": "FUNCIONÁRIO"
          },
          "areaId": 1477399,
          "area": {
            "id": 1477399,
            "nome": "AREA 02 - SETOR 01"
          },
          "niveisAcessoPermanente": [
            {
              "nivelAcessoId": 1,
              "pessoaId": 156,
              "nivelAcesso": {
                "id": 1,
                "nome": "NÍVEL TESTE REINALDO 01"
              }
            },
            {
              "nivelAcessoId": 6,
              "pessoaId": 156,
              "nivelAcesso": {
                "id": 6,
                "nome": "NÍVEL ACESSO 01"
              }
            },
            {
              "nivelAcessoId": 10,
              "pessoaId": 156,
              "nivelAcesso": {
                "id": 10,
                "nome": "NÍVEL ACESSO 02"
              }
            }
          ]
        }
      ]
    }
  }
}
Example of what I need:
Example.jpg
Example.jpg (44.59 KiB) Viewed 681 times
Attachments
1.mrt
(25.72 KiB) Downloaded 79 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: List in column

Post by Lech Kulikowski »

Hello,

In that case, you should use master-detail construction with several bands.
https://www.stimulsoft.com/en/documenta ... report.htm

Thank you.
Post Reply