Bug #1049
closedneed XML uploader to work with Usage as child of Status
0%
Description
This is a 2.0.0 bug, though for the short time, and also perhaps longer term, I
do have an easier solution: add commUsage.commStatus_ID as a field, but don't
take away commParty_ID or commConcept_ID. It will simply be a different way of
looking up the concept, party, and status. If you want the concept, grab it, if
you want the status, grab it. This is not ideal design, but it will allow us to
grab statuses, which has become even more important now that level and parent
reside there. For now, I place this bug as 1.0.1 for simply adding the new
field and 2.0.0 for refactoring it and removing plantUsage.plantConcept_ID and
plantUsage.plantParty_ID.
Related issues
Updated by Michael Lee about 21 years ago
Implementation field, this has been added for ease of getting at status from usage
Updated by Michael Lee almost 21 years ago
This field has been added with 1.0.2 model. Now we have to be sure that it will
get populated correctly and then queried correctly, where applicable. Now, I
don't think that there are any queries in VegBank that rely on this (VegBranch
does). But we will need to populate this field upon plant/comm loading.
this field= plantUsage.plantStatus_ID and commUsage.commStatus_ID
Updated by Michael Lee over 20 years ago
This denormalized field is of lesser importance that other urgent bugs.
Updated by P. Anderson over 20 years ago
This can be taken care of with the updated plant/comm. add features.
Updated by Michael Lee about 20 years ago
Need to ensure this gets done on VegBank db and in VegBranch when adding new
plants/comms. Any addition of plants and comms through website functionaility
will need to include handling this aspect. Specifically
plantUsage.plantStatus_ID and commUsage.commStatus_ID need to be populated
correctly.
New views of comms and plants include/depend on this feature
Updated by Michael Lee about 20 years ago
VegBranch now supports this fully. usage.concept_ID and usage.party_ID are
moved to implementation fields. Need to sync XML loader with VegBranch update,
which shouldn't be too far away.
Generic views in VegBank also support this link, as does the VegBranch "hot
fixes" button. So we are nearly there. Need to make sure final vegbank2
database has the normalization SQL completed.
Updated by Michael Lee about 20 years ago
need concept and party as implementation fields filled in from usage values
where null.
Updated by P. Anderson almost 20 years ago
moved the usage loops within the status loops et voila!