Using custom variables in "From" of Dataview

[Dmitri]

Could you please help me how can I use custom variable in Dataview. I have the following variable that contains a path to the folder:

VideoSeriesPath::“XXX/YYY”

I would like to use it in Dataview in FROM clause something like this but receive an error

TABLE 	
	without ID link(file.link, name) as Video,	
	Topics,
	…
FROM this.VideoSeriesPath

[cheezopath]

one workaround is to use dataviewjs and pass dv.execute() your dataview query as a string, with the variable concatenated into the FROM
https://blacksmithgu.github.io/obsidian-dataview/api/code-reference/#dvexecutesource