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?