Re: Filtering an external data source using an expression contained in the external data

Hilary Stoupa — Tue, 13 Oct 2009 17:02:41 GMT

Hi, Stefan:

I'm afraid I don't quite understand what you are tyring to do. I believe you want to filter the entries in a listbox that come from a secondary data source but I don't understand what you want to filter on. What would @precond need to be equal to (or less than, greater than, etc) for you to select a Transition value?

Filtering an external data source using an expression contained in the external data

srzientek — Thu, 08 Oct 2009 14:08:04 GMT

Hi,

I would like to populate a listbox with rows from an external data source using the computed value of an expression which is taken from one of the fields in the external data as part of the filter conditions to determine whether to include a given entry. Whilst I can create a filter that uses a static expression as one of its components e.g. the value of the file matches a pattern, I can't find a way of using the string value of a field in each candidate row as the expression to evaluate.

Here's a bit of the view1.xsl that shows the sort of filter I'd like to get working. Here I've made up a function called "EvaluateXPathExpression" as a placeholder for some magic to achieve what I want. "model" being the name of my external data source and precond being one of the fields

<xsl:for-each select="xdXDocument:GetDOM("model")/Model/Transitions/Transition[(EvaluateXPathExpression(@precond))]">

Can anyone help with suggestions for the "magic", please?

Preferably compatible with InfoPath 2003 SP1...and only using javascript if necessary.

Kind Regards, Stefan

General

Re: Filtering an external data source using an expression contained in the external data

Filtering an external data source using an expression contained in the external data