General

Re: Repeating Table with Dynamic Query

Greg Collins — Sat, 09 Jul 2005 03:21:44 GMT

Drop downs do not have OnClick handlers. You will need to use the OnAfterChange handler.

OnBeforeChange and OnValidate both happen while the DOM is readonly.

- - - - -

position() will probably have no effect in your XPath. I would think that the following should give you the same results:

../@name = current()/my:OptionName

Greg Collins [InfoPath MVP]
InfoPath Dev

Re: Repeating Table with Dynamic Query

Richard — Fri, 08 Jul 2005 23:33:23 GMT

Hi Greg,

I filtered the dd3 using
../@name = current()/../my:Choice[position()]/my:OptionName
and that did the part of the trick.
i.e , even though that the web service re-populates the dd3's in all rows, however, I am still able to see the selected values of dd3 ( i.e the text does not change .)

So, I figured, that if the user wants to re-select his dd3 in any of the rows, all I have to do is another query .. ! Ha..
But, I do not have access to the DropDown_onClick () ???
I tried the OnBeforeChange, but , I am not able DOM is read only ?

Any tricks here ?

Re: Repeating Table with Dynamic Query

Greg Collins — Fri, 08 Jul 2005 22:56:01 GMT

Hi Richard.

Sorry. I jumped into your discussion at the end when I posted my response. I just went back and read your scenario. I believe that you have a much more difficult situation here.

(following, dd will stand for 'drop-down'):

The problem is that when you refresh the web service with the dd2 selection, you are refreshing it for ALL dd3's. That means than the selections from any previous dd3 have been updated to the selections on your current row. This is a problem. That means if you have 5 rows, and on the 5th row you make a selection in dd2, the web service is updated and dd3 is populated. But then go back to dd3 on rows 1-4 and you'll find the same list for all 5 rows. Whoops!

This, unfortunately, is a restricting design flaw. The only way around it is to redesign.

Here's what I recommend (but don't know that it's possible because I don't know how the backend of you web service works):

If possible, dd3 should be bound to a secondary data source (can be web service still if you want) that pulls down ALL the related data to any possible selection in dd2. That means if dd2 can be A, B or C, then dd3 needs to be able to pull A {1, 2, 3}, B {4, 5, 6}, or C {7, 8, 9}. I.E. dd3 will populate with 4, 5 and 6 if dd2 is B.

The dd3 data cannot keep changing like it currently is. There has to be static data on the back end with some kind of a link to tie dd2 and dd3 together. Thus the dd3 data might be flat and look something like this (two columsn per row):

A, 1
A, 2
A, 3
B, 4
B, 5
B, 6
C, 7
C, 8
C, 9

Or it might be hierarchical and look simthing like:

But it must have values representing those in dd2 as well as the choices for dd3 that tie to the dd2 values.

The big switch here (and I don't know that you can do this -- it won't be so nice if you have something like 100,000 rows or something) is that you have to have a static data source to work with for DD3, not dynamic like it is now.

This would be entirely different if the cascading list was NOT in a repeating table. Then you wouldn't have this problem.

Good luck!

Greg Collins [InfoPath MVP]
InfoPath Dev

Re: Repeating Table with Dynamic Query

Richard — Fri, 08 Jul 2005 22:31:07 GMT

Hi Greg,

I am trying to filter the dropdown3 for the current row in the table:

/dfs:myFields/dfs:dataFields/tns:MarkLogicDistinctQueryResponse/tns:MarkLogicDistinctQueryResult/result/option/subresult[../@name = xdXDocument:get-DOM()/my:myFields/my:Choices/my:Choice[number(count(preceding-sibling::node()) + 1) ]/my:OptionName]

but that did not work , and neither did this:

../@name = current()[number(count(preceding-sibling::node()) + 1)]/my:OptionName

Re: Repeating Table with Dynamic Query

Greg Collins — Fri, 08 Jul 2005 19:49:14 GMT

See if the following helps:
http://www.infopathdev.com/howto/tutorials/default.aspx?i=51dce616335a4ff6a78f2d289baf4651

Greg Collins [InfoPath MVP]
InfoPath Dev

Re: Repeating Table with Dynamic Query

Patrick Halstead — Fri, 08 Jul 2005 06:17:06 GMT

Hi again,
I think this is an xpath issue with your filter. You need to refer to the correct row in the DOM to get the filtering to reflect the current sibling. There are numerous posts on this issue for tables. I'll ask Agni if he has time to look up the xpath incantation.
Regards,

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table with Dynamic Query

Richard — Fri, 08 Jul 2005 02:37:04 GMT

I modified the return of the web service to include a field whose attribute will be the same as the query parameter . i.e
something like this:

- <result>
- <option name="dropdown2name">
<subresult>John Smith the 4th</subresult>
<subresult>Ellen Ross</subresult>
<subresult>John Smith the 1th</subresult>
</option>
</result>

