2. PHPRunner General questions
  3. Parameterizing Table Views, etc.
This topic is locked

Parameterizing Table Views, etc.

 		6/15/2009 8:17:42 PM
PHPRunner General questions
K
 kenlyle author

The Open Source survey application LimeSurvey has a structure where there are these tables relevant to a given survey:

  • Lime Surveys
  • Lime Tokens 1135
  • Lime Survey 1135
    In the first table, there is one record where owner_id field of the record is equal to the user_id of the current user. By editing that record, the Title can be modified, an expiration date can be set, or the survey can be deactivated immediately.
    The sid (survey id) is the number that can be appended to "LimeTokens" and "LimeSurvey" to deduce to which tables the user should have access.
    PHPR, of course, has no way of anticipating that there would be such a pattern, and generates the same files for every table.
    How would I go about parameterizing a set of these files so that I don't have to regenerate the application and manually update the security, every time I add a new survey?
    Thanks,

    Ken
J
 		Jane 6/16/2009

Ken,
I suppose you need to use User can see and edit their own records only security method on the Advanced security settings dialog on the Visual Editor tab.