Hello,
I am trying to find a way to add a variable to an acx file. I have two duplicate database views, one that contains information that requires specialized access and one that does not. Both views have the exact same metadata for fields; however, one just contains additional data that the user has to have permission to access. Currently we have the two views set up on different app directories, so that if someone has access to the restricted view, that directory is higher in their application path than the standard baseapp directory. This works great as the same fex can be run with someone who has access and someone who doesn’t and give the correct data for each person as the view names remain the same. The problem occurs when someone is granted access to some of the views requiring additional permission, but not all. Since their app path contains the restricted directory, if they run a fex that includes another view that they don’t have permission for, they get an SQL error that they do not have select access on the database view, rather than be pointed to the non-restricted view.

We have to maintain the access permissions on both webfocus and the underlying database. I would like to create a user variable that would point the user to the correct app path or database view per view. This way we would have one acx file per database view set, and depending on the user’s permissions, it would point the webfocus view to the correct database view.

I’m not sure if this is possible, but I would like something like this in the acx file:

  SEGNAME=MYTABLE, TABLENAME=&DATABASE_VIEW, CONNECTION=MY_CONNECTION, KEYS=0, $

or

 
SEGNAME=MYTABLE, TABLENAME=MY_DATABASE_VIEW, CONNECTION= &connection, KEYS=0, $

Is there a way to set variables used in an acx file somewhere/somehow by user? I would appreciate any pointer you may have or suggestions on what to research.

Thank you so much,
Emily

Currently we are on WF 7.6.12 and use Oracle, SQL, and Informix databases.

This message has been edited. Last edited by: Emily Max,

In v7.7.02 and above a feature is available that most likely is what you need: TM4696: Creating and Using a Master File Profile 7.7.02. The master contains an extra attribute to call a fex that can set a global variable, which in turn can be embedded in the acx file.

Unfortunately I don't think it's available in v7.6.12.

Thanks Francis,
That is exactly what I need. I can’t implement it on our current version, but when we update, I’m going be rocking the mfd_profile.