How to: Create an Index and set it as primary

How to: Create an Index

Use the following procedure to create a new index on the AJ_BookTypeID field on the AJ_BookTypeTable
NOTE: A field of data type memo or container cannot be used in an index.

To understand the example scenario - Go here
1. Locate the AJ_BookTypeTable table in the AOT.
2. Right-click the Indexes node in the table and select New Index. A new index Index1 is created.
3. Rename the index to AJ_BookTypeIDIdx
4. Drag the field AJ_BookTypeID to the index AJ_BookTypeIDIdx node.
5. In the properties sheet for the AJ_BookTypeIDIdx node, set the property AllowDuplicates to No.


How to: Set a Primary Index
Use the following procedure to set the index created in the previous procedure to be a primary index.
1. In the AOT, locate the AJ_BookTypeTable table.
2. In the property sheet for the table, set the PrimaryIndex property on the table to AJ_BookTypeIDIdx
3. Close the property sheet for the table.
 

Comments

Post a Comment

Popular posts from this blog

Change Tracking in Data Entities and latest changes

Image
If you’ve ever worked on data integrations or migrations in Dynamics 365 Finance & Operations (F&O), you know the pain of moving large datasets repeatedly. Enter Change Tracking - a feature that feels small but makes a huge difference. What is Change Tracking? Change Tracking lets you detect and export only what changed since the last sync, instead of dumping the entire dataset every time. This is used by Microsoft already in the out-of-the-box frameworks : Inbuild Integrations with Microsoft CRM or BI scenario. Could be used for integration towards external apps. Incremental data migration  using DMF during cutovers. BYOD exports where performance matters. Why It Exists Without Change Tracking: Every export = full dataset. More time, more cost, more risk of throttling.  Most costs (per transfer / transaction). With Change Tracking: Only inserts, updates, and (sometimes) deletes are exported. Faster, lighter, and easier to schedule. Lesser costs. Types of Change Tr...
Read more

Finding Table Names and Data Entities in D365 F&O

Image
When working with data in Dynamics 365 Finance & Operations , one of the most useful skills is knowing where your data lives - which table or data entity holds the field you’re looking at. Why? Because this knowledge unlocks so many possibilities: Extracting data for analysis. Mass updates through Data Management . Building integrations or troubleshooting issues. Think of it as peeking behind the curtain to understand the architecture that powers your forms. Why This Matters Here’s a little reality check: Different fields on the same form can belong to different tables . A single field can appear in multiple data entities . And not all users have equal access - System Admins have the most visibility (SysTableBrowser, entity lists, etc.). So, if you’ve ever wondered “Where does this field actually come from?” , the below could guide you. Part 1: How to Find the Table Name for a Form Field Open the Form Navigate to the form where the field lives. Say, CustTableListPage. Right-C...
Read more

D365Ops Tip #1: Table browser

Image
It has been few months that the new AX, Dynamics 365 for Operations is released to market. And being a web client, the Business users and/or Application consultants working with AX, don't have the privilege of going into the AOT from the Client even with 'System Administrator' role in AX . And one of the most used tool used by any Developer and also sometimes by App. consultants is the Table browser accessing which is a bit different with the New AX - this post illustrates on how to achieve this with a Change in URL. We can start with an example, please observe the URL in the browser when you try to open the Users form (System Administration > Users > Users). https:// d365ops0516devaos.cloudax.dynamics.com / ?cmp=USRT&mi=SysUserInfoPage so now, from here if you want to open Table browser for "Users form", you can do so without using any tools by just changing the URL. https://d365ops0516devaos.cloudax.dynamics.com/?cmp=USRT& mi=SysTableBrow...
Read more