Happy Business Starts Here

Table {0} does not support the ability to filter table data

Rajkumar
Zuora Support

Table {0} does not support the ability to filter table data

Question:

 

Hello,

When trying to group an 'InvoiceItems' table by account name, I'm getting the below error:

Table {0} does not support the ability to filter table data

I am unable to use 'InvoiceItem' as this is already in use somewhere else on the template, forcing me to use 'InvoiceItems'. I've also read on the forums that the 'group by' function can only be done on 'InvoiceItem'. Does that means InvoiceItems will not support the group by function?

If so, can 'InvoiceItems' be used with a nested table?

 

Answer:

 

GroupBy is not supported in InvoiceItems table. "InvoiceItems" is just a simple workaround to duplicate the Invoice item table twice and it doesn't inherit all the features used in the InvoiceItem table.

 

Also, to confirm, GroupBy filter is only supported in "InvoiceItem" table and other objeect tables are not supported yet.

Also, InvoiceItems cannot be used in the Nestedtable and if you use it will result in the below error and the only available tables which support the Nested table is documented in Grouping and Subtotal Functions in Nested Tables.

 

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √