Skip to main content
Solved

Lobby Datasource supports Sub-Query?

  • Mar 26, 2021 1:42 PM UTC
  • 1 reply
  • 411 views
Sidekick (Customer)
Forum|alt.badge.img+7
  • kwc
  • Sidekick (Customer)

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!

Best answer by anmise

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.

View original
This topic has been closed for replies.

1 reply

Superhero (Employee)
  • anmise
  • Superhero (Employee)
  • Answer
  • Mar 27, 2021 7:41 AM UTC

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.

Terms & ConditionsAccessibility statement