11-02-2017 03:01 AM
I would like to check whether can we hide the columns in VA?
Even developer should not see these columns data (Like descriptive columns(name , address, phone , city))
developer can generate the report by using id, age,salary,married status,education and he drag the other columns (name,address,phone,city) but should not see the data.
once developer generate the report then the report will go to admin, then admins decision whether he can give access to end-user should see this information or not from this report. If admin approves then end-user can see the report.
Its customized specific type of report. where as it not like normal report where we generate the report and giving particular user access to see it.
here admin who approves the specific columns permission to the end-user.
something new which we do in
11-02-2017 11:40 PM
you need to mask the development data before giving it to the developers ... VA can do row level security to hide some rows but in your case you need to hide some columns and thus VA can't do column level security it will never hide any columns from users ..
11-04-2017 09:28 AM
it depends case to case .. if you just want to hide names and contact details .. you can replace the originals with either nulls or junk data .. search online or contact your data management team ..
11-04-2017 02:01 PM
as already mentioned, hiding columns is not yet supported.
In stead of using different columns, you could add some Demo records to the database with a clear marked key.
For developer you only allow data access to these record. (So the reports is already ok for use)
If the admin agrees, he just has to allow the Actual planned users to read the real data. (excluding the Demo records)
This might solve your problem easily.