How To Use ExecuteQuery In D365 Forms

Поделиться
HTML-код
  • Опубликовано: 18 ноя 2024

Комментарии • 18

  • @erickecys
    @erickecys 2 года назад +1

    Thank you! Finally I understood how this works!

    • @peterramer
      @peterramer  2 года назад

      I am so glad it was helpful! Thanks for your comment.

  • @barancevik9777
    @barancevik9777 4 месяца назад +1

    Hey Peter, your education is quite understandable🎉 But there is no training series here to become a Graduate Dynamics developer, how do we install and run applications, how do you create forms, can you teach us these, or is it enough for me to finish this list of 53 videos completely?

    • @peterramer
      @peterramer  4 месяца назад

      Watching these videos will teach you most of what you need to know to work is this field. I will keep creating content to supplement but my goal in creating this content is to help people go from a beginning to having the skills to make a career.
      I plan to soon share a table of contents to better help people know what videos to watch in what order.

    • @barancevik9777
      @barancevik9777 4 месяца назад

      @@peterramer It's great to get help from someone knowledgable :) I have a pizza automation project that I do with C# and sql so I hope watching what they do will help me move forward in this area

  • @AhmedSalah-ir4ij
    @AhmedSalah-ir4ij 3 года назад +4

    Please could you make a video about event handler

    • @peterramer
      @peterramer  3 года назад +3

      Thanks for the suggestion. Yes, I definitely can. I try to create the articles and videos a few weeks before I publish them. So it may be a few weeks. But that definitely it a great topic.

    • @franciscomontero6732
      @franciscomontero6732 3 года назад

      It´d be awesome!

  • @SohanKanti8
    @SohanKanti8 3 года назад +3

    Hi Peter! Great videos. Can you please make tutorials on How to create data entites for my custom tables so that I can import data in them using Data management. And secondly how I can extend a existing data entity to include the table extension fields. Thank you

  • @chandanas2019
    @chandanas2019 Год назад +1

    After doing this the data is filtered and I can't able to see all the records .... I need to see all data and records by default and then filter it through this execute method. How to do that?

    • @peterramer
      @peterramer  Год назад

      You can use the filters on a grid and then save the filters. See this video: m.ruclips.net/video/CG-3HlxgUQk/видео.html
      After saving a filter you can switch between a filter that shows all the records. And one that shows a filtered list of records. m.ruclips.net/video/CG-3HlxgUQk/видео.html
      Let me know if that doesn’t make sense and I can explain more.

  • @KamranAhmed-lz9en
    @KamranAhmed-lz9en 3 года назад +1

    Great explanation, please make video on dimensions in d365 finance and operations.

    • @peterramer
      @peterramer  3 года назад

      Good idea. I will add that to me list. Thanks!

  • @ShabirAhmad-lw4yq
    @ShabirAhmad-lw4yq 3 года назад +1

    wao great carry on please upload more videos such as methods override not these simple if you can explain all methods override on table and form

  • @dougkershey3561
    @dougkershey3561 2 года назад +1

    How can I call the executeQuery in D365 so that when the form opens, it is already filtering by a select field value or just loads the form with no data in the grid at all? I have a form with a large amount of data that I don't want to populate when the form opens. I've tried calling the executeQuery method in the init and other methods, but nothing is working for me...the form loads with full data, which takes a couple minutes to load. Any help appreciated. Thanks.

    • @peterramer
      @peterramer  2 года назад

      You can put code in the init method of the data source to filter out all data. Essentially filter by something that should never happen like Recid equally 0. Then leave the execute query alone. The executequery method gets run when you push refresh on the form or when you call it directly after say pushing a button. Whereas the init method on the data source only gets called once. So you can use that.
      That said it sounds like something else is wrong. A form should not take minutes to open. Are the join types of your data sources set to ‘delayed’ join? This should only cause the system to load the records that can be seen on your form. So maybe like 100 records on a grid. And only when you scroll should it load more.

  • @techipradeepa7398
    @techipradeepa7398 3 года назад +1

    Informative# Can u explain or how can we update code from ax 2012 to d365

    • @peterramer
      @peterramer  3 года назад

      I’ll see what I can do around this topic. Often times it is a manual process of moving the code. But I will see if I explain more fully in an article.