web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

Community blogs

Dynamics 365 Community / Blogs

Featured

Finance | Project Oper...
X++ create date starting from year and week number
Daniele Ferraretto
Like (0)
Finance | Project Oper...
check query cue time
Daniele Ferraretto
Like (0)
Finance | Project Oper...
Filter fields type Date/Time (like Createddatetime) in query of Form
Daniele Ferraretto
Like (0)
Finance | Project Oper...
Batch not close elaboration
Daniele Ferraretto
Like (0)

Latest blog posts

View all
Like (0)
X++ create date starting from year and week number

Elaborating materials present in other parts, below a short piece of code for create a first date of week starting from the number of year and the number of week. public static date Week2Date(int yr, int week){ Date testDate = dateSt...

Daniele Ferraretto
Like (0)
check query cue time

Below a short piece of code for checking duration of queries in cue (AX 2009) static void RefreshCueCache(Companyid _curr = curext()){cueRun cueRun;cuesQuery cueQuery;int start, stop, interval, recNo ;; changecompany(_curr) { cueQuery =...

Daniele Ferraretto
Like (0)
Filter fields type Date/Time (like Createddatetime) in query of Form

Below a piece of x++ about the build of a filter related to the query of a form QueryBuildDataSource qbds; str rangestr, rangeStrFrom, rangeStrTo; str dateFrom, dateTo; if(createdDateFrom.dateValue() != datenull()) { dateFrom ...

Daniele Ferraretto
Like (0)
Batch not close elaboration

Hello everyone, after a long time here I am still writing about my experiences in AX. Lately I had a problem with batch processing that although they ran the code inside the class they never changed state. I add myself to the documentation that...

Daniele Ferraretto
Like (0)
Check defragmentation

Simple query to check the fragmentation of DB (I suggest to run in data and model too) SELECT DB_NAME(PS.database_id) AS dbName, S.name  AS SchemaName, O.name AS TableName, b.name, ps.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stat...

Daniele Ferraretto
Like (0)
warmup Ax rich client opening

Hi everybody, I have managing an arragement from a suggestion from an Internet post about to warmup richclient opening of Ax. In fact this not solve definetively the opening of client but permits a cache of some object. Leave here for your interes...

Daniele Ferraretto
Like (0)
Powershell: seeking file in a folder and send by smtp relay mail

the title of this post explain all. Useful if you have to sent last lofg error file and so on insert in a .ps1 file and schedule with task scheduler of $dir = “” $latest = Get-ChildItem -Path $dir | Sort-Object LastAccessTime -Descendi...

Daniele Ferraretto
Like (0)
Read text file … alternative way to read all lines in one operation

Hi, sometimes could be useful read files in one bulk operation directly from filesystem to an object and after managed this last one. Below I’ve reported my experience, hoping could be interesting for all. boolean loadFileInContainer() { Ite...

Daniele Ferraretto