InfoPath Dev

Hi, Please read the following Microsoft KB article. http://support.microsoft.com/kb/832511  

QueryBuilder allows you to query a SQL database or a SharePoint list. Can you check that the option for SharePoint is selected? That error message seems to indicate that QueryBuilder is trying to connect to a SQL database.

Hi- 1. The command FilterOwssvr only works with SharePoint's http://<servername>/_vti_bin/owssvr.dll. 2. I don't believe owssvr.dll will handle wildcards, but I will have to check. If you have DBXL, you could use QuerySharePoint to do server side filtering.

 You can filter a SharePoint list on the server using qRules (read more here). CopyTable cannot filter when copying, unfortunately.

Because you are sorting the data in a secondary data source, you'll need to add one more parameter. The dsname parameter is optional and only needs to be declared if it is not the Main DOM. So your command becomes: SortTable /dsname=User Information List /row=/dfs:myFields/dfs:dataFields/dfs:User_Information_List /compare=@Name /order=DESC ...

InfoPath's default connection that retrieves data from SharePoint will return the entire data set as a secondary data source. So, you cannot limit the number of items returned. Sadly, the best you can do is to set up a filter and limit the number of items displayed in the dropdown. If you have a custom web service (write your own code or ...

You can use the command FilterOvwsrv in qRules for this. Basically, you would be filtering the SharePoint data connection for Protocol Number to return only rows where Protocol Number in the ShP list = the Protocol Number entered by the user. If the qRules command finds a match (look at the Success and Result nodes in the QdabraRules 2DS) then you ...

I'm afraid there must be a problem in your rules. Are you using the command current() to get the current dropdown's value?

I don't believe there should be a problem with this. Can you try it and let the community know if there were any issues? Thanks!

Interesting. translate() won't work for me either. I did manage to get something similar working:concat(substring-before(field1, ";;"), ";", substring-after(field1, ";;"))