Hello! I am trying to figure out how to write a pulldata function that has two feature filters, I assume placed in the WHERE clause. I am building a refuse cart solution that tracks cart type (trash, recycle, yardwaste), cart size, cart serial number, etc. in Survey123 Connect (on Enterprise Portal 10.9.1). The original feature class contains three records per property, one record for each cart type, from which I published a feature service to our federated Server. I am using the pulldata @layer workflow and would like to filter on cart_type first, based on the choice in a select_one question, then filter on the address field, thus retrieving that one unique record from the service table. Is this possible to do in one pulldata statement? Any help, example code, workflow, etc. would be appreciated. Many thanks, Jay
