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?