Row Filter

[Fabio_T]

I would like to add an additional filter that excludes the results based on the type of business or domestico customer

1° table
Ordini

Columns
ID_Ordine
ID_Cliente
Tipologia_Cliente
ID_Piani_Telefonia // in valid_if insert
ORDERBY(
FILTER(
"Piani_Telefonia",
AND(
[ID_Piani_Telefonia].[ID_Operatore_Telefonia]=[_THISROW].[ID_Operatore_Telefonia],
[Valido]=SI)),
[Nome_Piano],FALSE)

2° Table

Columns
ID_Piani_Telefonia
ID_Operatore_Telefonia
Nome_Piano
Valido
Tipologia

[Suvrutt_Gurjar]

@Fabio_T wrote:

I would like to add an additional filter that excludes the results based on the type of business or domestico customer

Your exact requirement is not clear.

If you wish to filter at record level depending on the type of customers, then you may need to use the FILTER() expression in the slice. 

Functions of other columns used in the expression are not clear.

Also you have used [_THISROW].[ID_Operatore_Telefonia] in expression but that column does not seem to be available in the Order table.

Please elaborate.

---

---

, you need to use the 

[Fabio_T]

To each plan_telefony I have given a business or domestic value, I filter the plans according to the operator and I would like to filter them according to the type of customer to whom I assign the order.
to give an example luca rossi domestic customer I would like the filter to propose are plans_domestic telephony and to a business customer only business plans

[Suvrutt_Gurjar]

Could you respond on this query as well please/

---

@Suvrutt_Gurjar wrote:

Also you have used [_THISROW].[ID_Operatore_Telefonia] in expression but that column does not seem to be available in the Order table.

---

[Fabio_T]

this is table

[Suvrutt_Gurjar]

May we know what problem you are facing with your current expression?

[Fabio_T]

I select the customer then add the order by clicking on nuovo

now I select tipologia contratto telefonia then toperatore telefonia, 

now the results filtered by customer type should appear on telephony plans as I have associated business or domestico with each plan and the same thing I have done for each customer

[Suvrutt_Gurjar]

Please post the screenshots of Order table and please let us know on which table you are creating the "Nuovo" form?

[Fabio_T]

This Is tables

[Suvrutt_Gurjar]

Thank you,

Could you try the below written expression.

ORDERBY(
FILTER(
"Piani_Telefonia",
AND(
[ID_Piani_Telefonia].[ID_Operatore_Telefonia]=[_THISROW].[ID_Operatore_Telefonia], [Piani table Tipologia column]= [_THISROW].[Ordine table Tipologia column], 
[Valido]=SI)),
[Nome_Piano],FALSE)

Please replace Tiplogia column names with the actual column names you have in those tables.

[Fabio_T]

ORDERBY(
FILTER(
"Piani_Telefonia",
AND(
[ID_Piani_Telefonia].[ID_Operatore_Telefonia]=[_THISROW].[ID_Operatore_Telefonia],

([ID_Piani_Telefonia].[Tipologia]=[_THISROW].[Tipologia_cliente]),
[Valido]=SI)),
[Nome_Piano],FALSE)

Note: This expression could impact performance. ORDERBY( ........The list of values of column 'ID_Piani_Telefonia' ........from rows of table 'Piani_Telefonia' ........where this condition is true: (ALL these statements are true: ............1: (The value of 'ID_Operatore_Telefonia' from the row referenced by 'ID_Piani_Telefonia') is equal to (The value of 'ID_Operatore_Telefonia' from the row referenced by 'ID_Ordine') ............2: (The value of 'Tipologia' from the row referenced by 'ID_Piani_Telefonia') is equal to (The value of 'Tipologia_Cliente' from the row referenced by 'ID_Ordine') ............3: (The value of column 'Valido') is equal to ("SI")) ....The value of column 'Nome_Piano' ...."FALSE")

unfortunately I do not exclude the results based on the tipologia

[Suvrutt_Gurjar · Accepted solution]

You seem to have used a n incorrect column name in the expression for the Tipologia column in the "Piani_Telefonia".

You seem to have used the name as only [Tipologia] whereas the screenshot you shared of the table shows the name as [Tipologia_Piano_Telefonica] or soemthing similar as the entire name is not visible in the screenshot.

[Fabio_T]

top as always, I got the column name wrong 😞