Views - Show random 2 out of the TOP 10 [#2678260]

Hi all,
I have a content type "Store" that has a field with geographical lat/long. Then I have a view that is showing the Stores sorted by the distance from the current User position (from the most near to the most far).
What I'm trying to achieve is to take the 10 most near Stores, and then shows randomly only 2 of them.
Basically I want to have a block that shows only 2 Stores randomly, but doing the random only among the 10 most near Stores from user's current position.
Is there a way to do it? I tryed everything but no luck.
Thanks in advance!

Comment	File	Size	Author
#4	Screenshot from 2016-03-05 13:52:47.png	4.74 KB	Nikhilesh Gupta
#4	Screenshot from 2016-03-05 13:52:24.png	6.23 KB	Nikhilesh Gupta

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

29 February 2016 at 21:54

drupaljunior created an issue. See original summary.

Comment #2

drupaljunior CreditAttribution: drupaljunior commented 3 March 2016 at 22:28

Any solution for this?

Comment #3

Nikhilesh Gupta CreditAttribution: Nikhilesh Gupta at Melity commented 5 March 2016 at 08:24

Assigned:

Unassigned

» Nikhilesh Gupta

Comment #4

Nikhilesh Gupta CreditAttribution: Nikhilesh Gupta at Melity commented 5 March 2016 at 08:30

File	Size
Screenshot from 2016-03-05 13:52:24.png	6.23 KB
Screenshot from 2016-03-05 13:52:47.png	4.74 KB

@drupaljunior

After achieving the 10 most near Stores, perform the following actions:

1) In the view block for pager select "Display a specified number of items" and specify the items as 2.

2) Next in the sort criteria select "Global: Random" asc/desc.

By this your block can get randomly 2 stores from 10.

Comment #5

drupaljunior CreditAttribution: drupaljunior commented 6 March 2016 at 10:35

Hi Nikhilesh,

To achieve the "10 most near Stores" what I'm doing is:
- Sort Criteria --> Ascending by distance
- Display a specified number of items" = 10

Now how can I make your suggestions described at points 1) and 2) applied on top without overriding the conditions for "10 most near Stores"?

Many Thanks in advance.

Comment #6

Nikhilesh Gupta CreditAttribution: Nikhilesh Gupta as a volunteer and at Melity commented 6 March 2016 at 14:16

This can achieved by passing the output of view as input to another view. You have created a view to get "10 most near stores". Now use this as the input of another view, in that new view you should use sort random and items as 2.

Comment #7

drupaljunior CreditAttribution: drupaljunior commented 7 March 2016 at 18:19

Hi Nikhilesh,

Your explanation is clear from a Query point of view. I simply don't know where to click in view editor.

"This can achieved by passing the output of view as input to another view." - how can I do it?
"Now use this as the input of another view" - how can I do it?

Thanks.

Comment #8

Nikhilesh Gupta CreditAttribution: Nikhilesh Gupta as a volunteer and at Melity commented 10 March 2016 at 06:57

You cannot do this with your view editor. Programatically get the first view by "views_get_view('machine_name')" to a variable, then pass the filters to it. Following is a sample approch

Ex : $view = views_get_view('machine_name');
$view->display['default']->display_options['filters']['field_pay_geolocation_distance']['value']['latitude'] = $latitude_details['latitude'];
$view->set_display('block');
$view->is_cacheable = FALSE;
$view->execute();