and I set the entry of the dropdown3 with filter as:

/dfs:myFields/dfs:dataFields/tns:QueryResponse/tns:QueryResult/result/option/subresult[../@name = xdXDocument:get-DOM()/my:myFields/my:Choices/my:Choice/my:OptionName]

Here is portion of the code for the DropDown2 After change :

IXMLDOMNode fieldValue1 = thisXDocument.DOM.selectSingleNode("/my:myFields//my:OptionName");
IXMLDOMNode queryValue1 = wsDOM.selectSingleNode("//dfs:myFields/dfs:queryFields/tns:DistinctQuery/tns:st1");
queryValue1.text = fieldValue1.text;
DataObject objDO = null;
objDO = thisXDocument.DataObjects["DistinctQuery"];
objDO.Query();

The first row in the table works well and the dropdown3 gets changed for each change in dropdown2.
However, once you add the second row in the table,, and select a different dropdown2, the results of dropdown3 is the same as the values for the dropdown3 in the first row..?

using the debugger, I saw that fieldvalue1.text is not that of current row but belongs to the first row. ??

Re: Repeating Table with Dynamic Query

Patrick Halstead — Thu, 07 Jul 2005 19:36:47 GMT

Hi Richard,
Me too !!! :) Anyway, Googling is great. Almost rhymes with Ogling. Makes you wonder if they weren't thinking the answer to MS's question: where do you want to go today? Was: Go Ogle. Not sure in what context though.

Anyway, to get to your question: you can change your Web service to return only a set number of values or filter them in the dropdown.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table with Dynamic Query

Richard — Thu, 07 Jul 2005 15:35:28 GMT

Hi Patrick,

I run on tea and coffee.. and googling .. !!

quote:
Originally posted by Patrick Halstead

Hi Richard,
What's with all of the !! and ?? marks? Did you just drink a slurpee or something from 7-11? :)

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table with Dynamic Query

Patrick Halstead — Thu, 07 Jul 2005 05:26:38 GMT

Hi Richard,
What's with all of the !! and ?? marks? Did you just drink a slurpee or something from 7-11? :)

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table with Dynamic Query

Richard — Thu, 07 Jul 2005 02:11:02 GMT

Hi , Thanks for your response..

Your solution suggests that I have to populate the secondary xml ( i suppose that is a datasource with no controls in the page or is it an xml file ? please confirm.) How do i do that.??

I was not planning to have the web service to return all the values of dropdown 3 for each values of dropdown2.. !!
because that may become slow,
I want to call the webservice only for the selected dropdown2 value.!
Unless you suggest that this works anyway ??

Re: Repeating Table with Dynamic Query

Agni Jonnalagadda — Wed, 06 Jul 2005 18:27:36 GMT

Hi Richard,

Map the third dropdown two a secondary xml with the structure similar to the following one
<Dorpdown3Values>
<Node dropdown2value="dd2v1">
< Dorpdown3Value>value1</ Dorpdown3Value>
< Dorpdown3Value>value2</ Dorpdown3Value>
</Node>
<Node dropdown2value="dd2v2">
< Dorpdown3Value>value1</ Dorpdown3Value>
< Dorpdown3Value>value2</ Dorpdown3Value>
</Node>
</Dorpdown3Value>

a. You will create a “<Node>” for each dropdown2
b. You will fill in Dropdown3Values when you select dropdown2 value(When the webservice is called)
c. Bind Dropdown3 to this new xml and filter “< Dorpdown3Value>”
based on the dropdown2Value “<Node dropdown2value="dd2v2"> value.

So now
1. When you change a value in dropdown2, OnAfterchange for dropdown2 gets fired.
2. In OnAfterChangeEvent call the webservice.
3. Fill the data into the above xml.
4. You should be able to see the values in the dropdown.

Agni
InfoPathDev India

Re: Repeating Table with Dynamic Query

Patrick Halstead — Wed, 06 Jul 2005 08:07:14 GMT

It's easier to do than that. I'll ask someone else to send the link.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Repeating Table with Dynamic Query

Richard — Wed, 06 Jul 2005 02:20:05 GMT

I was not able to find any post there, however, it seems that one could have an intermediate field where the webservice maps to.

then , Onafterchange event on the 2nd dropdown:

1- call the query , wait for the data to be there in the intermediate field,
2- take the data from the intermediate field and populate the dropdown .

Re: Repeating Table with Dynamic Query

Patrick Halstead — Sun, 03 Jul 2005 07:45:13 GMT

Hi Richard,
I think this is the same as a similar problem. You need to restrict the filter to the specific row. I believe there is a post on the Microsoft blog that talks about this. It will require a tricky xpath in your filter, but it is possible. Good luck researching further.

Patrick Halstead [InfoPath MVP]
InfoPathDev