Sort search results by field

Hi,

It seems you want to order the results by the keyword rather than searching/filter it. Here is an example of how you can sort your records by keywords:

getRecords([
  ...
  'orderBy' => 'ORDER BY CASE WHEN lamping = ' . $keyword . ' THEN 1 ELSE 0 END'
  ...
]);

Note that you may also want to set allowSearch to false if you want to use url to pass sorting query like this ?lamping=LED.

Let me know if you have any questions.

Thanks,

No. I want to search by keyword, but I want the results to be separated into sections based on the lamping...

Then you can use arrayGroupBy($records, $fieldName, true). This will return an array with the selected field to be the keys and the records to be the values.

Hi,

It sounds like you want the products grouped by lamping type and also the search lamping keyword group (LED) to appear first on the page using this query:
http://www.axislighting.com/CMS/search-led.php?lamping=LED

This would then be followed by other lamping groups (Fluorescent) based on the image you attached?

So if the URL query was this:
http://www.axislighting.com/CMS/search-led.php?lamping=Fluorescentor
or another keyword, would that group appear first followed by other groups?

Any additional details you can provide will help us understand what the end result should be.

Thanks!

I only showed the url as an example of the results I want to achieve. I want the search results to be separated by lamping headers. How do I go about that. Forget the url string...

Hi,

You can use array_groupBy() to get the results separated by a field. Here is an example:

// For $itemsRecords:
$itemsGroupByLamping = array_groupBy($itemsRecords, 'lamping', true);


That will give you an array of records grouped by their "lamping" category. The next thing you need is to loop through them and display:

foreach($itemsGroupByLamping as $category => $records){
 // Display the category.
 foreach($records as $record){
  // Display the record.
 }
}

Hope this helps you to solve the problem. If you need further help feel free to send the details to consulting@interactivetools.com.

Thanks,

ok. Seems like we might have something here. 

http://www.axislighting.com/CMS/search-led.php

However, 2 things. First, some products have more than one image and I only want it to show the first image, currently it is showing all. 

Second, I want to  separate the Lamping by either LED or other... So I need separate headers to show LED first and then FLUORESCENTbeneath it..

Can you help?

https://www.interactivetools.com/forum/forum-posts.php?postNum=2242185&download=led-search.jpg This is how I want it to display.