1 Reply Latest reply on Apr 27, 2016 2:53 AM by keywords

    I want to group my product report search results by the product ID


      Hi all,


      I am finishing off an API setup with Wordpress and FileMaker whereby the client searches for a product report by ProductID and date range.

      I have completed all of the coding and it all works like a charm using the following on the results (the "xxxxxx" denotes the rest of teh coding in the results not important for this question):

      // display records
        $records = $result->getRecords();
        foreach ($records as $record) {
        // get data
        $productID = $record->getField('pf_Product');
        $date = $record->getField('Date');
      // show data
        echo "Product ID: $productID<br>";
        echo "Date: $date<br/>;


      What I now need to do is take the results and group them by the Product ID as there are cases when they will search by "All Products", how best do I achieve this? I already have the serach part and results showing for all products, but now I just want to group them by ProductID. I would like to do this for all search results.


      Any help would be much appreciated so that I can finish this project off.