Read-only grid in interface is not updating

I made some changes in my interface through the Edit List function but when I save changes and update the interface, this changes do not apply to the read-only grid. I tried to eliminate this read-only grid and add it again and this way the changes were applied. 

Example of the changes and the interface are the following:

The changes to apply in the interface are the following:

And the interface remains unchanged (notice the "€" sign is not applied):

Does anyone know any other (less sophisticated and destructive) way to update the read-only grid and directly apply new changes?

Thanks! 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    To me, it is pretty much unclear what you did. Could you explain your first sentence in more detail?

  • I just added the "a!currency" expression to add the "€" sing following the values in the "Importe" column.

    a!gridColumn(
      label: "Importe",
      sortField: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe',
      value: a!currency(
        isoCode: "EUR",
        indicatorAlignment: "END",
        value: if(
          isnull(
            fv!row['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe']
          ),
          fv!row['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'],
          fixed(
            fv!row['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'],
            2
          )
        )
      ),
      align: "END"
    )

    That was the only change I made.

  • 0
    Certified Lead Developer
    in reply to xabieruranga

    Do you have a specific reason to use fixed()? It turns that decimal value into a string. Depending on your locale, it uses a comma as the separator which the currency() function then will have a hard time to cast back into a decimal.

    Could that be the problem?

  • I think it is more a synchronization issue. The fixed() expression is working correctly because it is showing the "€" sign in the edit list view. However, when you switch to read-only grid in the interface it doesn't update.

    Also, when I delete the read-only grid completely and create it again from scratch, then it does show the new changes. This is why I think it is a synchronization problem. I am looking for a way to update the read-only grid without having to delete it completely. 

Reply
  • I think it is more a synchronization issue. The fixed() expression is working correctly because it is showing the "€" sign in the edit list view. However, when you switch to read-only grid in the interface it doesn't update.

    Also, when I delete the read-only grid completely and create it again from scratch, then it does show the new changes. This is why I think it is a synchronization problem. I am looking for a way to update the read-only grid without having to delete it completely. 

Children
  • 0
    Certified Lead Developer
    in reply to xabieruranga

    Can you explain what "switch to read-only grid in the interface" means an what update you expect?

    Then, what is "when I delete the read-only grid completely and create it again from scratch, then it does show the new changes" and which changes do you see?

    Sorry for the questions, but I really have a hard time understanding what is going on. And I want to avoid giving tips based in too many assumptions.

  • My steps were the following:

    1) I Opened edit record list to include my changes in a column:

    2) I included the following code to show the "€" sign next to the values in the column "importe".

    a!gridColumn(
      label: "Importe",
      sortField: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe',
      value: a!currency(
        isoCode: "EUR",
        indicatorAlignment: "END",
        value: if(
          isnull(
            fv!row['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe']
          ),
          fv!row['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'],
          fixed(
            fv!row['recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{beb59a89-a332-46d3-b718-a8285f58f942}Importe'],
            2
          )
        )
      ),
      align: "END"
    )

    3) The changes are applied correctly and now I can view my changes:

    4) The problem is now, when I open the interface corresponding to that record, my changes are not shown and the view is the following:

    Notice the column "importe" is not showing the same in the edit record list view and the read-only grid in the interface.

  • 0
    Certified Lead Developer
    in reply to xabieruranga

    Got it. The issue here is that when you put a read only grid onto an interface, it copies the columns configuration from the record list config. But it does not update that later on.