Sintaxe ORDER BY and FILTER

[deltai]

Friends,

I'm having trouble improving this expression.
The expression is included in PDF creation.
Only the [NOME_PESSOA] column is referenced.
The expression works correctly, but it does not sort the names in ascending order.
I tried a few times to treat this field, but to no avail.

<<Start: ORDERBY(FILTER(“DB_CHAMADA”,
                                                     AND( ([ID_DATA_CHAMADA]=[_THISROW].[ID_DATA_CHAMADA]),
                                                              ([PRESENCA]=”SIM”)
                                                     )
                                                ),
                                  [NOME_PESSOA], TRUE,
                                  [PRESENCA], ([PRESENCA]=”SIM”)
                  )>><<[NOME_PESSOA].[NOME_PESSOA]>>

[TeeSee1 · Accepted solution]

ORDERBY uses [NOME_PESSOA] key values. Use [NOME_PESSOA].[NOME_PESSOA] instead.

Also I am not sure [PRESENCA], ([PRESENCA]=”SIM” actually does. Do you need it??

[TeeSee1 · Accepted solution]

ORDERBY uses [NOME_PESSOA] key values. Use [NOME_PESSOA].[NOME_PESSOA] instead.

Also I am not sure [PRESENCA], ([PRESENCA]=”SIM” actually does. Do you need it??

[deltai]

Hello,

Thanks for your solution.

How i dont see my mistake? Rrrrrr

Please, let me make other question about this PDF: How to do download this file directly in smartphone after bot works?

[TeeSee1]

AFIK, you cannot do that. You either send it attached to email or send the link so the person can download it manually.

[deltai · Accepted solution]

Right,

I do this creating field PDF and include the PATH. Its works for me.

Thanks

[Landan_QREW]

The second parameter of orderby() is descending? and expects a TRUE/FALSE value, but it is false by default. If you want ASC, I think you want a FALSE there.

ORDERBY(FILTER(“DB_CHAMADA”,
                                                     AND( ([ID_DATA_CHAMADA]=[_THISROW].[ID_DATA_CHAMADA]),
                                                              ([PRESENCA]=”SIM”)
                                                     )
                                                ),
                                  [NOME_PESSOA], FALSE,
                                  [PRESENCA], ([PRESENCA]=”SIM”)
                  )