Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011: Plugin trigger report fetch RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    We have a plugin that triggers Pre RetrieveMultiple and Pre Execute, to alter the request being made.

    In CRM 4 we could catch fetches when view results were retrieved, and in CRM 2011 it works well to do the same on the RetrieveMultiple message.

    Now we are trying to catch the Execute message when a report is run, to alter the query in the same way, but it never fires!

    How do I trigger a fetch being called to generate a report??

    /Jonas

    Thursday, March 24, 2011 12:21 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    take a look at David Jennaway's instruction in this blog entry...

    http://blogs.msdn.com/b/crm/archive/2008/05/21/plugins-which-message-and-which-pipeline.aspx

    good tactics for tracking down which events are firing.  It may not do anything beyond confirm that the event doesn't fire but perhaps you'll identify an alterate event to use.

    Thursday, March 24, 2011 9:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Fetch based reports do not call RetrieveMultiple. They fetch data differently and will not support plug-ins. Can you describe your scenario a bit more, if this is what your are trying to achieve?

    Thanks

    Abhishek Agarwal MSFT
    Friday, March 25, 2011 6:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    Simply put: The plugin modifies the query based on some placeholders and business rules, in order to control what data is returned to the user.

    But I have to wonder why the reports don't "fetch" the same way, now that it uses fetchxml instead of sql ???

    /Jonas

    Friday, March 25, 2011 7:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Please could you let me know if you ever got a solution to this issue?

     

    "But I have to wonder why the reports don't "fetch" the same way, now that it uses fetchxml instead of sql ???" I completely 100% agree.

     

    "Fetch based reports do not call RetrieveMultiple. They fetch data differently and will not support plug-ins." This seems absolutely nuts to me - glaring hole!

    Monday, July 11, 2011 11:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    No solution.

    I think it is time to try to escalate this somewhere.

    Wednesday, August 3, 2011 9:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Abhishek,

    Any chances this will be changed in the future? How can a plugin intercept a RetrieveMultiple from FetchXml reports? (no workarounds?)

    Thanks

    Gonzalo | gonzaloruizcrm.blogspot.com

    Thursday, May 10, 2012 4:15 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Gonzalo

    There are no plans currently to enable this. I would suggest opening a connect bug to get this in the priority list. You know how it works. :)

    Also, there isn't a way for the plugins to intercept this but you may try some other workarounds of using custom fields to pre-calculate the things you want or use SRS expressions. Thiese may work in some cases as workarounds but not all.

    Thanks

    Abhishek Agarwal MSFT


    Friday, May 11, 2012 6:02 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    There is a similar Connect item I've created since the same/equivalent problem exists for charts. https://connect.microsoft.com/dynamicssuggestions/feedback/details/728124/consistent-backend-and-plugin-framework-when-working-with-charts

    ----- Allan Varcoe, Cinteros AB, Stockholm, Sweden http://www.cinteros.se MCT, MBSP, MCTS, etc.

    Friday, May 11, 2012 10:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jonas,

    We have a same story with us.. Please let me know how did you overcome this problem? Did you change your approach completely or did you find a workaround for this?

    Please let me know.

    Thanks,

    Wednesday, June 13, 2012 1:55 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Sorry "victim" - no solution yet.

    However - please vote for the Connect item from Allan (above), this is a related issue that would probably help us with the reports too...

    /Jonas

    Monday, June 18, 2012 8:57 AM