Monday, August 25, 2014

Update SysExportdialog Filename to User Export date and time and user id

// To update SysExportdialog Filename to User Export date and time and user id

AOT -> Form -> SysExportDialog -> Method -> run

Overwrite line  [element.updateBox(fileNameNext(    )] in run method as

element.updateBox(fileNameNext
                (strfmt('%1%2_%3_%4_%5_%6%7',
                        filePath, preFix,treeNode.treeNodeName(),curUserId(),
                                date2str(today(),123,2,DateSeparator::Dot,2,DateSeparator::Dot,2),
                                    time2str(timeNow(),TimeSeparator::Dot,TimeFormat::Hour24), #xpo)));

Missing_index in D365FO

 Refrence: sys.dm_db_missing_index_details (Transact-SQL) - SQL Server | Microsoft Learn