AnsweredAssumed Answered

Subsummary report using php api

Question asked by walterbz on May 28, 2018
Latest reply on May 28, 2018 by Johan Hedman

Hi all,

I have a database with more than 25k records and 2 types of fields: type and author.

When I search a specific type I would like that only the authors with this type are display. Not the complete list but a summary with unique values. In Filemaker Pro I can do this using the subsummary section and sorting.

I can't find a way to do this with the php api.

I tried to perform a web find using the fm layout containing the subsummary, sorting by the subsummary field, but I obtain all the records instead of a summary.

Is there a way to obtain unique values in a field of a set fo records with php or should I put all data in an array and use the php "array_unique" function?
Thanks

Outcomes