Get Free Trial

Errors with row filters

Answered
Ferran Lopez asked on May 16, 2022

Adding filters in rows doesn’t load all filters. We have tested with the direct form and with the setFilter function. I attached the example and the error. Some filters load them but not all of them, even being filters on the same field there are some that do load them and others not.
 
Direct form:

report.slice.rows = [{“uniqueName”:”Codigo Incidencia_STRING”},
                               {“uniqueName”:”Titulo_STRING”,”filter”:{“members”:[“Titulo_STRING.[Activación informes de nexttDIRECTOR]”,
                                                                                  “Titulo_STRING.[Añadir el filtro de clientes ´obsoletos´ en la consulta Servicios A3 – Locales Sigfrid (Incorrectos)]”,
                                                                                  “Titulo_STRING.[Añadir hora en Informe ND Cancelaciones / Productos]”,
                                                                                  “Titulo_STRING.[Consulta listado proveedores]”,
                                                                                  “Titulo_STRING.[Cambio masivo de contraseñas del usuario hotline para todos los dominos de Sigfrid/Nexttdirector]”,
                                                                                  “Titulo_STRING.[Desarrollo FTP en NexttPOS]”]}},
                               {“uniqueName”:”Estado_STRING”},
                               {“uniqueName”:”Fecha Registro_DATE”},
                               {“uniqueName”:”Cliente_STRING”,”filter”:{“members”:[“Cliente_STRING.[NEXTT]”]}},
                               {“uniqueName”:”Prioridad_STRING”},
                               {“uniqueName”:”Aplica a_STRING”},
                               {“uniqueName”:”Dpto Asume Coste_STRING”},
                               {“uniqueName”:”Criterio_STRING”}];

Error:
 
attahced file error1.PNG
 
With setFilter:

scope.pivot.setFilter(“Titulo_STRING”,
        {
          “members”: [
            “Titulo_STRING.[Activación informes de nexttDIRECTOR]”,
            “Titulo_STRING.[Añadir el filtro de clientes ´obsoletos´ en la consulta Servicios A3 – Locales Sigfrid (Incorrectos)]”,
            “Titulo_STRING.[Añadir hora en Informe ND Cancelaciones / Productos]”,
            “Titulo_STRING.[Consulta listado proveedores]”,
            “Titulo_STRING.[Cambio masivo de contraseñas del usuario hotline para todos los dominos de Sigfrid/Nexttdirector]”,
            “Titulo_STRING.[Desarrollo FTP en NexttPOS]”
          ]
        });
        scope.pivot.setFilter(“Cliente_STRING”,
        {
          “members”: [
            “Cliente_STRING.[NEXTT]”
          ]
        });

 
Error:
 
attached file error1.PNG
 

Attachments:
error1.PNG

11 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 17, 2022

Hello, Ferran!
 
Thank you for contacting us.
 
Kindly note that this warning message can appear when Flexmonster cannot find the field with a value from the tuple. 
 
In such cases, we suggest following the next steps:

  1. Configure all necessary filters using Flexmonster UI.
  2. Save the report.
  3. Open the report file in a text editor(e.g., Notebook or Notepad) and check out how filters are stored in the report.

 
We have also prepared the example using tuples in filters: https://jsfiddle.net/flexmonster/szunokqj/.
 
Hope it helps. Feel free to ask if any further questions arise.
 
Regards,
Solomiia

Public
Ferran Lopez May 17, 2022

Hello,
The steps you mention are the ones I have done. But the problem is that when loading the generated filters (by API or in a constructor) the warning appears and it doesn’t perform the filtering correctly.
 
Thanks

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 17, 2022

Hello, Ferran!
 
Thank you for your quick response.
 
Could you modify our JSFiddle example with your sample data to make the issue reproducible: https://jsfiddle.net/flexmonster/szunokqj/.

It would help us to continue the investigation.
 
Looking forward to your response.
 
Regards,
Solomiia

Public
Ferran Lopez May 20, 2022

Hello,
 
I modify JSFiddle example:
https://jsfiddle.net/flexmonster/szunokqj/
 
