cancel
Showing results for 
Search instead for 
Did you mean: 
Nintex Newbie

CAML query to get distinct list items to display in list view in nintex form

Hi All,

I have a 2 SP lists and am trying to display data from 1 SP list in another List Form in Nintex Form using list view control.

Inorder to display the items, from the below list, Cal is the field that will show the count of Val field from the below list items

 

ID  EN   DE   FR   Val   cal
1   EN1  DE1  FR1   1     2
1   EN1  DE1  FR1   1     2
1   EN2  DE2  FR2   2     3
1   EN2  DE2  FR2   2     3
1   EN2  DE2  FR2   2     3
1   EN3  DE3  FR3   3     1
2   EN1  DE1  FR1   1     3
2   EN1  DE1  FR1   1     3
2   EN1  DE1  FR1   1     3
2   EN2  DE2  FR2   2     2
2   EN2  DE2  FR2   2     2
2   EN3  DE3  FR3   3     1

Now in the list view, for ID 1 - 

i should show distinct values based on Val and sort by Cal.

Means result should be as below.

ID  EN   DE   FR   Val   cal
1   EN1  DE1  FR1   1     2
1   EN2  DE2  FR2   2     3
1   EN3  DE3  FR3   3     1

Can you please help how to achieve above functionality?

 

Thanks in advance,

Usha 

Labels: (1)
0 Kudos
Reply