In InfoPath I retrieve a data from SQL view with 2000 records, to show a specific fields in the InfoPath form based on the current SharePoint site URL.
I face a performance issue to load all 2000 records when the form open.
I need to filter the data connection based on the current SharePoint site URL during configure SQL data connection in InfoPath. instead of retrieve 2000 record only retrieve a one filtered record!
How can this be done?