Qdabra qRules

Re: Filter Rule issue

Hilary Stoupa — Tue, 06 Nov 2012 15:33:07 GMT

Ah hah! It is because your value had a comma in it. FilterOwssvr uses comma delimited filters and values if you want to filter on more than one item. So, you can specify another value for your delimiter that won't show up in your /value data.

Re: Filter Rule issue

cnorris135 — Tue, 06 Nov 2012 14:32:32 GMT

based on the Temp Error from the second item I ran, I remember seeing this error before....... "Parameter count mismatch for filter and value.
Please verify each parameter has the same number of comma-separated values."

I had to change my formula from

concat("FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=", .)

concat("FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=", ., " /delimiter=~") .....

this worked...... while I really don't understand why this error popped up or what it is about, i do know how to fix it. Can you tell me why this is?

Re: Filter Rule issue

cnorris135 — Tue, 06 Nov 2012 14:24:43 GMT

sorry, i was confused initially..... the dropdown was pointing at the wrong list in the Test Form. I reset it..... so we are back to square one.... I have a sharepoint list called ADMIN that the external facility field is coming from. the applicable info,. according to the dropdown choice is also in the same list.................. it works correctly for the FIRST ITEM..... ignore that second .xls i sent yesterday. I also have some TEST forms and somehow I got them crossed.............the xls i sent to Ernesto is the CORRECT .xls. see below

here is the test form run results:

FIRST ITEM in list:

External Facility dropdown field: A&L Great Lakes laboratories Inc. Fort Wayne IN

Temp Command: FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=A & L Great Lakes Laboratories Inc. Fort Wayne IN |

Temp Error: |

Temp Result: | http://wssdas.intranet.dow.com/rsga/qau/_vti_bin/owssvr.dll?Cmd=Display&List={BD6CBBCF-579C-4813-A85D-E2A06501088D}&View={D27414D6-612D-4B86-AE0B-0EEA4F9E707E}&XMLDATA=TRUE&NOREDIRECT=TRUE&FilterField1=External_x0020_Facility&FilterValue1=A+%26+L+Great+Lakes+Laboratories+Inc.+Fort+Wayne+IN

Address: A&L Great Lakes Laboraties Inc. Fort Wayne IN

City: Fort Wayne

State IN

I then chose the FIFTH ITEM in the list...... results below

FIFTH ITEM in list

External Facility dropdown field: ABC Ag Services Sheridan, IN

Temp Command: FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=ABG Ag Services Sheridan, IN | FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=A & L Great Lakes Laboratories Inc. Fort Wayne IN |

Temp Error: | | Parameter count mismatch for filter and value.
Please verify each parameter has the same number of comma-separated values.

Address, City, State....... still all the same as the first Item choice......

Re: Filter Rule issue

Hilary Stoupa — Mon, 05 Nov 2012 23:30:10 GMT

I'm simply trying to understand whether the options you are selecting from your drop down are present in the list you have the owssvr.dll connection to. Does the External Facility Name data connection get it's values from the same list as your owssvr.dll connection? Here's another version for you to try - it has a temp result field - let me know what the values in that field are.

Re: Filter Rule issue

cnorris135 — Mon, 05 Nov 2012 21:23:31 GMT

sending your directly the .xls... this forum does not allowt the format.

Re: Filter Rule issue

Hilary Stoupa — Mon, 05 Nov 2012 21:07:35 GMT

I didn't change your other rules, just wanted the command to execute successfully - from what you are saying, you didn't get results returned either time you executed the rule. You'd sent Ernesto an XLS with data from your list. I don't see either of the values in your list that you sent. Can you verify those external facilties are in use in the list you are querying with your owssvr.dll data connection?

Re: Filter Rule issue

cnorris135 — Mon, 05 Nov 2012 20:55:45 GMT

First Choice in dropdown:

Temp command: FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=Estação Experimental da SGS-Gravena Ltda (Jaboticabal) |

Temp Error: |

Second Choice in dropdown

Temp command: FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=Estação Experimental da SGS-Gravena Ltda (Jaboticabal) | FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=Syntech Research do Brasil Ltda |

Temp Error: | |

dont know if it was your plan to not have the regular fields(based on the dropdown) populate but they are not......even with the first item i chose in the list.................... the temp fields did though, each time (see above). cant say they are not working.... i don tknow....

Re: Filter Rule issue

Hilary Stoupa — Mon, 05 Nov 2012 20:39:39 GMT

Perfect. So that helps with troubleshooting - we know that the rule is not returning values in the 2DS - that is why they aren't getting set. I've made another change. Try again, first with the one that works, then with a selection that doesn't. You don't have to try them all, just need one success and one failure. There are two new fields under the drop down - Temp Command and Temp Error. Let me know the values after a success and a failure.

Re: Filter Rule issue

cnorris135 — Mon, 05 Nov 2012 19:30:02 GMT

Sorry Hillary but no values are returned to any of the fields when using the dropdown fields. I went through each and every item in the dropdown list and nothing.......... the repeating table is populated initially with all the items but once I go and use the dropdowns, it's like it turns it all off.

Re: Filter Rule issue

Hilary Stoupa — Mon, 05 Nov 2012 16:13:47 GMT

Hi, Chris:

Can you preview the attached template and try the same steps you have been trying (select the first item in the dropdown, then change to a different item) and scroll to the bottom of the form, where I've placed a repeating table bound to the 2ds, and see if any values are returned in the fields that you are using to set the main data source fields?

Re: Filter Rule issue

cnorris135 — Fri, 02 Nov 2012 14:30:11 GMT

emailed you.

Re: Filter Rule issue

ErnestoM — Thu, 01 Nov 2012 14:20:57 GMT

Can you execute the data connection that populates the dropdown (External Facility Name) and the data connection that filters (ExternalOwssvr) but without any filters, that is, to get all data back? I don't see anything in the rules to cause only the first option of the dropdown to filter, so maybe there's something in the data itself. If you don't want to post that data here, email it to me.

Thanks.

Re: Filter Rule issue

cnorris135 — Wed, 31 Oct 2012 19:42:35 GMT

here is the form again with the rule. Not sure why it did not come through on the previous one i attached....

please let me know as it has been driving me crazy....

chris

Re: Filter Rule issue

ErnestoM — Thu, 11 Oct 2012 18:26:19 GMT

I guess I'm looking for the rule/control that kicks off the qRules command. I don't see that on /my:myFields/my:ExternalInformation/my:ExternalFacilityName.

When I look thru Logic Inspector, I don't see this: concat("FilterOwssvr /dsname=ExternalOwssvr /filter=External_x0020_Facility /value=", .)

Re: Filter Rule issue

cnorris135 — Thu, 11 Oct 2012 18:07:44 GMT

Just so we are on the same page, i am looking at the ExternalOswrr filter. your troubleshooting is talking about another filter....... Again ernesto... this filter fires but on for the first item in the list only. to me, this tells me it does work......kinda right?