I have an infopath form that takes in brings in an entire table and I want to filter it on datetime by comparing records from a time span of dates that have already been assigned. I have tried everything from doing it from the within infopath using
equations to filter the datasource and also doing it programmatically. I am to the point where I think it has to be done programmically (C#). Here is an example of the XPath code I was trying:
(xdMath:Avg(xdXDocument:GetDOM("ISSOrbits")/dfs:myFields/dfs:dataFields/d:ISSOrbits/@Apogee[(number(translate(xdXDocument:GetDOM("ISSOrbits")/dfs:myFields/dfs:dataFields/d:ISSOrbits/@StartTime, "T-:+", "")) >= number(translate(/my:myFields/my:MissionData/my:LaunchMissionDateTime,
It seem that only the first record (node) from ISSOrbits gets compared and not the whole dataset.
Please show me how to do this programmatically in C# or if there is way to do it without code.
P.S. I forgot to mention that table is brought in through a webservice that cannot filter data.
View Complete Post