I also like to use the current language of the Portal as Parameter in a SQL Datasource. I tried the tipp number 2 (which is realy fancy). But I am not sure how to use a list of object in the in filter of the Datasource, here is my setup in the visual query designer:
APP ------ {"Language": [ {"Name": "de"}] } -------> SQL DataSource
Entity Language
is passed as Filter
In-Stream of the SQL Datasource. But how do I get only the first object in the token language?
[In:Filter:Language:Name] is not working and [In:Filter:Language[0]:Name] breaks the query completely. Thanks for your help.