My requirement is to pull external data to InfoPath form based on a filter (e.g. Name filter) to Acheive this I did below things (I am working on InfoPath 2010, SP 2010)
I have created a BCS to pull data from external sources and I placed a filter to filter the data based on one column (let’s say Name) Here my problem is when I add external list for above External Content Type it is not displaying any data, because the Name filter always sending as null hence no match was found. For me that should work as I specified above.
But when I try to query the external list from InfoPath form, I was unable to send the filter so it is always returning 0 rows.
I even used "External Item Picker" to pull the data, at this point I am able to filter the data but I am unable to get all other column values (There other columns in ECT like Status, Address etc) it is only checking for existence of the entered value which is not enough in my case.
Please suggest me a solution to complete my task