InfoPath Dev

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

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.

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.

XPathNavigator xnEmp = dsEmployee.CreateNavigator();

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);

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);

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

Cheers

karthik