Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Add variablealpha/dh-list-variabledefinition/all/ComplianceUpdate webform map to set date_received as timeseries recordCreate events for all previously entered dates stored as a field(see Code 1)Verify that only compliance events are stored in this field- Delete old field
Update compliance history viewMigrate variables to beta, liveMigrate views to beta, live- 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
Comment | File | Size | Author |
---|---|---|---|
Compliance Module #4 Edit Informal Correction page.pdf | 1.77 MB | pahiggins |
Comments
Comment #2
pahiggins CreditAttribution: pahiggins commentedComment #3
jkleiner CreditAttribution: jkleiner commentedComment #4
c_thomas CreditAttribution: c_thomas commentedOn #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
Comment #5
robertwb CreditAttribution: robertwb commentedCurt - I'll take this one since it is an edit form data misconfiguration that is causing the edit part of this.
Comment #6
robertwb CreditAttribution: robertwb commentedComment #7
robertwb CreditAttribution: robertwb commentedComment #8
robertwb CreditAttribution: robertwb commentedComment #9
robertwb CreditAttribution: robertwb commentedComment #10
robertwb CreditAttribution: robertwb commentedI 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.
Comment #11
robertwb CreditAttribution: robertwb commentedComment #12
c_thomas CreditAttribution: c_thomas commented