Filter repeating table on value outside of table - get error. - InfoPath Dev
in

InfoPath Dev

Filter repeating table on value outside of table - get error.

Last post 02-14-2012 08:15 AM by shniggens. 8 replies.
Page 1 of 1 (9 items)
Sort Posts: Previous Next

  • 02-10-2012 12:43 PM

    Filter repeating table on value outside of table - get error.

    Reply Contact

    I am trying to filter my repeating table to show only items which field matches the value of a field outside of the table.  When I try to publish it, I get an "Object not set to an instance of an object" error.

    However, if I applly conditional formatting to do the same exact thing, I don't get any error.

    Any suggestions?

  • 02-13-2012 11:51 AM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    Is this a browser or a filler form?

    I don't use filters on repeating tables usually, as I've had troubles with them in IPFS - I also find that it is not easy to readily see when a table has a filter, whereas conditional formatting shows up in the Rules task pane.

    Hilary Stoupa

  • 02-13-2012 12:23 PM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    It's a browser form. 

     The reason I would like to filter instead of format is -

    The filter or condition is based off of a drop-down outside of the table in the form.  The users choose the drop-down, click a button, a table is copied over, and the only rows that are shown are rows that have a field that matches the drop-down.

    The problem is, with conditionall formatting, the table is formatted every time that drop-down changes, which causes a performance issue.  With the filtering, the filter isn't applied until after the table copies over, making it more seamless.

  • 02-13-2012 12:43 PM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    Can you check the SharePoint logs for additional information?

    Hilary Stoupa

  • 02-13-2012 01:03 PM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    Here's what the ULS viewer gives me -

    System.NullReferenceException: Object reference not set to an instance of an object.

    at Microsoft.Office.InfoPath.Server.SolutionLifetime.Filters.<>c__DisplayClass2.<CreateDependentNodeList>b__0(BaseControl match)

    at System.Collections.Generic.List`1.Find(Predicate`1 match)

    at Microsoft.Office.InfoPath.Server.SolutionLifetime.Filters.CreateDependentNodeList(BaseControl control, String expressionString)

    at Microsoft.Office.InfoPath.Server.SolutionLifetime.Filters.AnnotateView(Solution solution, View view)

    at Microsoft.Office.InfoPath.Server.Converter.SolutionConverter.ConvertView(Solution solution, ConverterDocument converterDocument)

    at Microsoft.Office.InfoPath.Server.Converter.SolutionConverter.ConvertSolution(Solution solution)

    at Microsoft.Office.InfoPath.Server.SolutionLifetime.Solution.<>c__DisplayClass2.<ConstructFromXsnFile>b__0()

    at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

    at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)

    at Microsoft.Office.InfoPath.Server.SolutionLifetime.Solution.ConstructFromXsnFile(ConversionContext context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId)

    at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.OperationRunner.ExecuteConversion(ConversionContext& context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId, Boolean executeVerification)

    at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.OperationRunner.ExecuteConversion(ConversionContext& context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId, Boolean executeVerification)

    at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.ExecuteInRemote(ConversionContext context, AppDomain domain, SolutionCabinet solutionCabinet, SolutionIdentity solutionId)

    at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.<>c__DisplayClass4.<TryRunConversion>b__0()

    at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

    at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)

    at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.TryRunConversion(ConversionContext context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId, Byte[] solutionData, WspSolutionInfo wspSolution)

    at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.RunConversion(ConversionContext context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId)

    at Microsoft.Office.InfoPath.Server.Util.InstalledSolutions.<>c__DisplayClass7.<VerifyUnpackedSolution>b__6()

    at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

    at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)

    at Microsoft.Office.InfoPath.Server.Util.InstalledSolutions.VerifyUnpackedSolution(SolutionCabinet solutionCabinet, String originalFileName, ConversionContext context, ConverterLog& outputConverterLog, Byte[]& outputConvertedData)

    at Microsoft.Office.InfoPath.Server.Util.InstalledSolutions.VerifySolution(String absoluteLocalPath, ConversionContext context, ConverterLog& converterLog, Byte[]& convertedData)

    at Microsoft.Office.InfoPath.Server.Administration.FormTemplateCollection.VerifyFormTemplateInternal(String solutionPath, ConverterLog& converterLog)

    at Microsoft.Office.InfoPath.Server.Administration.FormTemplateCollection.TryUpgradeFormTemplate(String solutionPath, UpgradeType upgradeType, ConverterLog& converterLog)

    at Microsoft.Office.InfoPath.Server.Administration.FormTemplateCollection.UpgradeFormTemplate(String solutionPath, UpgradeType upgradeType)

    at Microsoft.Office.InfoPath.Server.ApplicationPages.UploadFormTemplatePage.<>c__DisplayClass1.<ButtonOkClick>b__0(String sourceName)

    at Microsoft.Office.InfoPath.Server.ApplicationPages.UploadFormTemplatePage.HandleFiles(HandleFile fileHandler)

    at Microsoft.Office.InfoPath.Server.ApplicationPages.UploadFormTemplatePage.ButtonOkClick(Object sender, EventArgs e)

    at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

    at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

    at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

  • 02-13-2012 02:12 PM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    Is your SharePoint server running SP1?

    I know I've seen this before - I removed the filters from my table, so don't know of a resolution for you, but one blog I found (thank goodness for Google translate) suggested he was able to resolve the issue when he moved his calculated value controls below his repeating table controls in his view. I certainly hope that didn't actually cause the issue, but it's kind of interesting.

    Oh, and MSDN has this post on the ShP boards - but no conclusive answer.

    Hilary Stoupa

  • 02-14-2012 07:35 AM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    That looks like it is indeed the problem.  I have a seperate test form that has the same table and rules.  When I add a calculated value above the table, the form will no longer publish.  This is good to know. 

    I worked around it by adding a text box to filter with (conditional formatting) and setting the text box with button click instead of default value. 

  • 02-14-2012 08:00 AM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    Oh. My. Gosh. Thanks for posting this - I honestly thought that had to be some crazy coincidence. Can you tell me your version of SharePoint 2010 (any service packs or hotfixes installed)? I want to report this as a bug.

    Hilary Stoupa

  • 02-14-2012 08:15 AM In reply to

    Re: Filter repeating table on value outside of table - get error.

    Mark as Answer
    Reply Contact

    2010 SP 1.  

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