Dynamics AX


Table Relations
·         Normal to specify relation fields without conditions.
·         Field Fixed to specify relation fields to restrict the records in the primary table.
·         Related Field Fixed to specify relation fields that restrict the records in the related table.

1.       For Normal, enter the following in the Field Relation property pages:
·         In the Field property, select the field in the primary table that relates to a field in the related table.
·         In the Related Field property, select the field in the related table.

2.       For Field Fixed, enter the following in the Field Relation property pages:
·         In the Field property, select the field in the primary table to use to restrict the records.
·         In the Value property, enter the value of the selected field as the filter. This relates only records in the primary table that match that field value. Only numeric values can be entered in the Valueproperty. Field fixed relations can be created only on numeric fields.
Each of the related fields are ANDed in the table relation.

3.       For Related Field Fixed, enter the following in the Field Relation property pages:
·         In the Value property, enter the filter value of the selected field. This causes only records in the related table that match that field value to be related. Only numeric values can be entered in theValue property. Related field fixed relations can be created only on numeric fields.
·         In the Field property, select the field in the related table to restrict the records.


Each of the related fields are ANDed in the table relation. 
overview of how to use the index hint and order by keywords in select statements.
                                     
                                      TO
                                         
                                     USE

Select records where the order isn't significant.

select ..
    where ...

Select records where the order is significant.

select ..
    order by ...
    where ...


Select records and force a specific index to be used.


select ..
    index hint ...
    where ...


Select records where the order is significant and force a specific index to be used.

select ..
    index hint ...
    order by ...
    where ...



Indexes in ax


The advantages of indexes are as follows: 
·         Their use in queries usually results in much better performance.
·         They make it possible to quickly retrieve (fetch) data.
·         They can be used for sorting. A post-fetch-sort operation can be eliminated.
·         Unique indexes guarantee uniquely identifiable records in the database.
The disadvantages of indexes are as follows: 
·         They decrease performance on inserts, updates, and deletes.
·         They take up space (this increases with the number of fields used and the length of the fields).

·         Some databases will monocase values in fields that are indexed. 
what is the difference between index and indexhint in select statement.


While fetching data from the database we use select statement and for better performance in data fetching we use an index/indexhint.

Index: when we use index in select statement it implies that the declare index field should behave as an order by and it is optional for the database to use. Database can use its own preference.

Index hint: it force the DB to use that index for fetch the data whether it is right choice or not.


Differences between MorphX and Intellimorph

 


 MorphX is the Microsoft Dynamics AX IDE( Integrated Development Environment) which includes:
 - Data Dictionary
 - Tools for creating menus, forms and reports for Windows- and Web clients
 - Compiler and debugger for the object oriented programming language X++
 - Version control system
 - Label (multi language text) systems  


IntelliMorph is the Runtime Environment embedded in Microsoft Dynamics AX, that draws menus, forms, and reports for Windows- and Web-clients with the correct contents, size, and layout according to:
 - The language your texts are displayed in.
 - What features you can access. 
 - How wide you want the fields on your installation.
 - The formats you are using for dates and numbers. 

Abstract methods in ax 2012


Abstract methods are used when you wish to force the developer of a sub-class to override the method and provide functionality.

Methods are declared as abstract by using the abstract keyword,

 for example "

public abstract void abstractMethod()
{
}
No code or declarations are allowed inside an abstract method.
·         It is not possible to declare a method as abstract unless the class is also declared as abstract.

·         If a sub-class is created which does not override the abstract methods in its parent, then a compile error will occur where that sub-class is used.

Difference between In Memory and Tempdb


                              

          In Memory                                                               Tempdb

1. Holds data temporarily in client or             1. Holds data temporarily in database
      server
2. These tables can't store in the database      2.These tables can store in the database.   
             .
3. Can't apply security.                                  3. Can apply security.  



Lookups in ax


Lookups are used in Axapta to show the user a list of possible values from which to select, whilst entering data into a control on a form.
Automatic lookups
Axapta has extensive support for automatic lookups, as well as the capability to manual enhance or replace the automatic system.
The standard lookup for customer accounts
Introduction
The standard lookup system in Axapta is based on the use of table field or data type relations. These specify a link between a particular data type, or particular table field, and a corrsponding field in another table containing the base (reference) data.
Generally, relations are made on the datatype (EDT) in the AOT, and will then automatically apply to any table field using that EDT.
For example, in the standard application, the CustAccount EDT has a relation specified to CustTable.CustAccount. This means that any table field using the CustAccount EDT will be automatically given a lookup icon which allows the user to select from the list of accounts in CustTable.

It is possible to further restrict the values which will appear in the lookup by specifying a "Related fixed field" relations on the datatype. In this case, only those values satisfying the relation will be shown in the lookup. See the Dimension datatype for an example of this (each Array Element has it's own relation defined

Comments

  1. Azure DevOpsJanuary 3, 2019 at 11:04 PM

    Informative blog and it was up to the point describing the information very effectively. Thanks to blog author for wonderful and informative post...
    MS Dynamics Online Training

    ReplyDelete

Post a Comment

Popular posts from this blog

Dynamics Ax 2012 Interview Questions:

Interview Questions: 1.       Difference between following condel   :- Use condel to delete one or more items from a container. confind :- Use confind to locate a sequence of items in a container.  conins   :- Use conins to insert some items into a container. conlen   :- Use conlen to find out how many items there are in a container. connull  :- Use connull to explicitly dispose of the contents of a container. conpeek :- Use conpeek to extract an item from a container, and to convert it into another data type   conpoke :- Use conpoke to replace (poke) an item in a container. 2.       Difference between edit and display method Display  Indicates that the method's return value is to be displayed on a form or a report. The value cannot be altered in the form or report Edit  Indicates that the method's return type is to be used to provide information for a field that is used     in  in a form. The value in the field can be edited.       3.       Diff
Read more

Oops concept in AX

Class : Class is the 1st OOPs concept .Class defines the characteristics of objects which includes its attributes , fields  properties and behavior . Let us say we have a class called car , then the color , model number , top speed can be its attributes and properties . Accelerating , breaking , turning will be its behavior Objects: Objects can be considered as a thing  that performs a set of related functions .Programming objects are used to model real worlds objects. An object is also an instant of a class . For our class Car , Ferrari  will be our object Instance : One can have an instance of a class; the instance is the actual object created at runtime.  The set of values of the attributes of a particular object is called its state. The object consists of state and the behaviour that’s defined in the object’s class. Method :Also called as  functions in some programming languages , methods defines the  behavior of particular objects . For our Car class , turning() , breakin
Read more
Exploring SysQuery class SysQuery is a helper class provided by Microsoft for working with queries dynamically. It has all its methods set as ‘static.’ It provides numerous functionalities that allow one to add data source in a query, add range, apply sort, etc. in a user-friendly system. This article will provide demonstrations for the most commonly used methods from SysQuery: findOrCreateDataSource() FindOrCreate is mainly used to check whether or not the query already contains the data source. If it does not, a data source will be created. FindOrCreate is most efficient when an event developer must write a code in which the event must be fired multiple times. This function allows developers to prevent adding additional elements to data sources. This is the most common situation in which findOrCreateDatasource() is used to avoid multiple addition of data sources in a query. Because this method is static, it uses Query as the first parameter. The next parameter w
Read more