The error also occurs in this example.
 
Thanks

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 20, 2022

Hello, Ferran!

Thank you for your response.

Could you please check that you provide us with the correct JSFiddle link?

Looking forward to hearing from you.

Regards,
Solomiia

Public
Ferran Lopez May 23, 2022

Hello,
Sorry but it didn’t record correctly. Now I just re-uploaded the example.
Thanks

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 23, 2022

Hello, Ferran!
 
Thank you for your response.
 
We kindly suggest a short guide on using JSFiddle:

  1. Open our example: https://jsfiddle.net/flexmonster/szunokqj/.
  2. Click Fork at the top navigation bar – it should copy the example code but change its URL.
  3. Modify the sample to reproduce discussed behavior.
  4. Click Save.
  5. Copy and send us the link.

 
Looking forward to your response.
 
Regards,
Solomiia

Public
Ferran Lopez May 24, 2022

Hello,
 
the new link https://jsfiddle.net/akf6v71p/
 
Thanks

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 24, 2022

Hello, Ferran!
 
Thank you for the detailed sample.
 
We have reviewed your JSFiddle and have several comments:

  1. We have noticed extra question marks “?” at the end of the members’ names, e.g. “Cliente_STRING.[NEXTT?]” instead of “Cliente_STRING.[NEXTT]”
    When filtering by members, values in [] brackets should exactly match the values from the data source. The extra character at the end changes the value, so Flexmonster can’t find it in the original data and shows the warning message.
  2. If the member is not present in the data but is present in the filter, this warning will be shown as well, as in your example with member “Titulo_STRING.[Añadir hora en Informe ND Cancelaciones / Productos]”.

 
Please check out the fixed example: https://jsfiddle.net/flexmonster/8Lr4goda/.
 
To make sure that filters are configured correctly, we recommend:

  1. Configure all necessary filters using Flexmonster UI.
  2. Save the report.
  3. Open the report file in a text editor(e.g., Notebook or Notepad) and find the already configured filter object, which can be copied to any other report.

 
Hope it helps. Looking forward to your response.
 
Regards, 
Solomiia

Public
Ferran Lopez May 24, 2022

Hi,
I have removed the character “?” and the filters are still not working
In exemple https://jsfiddle.net/flexmonster/8Lr4goda/ exist a row with value “Activación informes de nexttDIRECTOR” in column “Titulo_STRING”. Exist a filter:
“filter”:{
    “members”:[
        “Titulo_STRING.[Activación informes de nexttDIRECTOR]”,
        “Titulo_STRING.[Añadir el filtro de clientes ´obsoletos´ en la consulta Servicios A3 – Locales Sigfrid (Incorrectos)]”,
        “Titulo_STRING.[Añadir hora en Informe ND Cancelaciones / Productos]”,
        “Titulo_STRING.[Cambio masivo de contraseñas del usuario hotline para todos los dominos de Sigfrid/Nexttdirector]”,
        “Titulo_STRING.[Consulta listado proveedores]”,
        “Titulo_STRING.[Desarrollo FTP en NexttPOS]”
]
 

This record doesn’t appear in the filtered list. The filter does appear selected when displaying the filters in the column “TITULO”.
It doesn’t work correctly.
 
Thanks

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 25, 2022

Hello, Ferran!
 
Thank you for your quick response.
 
Kindly note that in the example https://jsfiddle.net/flexmonster/8Lr4goda/ there are two filters – for ‘Titulo_STRING’ and ‘Cliente_STRING’.
If we remove the second filter, we can see that the “Activación informes de nexttDIRECTOR” is present on the grid: https://jsfiddle.net/flexmonster/gzf8Lb1a/.
As we can see, the required ‘Titulo_STRING’ value is returned by the filter, but in the first example, it couldn’t be seen because of the second applied filter.

You can find more details about filtering in our docs: https://www.flexmonster.com/api/filter-object/.

We hope it helps. Feel free to contact us in case of any questions.
 
Regards,
Solomiia

Please login or Register to Submit Answer