Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Date/time, default values and access

Description

Hi Adrien,

The plugin is pretty useful and our organization can benefit a lot from it. I have few questions and put them altogether for now. If necessary can create separate issues with more details later.

What I try to figure out is

  1. how to put TIMESTAMP as default for new record (like NOW()), and have it editable (preferably through date/time picker) if necessary

  2. how to define non-editable fields (e.g. current user)

  3. how to differentiate per-column access level (e.g. specific fields are not editable by anybody except by admin)

Thank you,
Serge

Environment

None

Observations

None

Requirement Yogi

Activity

Show:

Adrien Ragot (Old account)April 20, 2018 at 10:31 AM

Hi Serguei,

Thank you very much for your evaluation. Unfortunately, the answer for each of your 3 questions is negative:

  1. Concerning the timestamp, you would have to edit the column in the database itself, because it's not possible through Play SQL. You would, in that case, be able to set the field as TIMESTAMP and with a default value, which would be supported by Play SQL, but users would only be able to insert dates with "midnight" for the time.

  2. We don't have column-level permissions.

Sorry for this disappointing answer.

Best regards,
Adrien

Details

Assignee

Reporter

Priority

Requirement Yogi

Created April 20, 2018 at 12:16 AM
Updated October 3, 2019 at 11:10 AM
Configure