Skip to Content
0
Former Member
Nov 04, 2008 at 03:55 PM

Multimapping N:N (Node functions)

15 Views

Hello,

My problem is structure resultset mapping to rows (header - details).

If details is ("emplty" o "null" o "") not register.

If details not is ("emplty" o "null" o "") register.

Structure SOURCE.

Resulset

ROW (0..outbound)

-ID (Identificador)

-HEADER

-A_ID_ITEM1

-A_NAME1

-B_ID_ITEM2

-B_NAME2

Example

Title ID ;HEADER;A_ID_ITEM1;A_NAME1;B_ID_ITEM2;B_NAME2

row1 ID1 ;xxxx ; ; ;1 ;A

row2 ID1 ;xxxx ;2 ;B ; ;

row3 ID2 ;yyyy ; ; ;1 ;X

row4 ID2 ;yyyy ; ; ;2 ;Y

row5 ID2 ;yyyy ;3 ;Z ; ;

Structure TARGET

ROW (0..outbound)

HEADER (1..1)

-HEADER

ITEMS1 (0..outbound)

-A_ID_ITEM1

-A_NAME1

ITEMS2 (0..outbound)

-B_ID_ITEM2

-B_NAME2

Example.

ROW (1)

HEADER (1)

ITEMS2(1)

B_ID_ITEM2(1)

B_NAME2(A)

ITEMS2(2)

A_ID_ITEM1(2)

A_NAME1(B)

ROW (2)

HEADER (1)

ITEMS2(1)

B_ID_ITEM2(1)

B_NAME2(X)

ITEMS2(2)

B_ID_ITEM2(2)

B_NAME2(Y)

ITEMS2(2)

A_ID_ITEM1(3)

A_NAME1(Z)

Atte. Claudio Leó