Filter fileds in a table by groups or a user

This topic is locked

Filter fileds in a table by groups or a user	11/2/2009 3:08:48 PM
ASPRunnerPro General questions
T telemark author Is it possible to view certain fields within a table in list view depending on the group a user belongs too or one particular user. I want to remove one field from users and have the field visible for admin. or depending what's easier To restrict certain entries inside a field depending on groups or one user. eg the filed is a list of values OPEN, HOLD and CLOSED. Can admin group select all entries and normal users only select OPEN and HOLD. I just require a pointer with the easiest solution, then hopefuly I can work out the rest. Thanks in advance Andy B


J	Jane 11/3/2009
	Andy, I recommend you to create custom view for users on the Datasource tables tab. Then edit SQL query for this view on the Edit SQL query tab: `select field1, field2, ... from Tablename where field_status<>'CLOSED'` Then assign corresponding permissions for this view and main table on the Security tab.