Lobby Datasource supports Sub-Query?

kwc wrote:

Hi,

 

I am unable to get columns from a View created using sub-query.

Anyone knows if this is supported or if I am doing anything wrong?

 

 

Thanks in advance!

Creating a view would normally be done as a modification and installed through a delivery. I believe you’d have to refresh the dictionary cache in order to see the columns in the data source designer (I’m not 100% sure it will do the trick). If you are using an IAL, the columns will not be visible in the column selector, but you can enter them manually and the data source will still work. Might be the same for a custom view.