Tareas #145: Add enteje association with TT1T_CODATR_EE_VALATR - Selene J2EE Webapp - Redmine

Actions

Copy link

Tareas #145

closed

Selene Wrapper - Errores #133: Extract enteje from Tabla

Add enteje association with TT1T_CODATR_EE_VALATR

Added by Jesús Freire about 7 years ago. Updated almost 7 years ago.

Status:

Cerrada

Priority:

Normal

Assignee:

Jesús Freire

Target version:

0.0.2

Start date:

05/09/2018

Due date:

06/28/2018

% Done:

100%

Estimated time:

3:00 h

Spent time:

1:15 h

Puntos de historia:

Description

Pattern DatosLogicos has changed to take enteje from parameters, so it's neccesary to make an association between the field enteje of the key TT1T_CODATR_EE_VALATR and the field enteje in each class that uses this key.
For example, AFApunte uses this key to take the field DENOMT for the description of several code fields, as the Participante's description.
Extract a list of Objeto instances that use the key TT1T_CODATR_EE_VALATR and make an association with the field enteje for each one

Actions

Copy link

Updated by Jesús Freire about 7 years ago

Project changed from Selene Wrapper to Selene J2EE Webapp
Target version deleted (~~0.0.7~~)

Actions

Copy link

Updated by Jesús Freire almost 7 years ago

% Done changed from 10 to 20
Translation missing: en.field_sprint changed from 53 to 52

Actions

Copy link

Updated by Jesús Freire almost 7 years ago

Project changed from Selene J2EE Webapp to Selene Wrapper
Translation missing: en.field_sprint deleted (52)

Actions

Copy link

Updated by Jesús Freire almost 7 years ago

Target version set to 0.0.8

Actions

Copy link

Updated by Jesús Freire almost 7 years ago

Translation missing: en.field_sprint set to 21

Actions

Copy link

Updated by Jesús Freire almost 7 years ago

Status changed from Nueva to En curso
Assignee set to Jesús Freire
% Done changed from 20 to 30

Actions

Copy link

Updated by Jesús Freire almost 7 years ago

Design classes with enteje that use TT1T:

select vaclob from atcl where codatr='ENTEJE' and coi
ob='00000053' and subcla='CD' and vaclob in (select coobme
rom objm where coinob in (select coobpa from objm where tio
me='AF' and coobme in (select distinct src.vaclob from atat
 atcl src, atcl dst where coina1=src.coinat and coina2=dst.
oinat and src.coinob='00000053' and src.subcla='AF' and dst
coinob='00000053' and dst.subcla='CL' and dst.vaclob='TT1T_
ODATR_EE_VALATR')));

Result:
CUEN
APUN
ACPR
ROLP

Áreas de fachada that use TT1T:

select distinct src.vaclob from atat, atcl src, atcl
st where coina1=src.coinat and coina2=dst.coinat and src.co
nob='00000053' and src.subcla='AF' and dst.coinob='00000053
 and dst.subcla='CL' and dst.vaclob='TT1T_CODATR_EE_VALATR';

Result:
AFCuentaCuenta
AFActorPrograma
AFTercero
AFParticipante
AFCuenta
AFNota
AFFichero
AFObjeto
AFApunte
AFObjetoObjeto
AFApunteApunte
AFRolParticipante

Actions

Copy link