General

Re: How to Fillter Data

karthik — Mon, 27 Apr 2009 12:35:09 GMT

O Great its working fine.Thank you for your response..

Cheers

karthik

Re: How to Fillter Data

swathip — Mon, 27 Apr 2009 12:08:42 GMT

Hi,

Replace the 3^rd line code with the following code line to filter the records.

XPathNodeIterator xiEmp = xnEmp.Select("/dfs:myFields/dfs:dataFields/dfs:LeaveInfo[@ApprovalStatus = ‘Approved']", this.NamespaceManager);

Re: How to Fillter Data

karthik — Mon, 27 Apr 2009 07:18:41 GMT

hi,

Thank you for your response.i am using this type of code. how can i filter the records on form_load.and also how can i assign the records in repeated table.

DataSource dsEmployee = this.DataSources["LeaveInfo"];

XPathNavigator xnEmp = dsEmployee.CreateNavigator();

XPathNodeIterator xiEmp = xnEmp.Select("/dfs:myFields/dfs:dataFields/dfs:LeaveInfo", this.NamespaceManager);if (xiEmp.Count > 0)

{

while (xiEmp.MoveNext())

{

if (xiEmp.Current.SelectSingleNode("@ApprovalStatus", this.NamespaceManager).Value == "Approved')

{

this.MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:group1/my:group2/my:field4", this.NamespaceManager).SetValue(xiEmp.Current.SelectSingleNode("@EmpName", this.NamespaceManager).Value);

}

Thanks

karthik

Re: How to Fillter Data

swathip — Fri, 24 Apr 2009 12:06:31 GMT

Hi,

Add the filter for Leave status field. For example,

My:Fields/my:group1/my:group2[my:LeaveStatus = ‘Approved']

If you still not get the result, send the schema of your secondary source.

How to Fillter Data

karthik — Fri, 24 Apr 2009 06:44:04 GMT

Hi,

how to display the approved status records in my InfoPath form.

For example..

My list columns

Leave type-PL/CL

Leave status-Approved(or)Refused.

Thanks

karthik