I have an InfoPath form which connected to SharePoint to create an external content type. I want to be able to query my SharePoint List/Library. I know I can use the queryFields to set certain fields equals to a certain value, but is there a way to apply custom queries to secondary data sources which are connected to SharePoint Lists/Libraries? I need to be able to implement more advanced conditions such as if a field contains a certain value or if something is greater than something else.
I came across this article (http://support.microsoft.com/kb/826992) about using wildcard characters when quering SQL or Access Databases but I havent been able to able this to my situation yet.
Thank you, in advance.
EDIT: The reason why i need this custom query is because I need to apply multiple criterias (1. location, 2. datetime, 3. screens). Screens is contained in a repeating field, but I havent been able to figure out how to apply a filter on it yet.