IFactRetriever — parameterize by existing facts

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › IFactRetriever — parameterize by existing facts

Viewing 1 reply thread
  • Author
    Posts
    • #17080

      Hi all,

       I have a situation where I have a custom fact retriever getting some long-term data from a database table.  Unfortunately, the database table has millions of records and I don't want to assert the entire table as a fact.  However, based on the state of the orchestration, I can determine more precisely which records I do need as my facts.  Thus, I would like to parameterize the SQL query in my UpdateFacts method with already existing facts, which were already asserted into the BRE in the orchestration.  Unfortunately I can not figure out how to access already asserted facts inside the UpdateFacts method of IFactRetriever.  I suspect it involves going though the RulesEngine engine variable, but I can't see how. 

      Any thoughts are appreciated.  I am about ready to give up and create a .NET object corresponding to this table which I will parameterize and create in an Expression shape and then assert as a fact.

       Thank you.

    • #24049

      UpdateFacts method has a handle to the previous asserted facts called “factsHandleIn.”

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.