Filter a repeating table from a secondary source - InfoPath Dev
in

InfoPath Dev

Filter a repeating table from a secondary source

Last post 10-17-2012 02:23 AM by wilkies0106aw. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 10-16-2012 06:25 AM

    Filter a repeating table from a secondary source

    In the past week I have had several forms break and they all have one thing in common.  They have a repeating table based on a secondary data source that was filtered.  The forms were all developed in InfoPath 2007 and have not been changed for many months.  I have seen several posts on filtering secondary data sources and I believe that is the technique that I used.  However, when I attempt to modify the design of the forms in InfoPath 2010 it appears that you can no longer filter secondary data sources.

    Several InfoPath 2010 patches came out last week and we removed the patches and it fixed some of the forms but not all of them.

    Can anyone confirm that filtering secondary data sources was removed from InfoPath 2010?

    Filed under:
  • 10-16-2012 07:44 AM In reply to

    Re: Filter a repeating table from a secondary source

    When you say "filtered" - do you mean using the filter option on a repeating table? I actually won't use that because I found it caused problems in browser forms sometimes, but had never bother to track down when the issues occurred. I use conditional formatting to hide rows instead.
    Hilary Stoupa

  • 10-16-2012 07:52 AM In reply to

    Re: Filter a repeating table from a secondary source

    It appears I was using Conditional Formatting and I am only displaying rows based on a field computed off a date.  The real issue is dates are now including a time zone designation which breaks my condition. 

     Old format 2012-11-16T00:00:00

     New format 2012-11-16T00:00:00-05:00

    At the moment, I am not sure if something in Windows 7 changed or something in InfoPath 2010 changed.

     Sorry if my original question was unclear, but I was lost :( 

  • 10-16-2012 07:59 AM In reply to

    Re: Filter a repeating table from a secondary source

    Hard to tell what may have changed - but you could use a substring function to just return the date portion (before the T) and use that in your formatting.... That might be safer. Don't worry about the question being confusing - it can be hard to know what to include.
    Hilary Stoupa

  • 10-17-2012 02:23 AM In reply to

    Re: Filter a repeating table from a secondary source

     Do you need the date and time function?  Can you not just change the Date and Time picker to be a Date Picker?

    Check your original field default value

    The follow might help.

    http://www.youtube.com/watch?v=0sSzl2311HA

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.