Bug #1049
closed
need XML uploader to work with Usage as child of Status
Added by Michael Lee over 21 years ago.
Updated about 18 years ago.
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.
Implementation field, this has been added for ease of getting at status from usage
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
This denormalized field is of lesser importance that other urgent bugs.
This can be taken care of with the updated plant/comm. add features.
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
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.
need concept and party as implementation fields filled in from usage values
where null.
moved the usage loops within the status loops et voila!
Original Bugzilla ID was 1049
Also available in: Atom
PDF