Browser Forms

Re: In Querying Secondary Data Source, can you have an "OR" situation in the query fields?

Hilary Stoupa — Thu, 11 May 2017 14:59:21 GMT

Some links:

https://dev.office.com/sharepoint/docs/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests
http://johnliu.net/blog/2012/4/26/infopath-2010-query-using-the-rest-interface.html
https://channel9.msdn.com/Blogs/donovanf/Infopath-2010-OData-and-Cascading-Filtering-in-Forms

Re: In Querying Secondary Data Source, can you have an "OR" situation in the query fields?

GwenW — Thu, 11 May 2017 13:16:48 GMT

Thanks, Hilary. I haven't used one before. I'll dig around and see what I can find.

Re: In Querying Secondary Data Source, can you have an "OR" situation in the query fields?

Hilary Stoupa — Wed, 10 May 2017 22:37:25 GMT

Use a REST data connection maybe? No qRules needed for that, but REST allows for more complex filters.

In Querying Secondary Data Source, can you have an "OR" situation in the query fields?

GwenW — Tue, 09 May 2017 16:20:32 GMT

I have an InfoPath 2010 browser form (with qRules). I'm querying a secondary data source using a data connection. I have multiple fields where I am setting the query values of the secondary data source fields to values captured on the form (Action rule - Set a Fields Value). This works fine. However the user now wants to see results of the query where 2 datasource fields may equal 1 InfoPath field.

To help explain... in the datasource I have fields "DSCategory 1" and "DSCategory 2". On the form I capture "IPCategory" If the user enters "Cost of Goods Sold" for the "IPCategory", I need to return all data where DSCategory 1 is "Cost of Goods Sold" OR DSCategory 2 is "Cost of Good Sold". I can't use the Set a Fields Value in the Action for setting both fields to IPCategory, then I would only get matches where both DS Catgories are "Cost of Goods Sold".

The only thing I can think of to do is have 2 separate data connections and then 2 separate queries, and return the data in 2 separate lists (not in a single sorted list like the user wants) .

Any ideas on something else that could work?

Thanks!

Gwen