Datasource filtering syntax?

[Barry Prentiss]

Hi,
I have an InfoPath '03 form library datasource that returns all values for
ProjNum and SubProjNum from the forms submitted there.
I am now filtering this datasource to identify the max value of the
SubProjNums for a specific ProjNum (in order to increment by 1 for the next
sub proj form).
My assignment looks like this:
NewSubProjNum = max(@SubProjNum[@ProjNum = ProjNum]) + 1

ProjNum is a value in a field on the new form and displays fine.
max(@ProjNum) returns the max(ProjNum) from the datasource fine.
But filtering the datasource for the max SubProjNum where @ProjNum =
ProjNum returns NaN.

Can anyone see what I am doing wrong here?
Any suggestions?
Thx,
Barry

 

[Swathi (GGK Tech)]

Hi,
Is the @ProjNum child of @SubProjNum in secondary data source? Once verify
that. Also after selecting @SubProjNum, click on Filter data. There select
the @ProjNum in the first drop down, is equal to in the second drop down and
ProjNum (main data source) in the third drop down. Click ok until all the
windows gets closed.

 

[Barry Prentiss]

Thx Swathi,
Yes, @ProjNum and @SubProjNum are both fields returned by the form library
datasource.
There is one @ProjNum and one @SubProjNum for each record (no parent-child
relationship).
Max(@SubProjNum[@ProjNum = ProjNum]) returns NaN.
Any more ideas?
Thx,
Barry

Hi,
Is the @ProjNum child of @SubProjNum in secondary data source? Once verify
that. Also after selecting @SubProjNum, click on Filter data. There select
the @ProjNum in the first drop down, is equal to in the second drop down
and
ProjNum (main data source) in the third drop down. Click ok until all the
windows gets closed.


--
Swathi Porandla
http://www.ggktech.com

Hi,
I have an InfoPath '03 form library datasource that returns all values
for
ProjNum and SubProjNum from the forms submitted there.
I am now filtering this datasource to identify the max value of the
SubProjNums for a specific ProjNum (in order to increment by 1 for the
next
sub proj form).
My assignment looks like this:
NewSubProjNum = max(@SubProjNum[@ProjNum = ProjNum]) + 1

ProjNum is a value in a field on the new form and displays fine.
max(@ProjNum) returns the max(ProjNum) from the datasource fine.
But filtering the datasource for the max SubProjNum where @ProjNum =
ProjNum returns NaN.

Can anyone see what I am doing wrong here?
Any suggestions?
Thx,
Barry

 

[Barry Prentiss]

Turns out I had to call the number function for the form-side ProjNum
value:
Max(@SubProjNum[@ProjNum = number(ProjNum)])
Hope this saves someone a few hours of anxiety...
Thx,
Barry

Thx Swathi,
Yes, @ProjNum and @SubProjNum are both fields returned by the form library
datasource.
There is one @ProjNum and one @SubProjNum for each record (no parent-child
relationship).
Max(@SubProjNum[@ProjNum = ProjNum]) returns NaN.
Any more ideas?
Thx,
Barry

Hi,
Is the @ProjNum child of @SubProjNum in secondary data source? Once
verify
that. Also after selecting @SubProjNum, click on Filter data. There
select
the @ProjNum in the first drop down, is equal to in the second drop down
and
ProjNum (main data source) in the third drop down. Click ok until all
the
windows gets closed.


--
Swathi Porandla
http://www.ggktech.com

Hi,
I have an InfoPath '03 form library datasource that returns all values
for
ProjNum and SubProjNum from the forms submitted there.
I am now filtering this datasource to identify the max value of the
SubProjNums for a specific ProjNum (in order to increment by 1 for the
next
sub proj form).
My assignment looks like this:
NewSubProjNum = max(@SubProjNum[@ProjNum = ProjNum]) + 1

ProjNum is a value in a field on the new form and displays fine.
max(@ProjNum) returns the max(ProjNum) from the datasource fine.
But filtering the datasource for the max SubProjNum where @ProjNum =
ProjNum returns NaN.

Can anyone see what I am doing wrong here?
Any suggestions?
Thx,
Barry

 

[Shiva (GGK Tech)]

Hello,

You have to check once your filter condition should be change.
NewSubProjNum = max(@SubProjNum[@ProjNum = ProjNum]) + 1
In this you have to specify the ‘@ProjNum’ and ‘ProjNum’ field’s are
getting? You have to give full path of the main DOM here.

--
Shiva
http://www.ggktech.com

Thx Swathi,
Yes, @ProjNum and @SubProjNum are both fields returned by the form library
datasource.
There is one @ProjNum and one @SubProjNum for each record (no parent-child
relationship).
Max(@SubProjNum[@ProjNum = ProjNum]) returns NaN.
Any more ideas?
Thx,
Barry

Hi,
Is the @ProjNum child of @SubProjNum in secondary data source? Once verify
that. Also after selecting @SubProjNum, click on Filter data. There select
the @ProjNum in the first drop down, is equal to in the second drop down
and
ProjNum (main data source) in the third drop down. Click ok until all the
windows gets closed.


--
Swathi Porandla
http://www.ggktech.com

Hi,
I have an InfoPath '03 form library datasource that returns all values
for
ProjNum and SubProjNum from the forms submitted there.
I am now filtering this datasource to identify the max value of the
SubProjNums for a specific ProjNum (in order to increment by 1 for the
next
sub proj form).
My assignment looks like this:
NewSubProjNum = max(@SubProjNum[@ProjNum = ProjNum]) + 1

ProjNum is a value in a field on the new form and displays fine.
max(@ProjNum) returns the max(ProjNum) from the datasource fine.
But filtering the datasource for the max SubProjNum where @ProjNum =
ProjNum returns NaN.

Can anyone see what I am doing wrong here?
Any suggestions?
Thx,
Barry