The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years ago

SQL table editor : parametrize the source of data ?

Hello, In the SQL table editor component, we can define namely the Schema Name, Table Name, Table Column Names, Where Clause and Order By Clause : However, I am using a Table that has encr...
Security
db_pdx's avatar
db_pdx
Valued Contributor
2 years ago

This is untested: can you create a SQL View in the background (via a BR), then reference that View in the standard table editor component?  You would likely need to create a custom save function as well since you're now looking at data from a View rather than the raw table.

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years ago

That's something I will definitely test !

I don't know if one can actually change the table name used for saving data, but that would accomodate with the code needed in order to encrypt / decrypt.

I'll keep you posted on that one !