AnsweredAssumed Answered

Creating a layout from filtered result

Question asked by csanad on Nov 20, 2017
Latest reply on Nov 20, 2017 by philmodjunk


I am relatively new to FM, so I apologize if my question is dumb.


I have a table for Companies with 20+ thousand records. I've got a field called businessUnitnumber, this identifies who in the sales team responsible for the given company.

I would like to create a layout which only displays companies with certain businessUnitnumber (like companies where the businessUnitnumber is 1100 or 2889 or 2018).


I would use this layout with the FileMaker Web Publishing engine, so I can import to our web platform. The importer API call would look like: http://xxxx//fmi/xml/fmresultset.xml?-db=co_&-lay=Companies_Integration-findall.


Could you point me how to create a layout which returning only the requested result?