Skip to main content
July 15, 2022
Question

Export Data Store Entity to Excel Cannot query because field is a child of a multiple data type

  • July 15, 2022
  • 1 reply
  • 0 views

Hi,

I'm trying to export the Read-only Grid

I have this issue due the "ID" is the child of "Q". I know the limitation of selection and Column.

Export Data Store Entity to Excel Either selection or filters are invalid: Cannot query [Q.ID] because [ID] is a child of a multiple data type.

I was wondering if you have any solution to work round this?

Thanks

1 reply

mikes0011
Brainy
July 15, 2022

Create a view that flattens the data per however you will require in your exported Excel file; create a new CDT and DSE referencing that view, and invoke that DSE in your node.

The Expression Guru