InfoPath Dev

 Hi,

We have an InfoPath form library which holds more than 1200 forms, recently we got data connection error which says data connection has exceeded the maximum limit. I'm trying to set up a predefined query to reduce the data, but not sure if it's doable.

Currently we query data using form status, I would like to add some other search criteria which is kind of dynamic, like if current user is an approver or the form creator etc,

If I query multiple times using same data connection, will the last one overwrite the previous query?

Really appreciate any suggestion.  

So, yeah, the data set is updated each time. But you can set more query fields, as long as you are using equivalence (i.e. Status = Submitted and CurrentApprover = userName()). What helped me understand query fields better was dragging the query and data fields onto the form canvas, and adding a button to run the query. Then I could try various things and run the query and see the results.