Complex Table Filter and remove dublicates

[Former Member]

Hey all,

I am trying to implement a custom complex table.

as i have a record like below; ı do want to show the values to the user with remove dublicates. As you see that, the line  1 - 2 -3 and 4 are identical and 5 -6 and 7 are idendical too.

How can i remove those identical vaues in a complex table.

Regards,

Indx	F1	F2	F3	F4
1	ABC	01	01	GBB
2	ABC	01	01	GBB
3	ABC	01	01	GBB
4	ABC	01	01	GBB
5	ABC	01	02	KMD
6	ABC	01	02	KMD
7	ABC	01	02	KMD
8	ABC	03	02	DND
9	XYZ	01	01	GBB
10	XYZ	01	01	GBB
11	XYZ	01	01	GBB
12	XYZ	01	01	GBB
13	XYZ	01	02	KMD
14	XYZ	01	02	KMD
15	XYZ	01	02	KMD
16	XYZ	02	01	FDS
17	QWR	01	01	GBB
18	QWR	01	01	GBB
19	QWR	01	01	GBB
20	QWR	01	01	GBB
21	QWR	01	02	KMD
22	QWR	01	02	KMD
23	QWR	01	02	KMD
24	QWR	03	02	DND
25	QWR	03	02	DND
26	ASD	01	01	ABS
27	ASD	01	02	ABS
28	ASD	01	03	OTR
29	ASD	01	04	RBS
30	ASD	02	01	OTR

[Former Member]

Hello Adem,

In Java while setting the index, please concatenate F1,F2,F3 and F4. which will not set the values which are identical. Then in Agentry you will not be able to see all duplicate values.

Hope this makes you clear

Thanks

Ajitesh

[Former Member]

Hello Upadhyaya,

Thank you for your answer.

I did as you said. I have two conconated value, first one is F1 - F2 and F3 and second one is F1 F2 F3 and F4 but the thing is i have two input that based on this complex table. Regarding the data of above example, the first input should only show(F1 + F2 + F3); 01,02,03,04 and the second input should show(F1 + F2 + F3 + F4) GMD, KMD, ...., OTR.

The index of second input is the conconacated field of F1+F2+F3+F4 and it works ok.

The index of first input is the conconacated field of F1+F2+F3 but still shows dublicated value.

Those two index has  no parent index.

I hope, i tell myself clear.

Regards,

Adem

[Former Member]

Adem,

In Agentry the the primary key should be unique. you have to make sure while setting the property value in Java for Key property is unique. for that you can concatenate any number of column.

May i know what do you want to display for first input?

i think you can still use same index for the first input. while displaying the selected row you can write a rule to filter out that record from complex table.

Hope this makes you clear

Thanks

Ajitesh

[Former Member]

Hello Upadhyaya,

For the first input, I want to display the value of F3 without dublicated values.

[Former Member]

Have a Index on F3, with a Parent of F2.  Then on the F2 have a parent of F1.

Then on the field have a parent rule of

CONCATENATE  (String function)

- F2

- NEWLINE (String Function)

- F1

[Former Member]

Hello Stephen,

I understand like this,

Create index of F1 with no parent, lets say F1Index, then create one more F2Index with parent of F1ındex then  create F3 index with parent of F2Index.

Do i have Index of Indx which is the only unique value in complex table.

Regards,

Adem

[Former Member]

The first index that is created will become the primary index and this needs to be the unique row.

As a lot of the fields are close to the same name, I would say create a new field that has all the current fields  concatenate together (F1+F2+F3+F4) and use that as the unique index.

[Former Member]

Hep  Streeter

I did as you said but still same  the value is came with dublicated by the way i use complex table with search.

[bill_froelich]

What control type are you using, Complex Table search?  If you are trying to remove duplicate when selecting a row what id are you looking to return?

--Bill