Problem/Motivation

1. "Date received" is coming from action date (another screen) which is garble.
2. We need to see Milestone Sub-Type and Action - now it says action but is actually "Sub-type"

Ex: dh/?q=admin/content/dh_adminreg_feature/manage/194143

Proposed resolution

Convert Action Date to timeseries record.

Remaining tasks

  1. Add variable alpha/dh-list-variabledefinition/all/Compliance
  2. Update webform map to set date_received as timeseries record
  3. Create events for all previously entered dates stored as a field (see Code 1)
  4. Verify that only compliance events are stored in this field
  5. Delete old field
  6. Update compliance history view
  7. Migrate variables to beta, live
  8. Migrate views to beta, live
  9. Migrate webform mapping (update module)

Code 1: SQL to insert data from date_completed field to timeseries.

insert into dh_timeseries (featureid, entity_type, varid, tstime, tsvalue, utcoffset) 
select a.entity_id, 'dh_adminreg_feature', b.hydroid, a.date_received_value, null, 0 
from field_data_date_received as a, dh_variabledefinition as b
where b.varkey = 'compliance_action_date'
;

User interface changes

n/a

API changes

Data model changes

Compliance milestones action date stored as a timeseries

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

pahiggins created an issue. See original summary.

pahiggins’s picture

Title: Compliance #4 "Edit Informal Correction" module/page » Compliance -Cannot read milestone action date or sub-type
Issue summary: View changes
jkleiner’s picture

Assigned: Unassigned » c_thomas
c_thomas’s picture

On #2, I corrected the Compliance views to display both the Milestone Sub-Type and Action.

#1 will need more checking. It looks like the "Date Received" data is being stored in the Date Received field for the Milestone bundle. This is stored in the "Text Field" widget and is an "Integer" field type. That looks to be the problem, that it is not actually a date field. The data coming in is stored as the timestamp, so presumably we could convert them to the actual date and make the Date Received a "Date" widget.
Milestone AR Feature:beta/?q=admin/structure/dh_adminreg_feature_type/manage/milestone/fields
Example Milestone: alpha/?q=admin/content/dh_adminreg_feature/manage/193095

robertwb’s picture

Assigned: c_thomas » robertwb

Curt - I'll take this one since it is an edit form data misconfiguration that is causing the edit part of this.

robertwb’s picture

Issue summary: View changes
robertwb’s picture

Issue summary: View changes
robertwb’s picture

Issue summary: View changes
robertwb’s picture

Issue summary: View changes
robertwb’s picture

Issue summary: View changes
Status: Active » Needs review

I believe that this is all wrapped up and migrated to the live system. Patti - if you could verify that the behavior is as expected that would be great.

robertwb’s picture

Status: Needs review » Closed (fixed)
c_thomas’s picture

Issue summary: View changes