Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Find the records that are modified recently
ZUHAD
Member Posts: 3
Hi all,
I am performing an Asynchronous integration of third party system with business central.I have written a code unit that is exposed as web service which will be used by the 3rd party system
i am syncing the following entities:
1. Product with Product variants and product identifiers
2. Sales order header with sales line.
3. sales shipment header with sales shipment line
4. sales invoice header with sales invoice line.
In my scenario i have multiple jobs which executes multiple time in a day that find the set of record which are changed after the given date-time. Then sync only the records which were changed.
Now the problem i am facing is that in business central most of the tables doesn't have modified date time field, which can be used to filter the records that are modified recently.
Can anyone tell me how i can filter the records from any table that are modified recently?
Note :
One of the possible solution is to extend each table add a new field modified date-time. Extend the onmodify() trigger and set the current date-time on it.
But my client doesn't prefer to extend all of these tables just for a very basic field.
The other solution i have identified is to use the change log feature.But i believe this will slow down the system due to large numbers of records.
Thanks.
Zuhad Mahmood
I am performing an Asynchronous integration of third party system with business central.I have written a code unit that is exposed as web service which will be used by the 3rd party system
i am syncing the following entities:
1. Product with Product variants and product identifiers
2. Sales order header with sales line.
3. sales shipment header with sales shipment line
4. sales invoice header with sales invoice line.
In my scenario i have multiple jobs which executes multiple time in a day that find the set of record which are changed after the given date-time. Then sync only the records which were changed.
Now the problem i am facing is that in business central most of the tables doesn't have modified date time field, which can be used to filter the records that are modified recently.
Can anyone tell me how i can filter the records from any table that are modified recently?
Note :
One of the possible solution is to extend each table add a new field modified date-time. Extend the onmodify() trigger and set the current date-time on it.
But my client doesn't prefer to extend all of these tables just for a very basic field.
The other solution i have identified is to use the change log feature.But i believe this will slow down the system due to large numbers of records.
Thanks.
Zuhad Mahmood
0
Answers
The preferred way to do something like this is using the SQL Timestamps that have been introduced with NAV 2016. However this still requires you to add fields to your Tables.
https://docs.microsoft.com/en-us/dynamics-nav/how-to--use-a-timestamp-field
Also a fine solution IMO.
No, just don't. For the exact reasons you stated.
/Wisa
I have just reviewed the time stamp property.The AL is not allowing to enable it on table extension. Is there any other way to enable it? I am using the business central cloud sandbox .
Thanks,
Zuhad Mahmood
Seems like you're right. The issue was handled here: https://github.com/Microsoft/AL/issues/1409
Well, then extending your tables with a "modified at" field is your best bet in my opinion. Unless someone else here has a more elegant solution to offer.
/Wisa