to GREG COLLINS [sharepoint second datasource filter]

[Cyril]

I tried to do what you described in your post, but I am having trouble
writing the following expression without using the expression designer.
Can you help me correct this expression so I can copy/paste it into the
"value" field of the expression?

xdXDocument:GetDOM("Modifications
construction")/dfs:myFields/dfs:dataFields/dfs:Modifications_construction/@Description_succinte[contains(../@Concat_element,
xdXDocument:get-DOM()/my:mesChamps/my:Selection_element) and
contains(../@Concat_grandeur,
xdXDocument:get-DOM()/my:mesChamps/my:Selection_grandeur)]

Thanks a lot for helping me

Cyril


"Greg Collins [MVP]" <Greg.Collins_AT_InfoPathDev.com> a écrit dans le
message de news: (e-mail address removed)...
Controls from secondary data sources do not show the filter button. There
are two ways to do what you are trying to do.

1. In the Designer:
Bind your control to a node in the main DOM. Add the filter manually using
"The Expression". If you use the expression designer it will create an
expression that will not work later. Once you have your filter in place,
then re-bind your control back to the secondary data source. The filter will
actually stay in place -- it is not erased. By the way this can cause
headaches if you ever do this and didn't mean to, and then can't figure out
why things aren't showing up right! I wouldn't call this a bug, its more of
a power feature. I'd say the bug is that the filter button isn't present for
secondary data sources.

2. Manuallly Modify the XSL:
Extract your form files and manually add the filter to the control in the
XSL. InfoPath will leave it alone as long as it is constructed like the
other filters created from the designer.

Hope this helps!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Ok now I think we need the help of someone wo has taken part into the
development of infopath:

Here is the problem that nobody has been able de solve (see my past post):

I have a sharepoint site with a form librairy.
I added my sharepoint list to the the secondary data source, then I dragged
and dropped a field on my form, which led to the creation of an extensible
section.
I am willing to FILTER this extensible section using the data contained in
another listbox.

This seems to be impossible to do, the "filter" button is not even present
on property page of the extensible section?

Please someone help!

Thanks

Cyril

 

[Cyril]

I can't find a way out, here is the form, can you add the filter from
view(report) champ25 to the extensible section linked to
"description_succinte" for me?



"Greg Collins [MVP]" <Greg.Collins_AT_InfoPathDev.com> a écrit dans le
message de news: (e-mail address removed)...
Since I don't know your DOM, it's hard to make any informed help with this,
but there are several things to check.

1. Let InfoPath be your guide.
When in doubt, try building your filter on a node in the main DOM so you can
compare what InfoPath writes it to the one you are writing. This can give a
lot of help in figuring out where you might be going astray.

2. Watch your namespaces!
A. "dfs:" is likely right for for myFields and dataFields,
but not likely to be on the remaining nodes. Either
there is no namespace at all, or there is a namespace
that wasn't autogenerated by InfoPath.
B. Check for namespaces on attributes. Right now you
don't have namespaces declared on the attributes,
but should there be? (i.e. @foo:Concat_element).

3. Contains is case sensitive.
If the two strings being compared in the contains() function match except
for case, then its still not a match. Verify that the case will be the same
when you are doing this comparison.


Other than that, I don't see any glaring issues.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



I tried to do what you described in your post, but I am having trouble
writing the following expression without using the expression designer.
Can you help me correct this expression so I can copy/paste it into the
"value" field of the expression?

xdXDocument:GetDOM("Modifications
construction")/dfs:myFields/dfs:dataFields/dfs:Modifications_construction/@Description_succinte[contains(../@Concat_element,
xdXDocument:get-DOM()/my:mesChamps/my:Selection_element) and
contains(../@Concat_grandeur,
xdXDocument:get-DOM()/my:mesChamps/my:Selection_grandeur)]

Thanks a lot for helping me

Cyril


"Greg Collins [MVP]" <Greg.Collins_AT_InfoPathDev.com> a écrit dans le
message de news: (e-mail address removed)...
Controls from secondary data sources do not show the filter button. There
are two ways to do what you are trying to do.

1. In the Designer:
Bind your control to a node in the main DOM. Add the filter manually using
"The Expression". If you use the expression designer it will create an
expression that will not work later. Once you have your filter in place,
then re-bind your control back to the secondary data source. The filter will
actually stay in place -- it is not erased. By the way this can cause
headaches if you ever do this and didn't mean to, and then can't figure out
why things aren't showing up right! I wouldn't call this a bug, its more of
a power feature. I'd say the bug is that the filter button isn't present for
secondary data sources.

2. Manuallly Modify the XSL:
Extract your form files and manually add the filter to the control in the
XSL. InfoPath will leave it alone as long as it is constructed like the
other filters created from the designer.

Hope this helps!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Ok now I think we need the help of someone wo has taken part into the
development of infopath:

Here is the problem that nobody has been able de solve (see my past post):

I have a sharepoint site with a form librairy.
I added my sharepoint list to the the secondary data source, then I dragged
and dropped a field on my form, which led to the creation of an extensible
section.
I am willing to FILTER this extensible section using the data contained in
another listbox.

This seems to be impossible to do, the "filter" button is not even present
on property page of the extensible section?

Please someone help!

Thanks

Cyril