Invalid Table when using a view as DataSource

This question is answered

When I try to drag a View into the dataSource of another view (AOT), it failed.

I get a node with the name of the view followed by "INVALID TABLE".

It is the same thing when I try to add a DataSource manually:
When I set the Table property of the DataSource to the view's name, it changes to UNKNOWN when I'm leaving the Table field.

Is it possible to use a view as a DataSource ?

If so, why do I have this message?

Thanks

 

 

 

Verified Answer
  • The key is to set up your data sources first on a query in the AOT, then use that query in the view.

All Replies
  • A view can be used as a data source within another view.  Have you tried defining a query for the second view in the AOT which uses the first view as one of its data sources, then dragging this query onto the metadata node of the second view?

    The standard DirPartyPostalAddressView in your example is an example of this.

  • Thanks for the reply.

    The problem is that I did not create the second view. it is an AX view.

    Beside, the second view (LogisticsPostalAddressView) is a Query view.

    I don't know if you can test that:

    Create a new view in AOT.

    Drag   LogisticsPostalAddressView (or any view) onto the metadata/data source node of the view.

     

    I must be doing something wrong somewhere.

     

  • The key is to set up your data sources first on a query in the AOT, then use that query in the view.

  • That's a good workaround.

    When I wrap the view inside a Query, I can put it in a datasource.