I'm using Views merge rows to grouping rows by some fields, It worked good for me, but in some fields I want to show just the first filled value that means: merge uniques values+use the first value.
View after using VMR
Is there a way to do that using views merge rows? or I have to use an other solution?
Or how I can hide/remove rows which have cycle smaller than the max cycle value for every every container -see the image above-? I couldn't do it with views filter.
I'll explain my use case below to show the purpose of creating this view:
The objective was tracking the containers, so I have to show containers and there currents and previous places.
The container pass by a number of positions (in depot, at port of delivery, at port of loading...) until being in the vessel( position: on board), or it can be in an exceptional position like "reformed". I called the passage through those positions from the start to the end a "cycle"
If the container is on board we have to fill all information about previous positions in a form "bill of lading".
What I did as solution, I created 3 content type : container,position,bill of lading.
The position content type reference the container and contains a select list field "position container" and 10 field collection field, every field collection contains a specifics fields for a single position.
So for every node position, I fill the field container, I select "position container" , I fill the field collection fields corresponding to the position selected. For example if I created a new position for the container "blk001" in position "in depot", I fill the field collection fields "name depot" and "date in depot".
For the bill of lading content type it reference the containers also, I redirect to it every time the node position is saved and "position container" is "on board".
Now the challenge is providing a list of containers,with the current bill of lading "N° B/L", the current cycle and merging all the positions fields corresponding to this cycle.