Showing posts with label Data Entity. Show all posts
Showing posts with label Data Entity. Show all posts

Tuesday, February 28, 2023

Data entity Export using X++ in D365 FO

 Export data entity through X++ in D365 FO.




public final class ExportEntity
{
    public static void main(Args _args)
    {
        #dmf
        Query 				query;
        DMFEntityName 			entityName = "Batch groups";
        SharedServiceUnitFileID 	fileId;       

        // Update query
	// query = new Query(DMFUtil::getDefaultQueryForEntity(entityName));
	query = new query(dmfutil::getDefaultQueryForEntityV3(entityname));
		
        querybuilddatasource qbds = query.datasourcetable(tablenum(BatchGroupEntity));
        sysquery::findorcreaterange(qbds, fieldnum(BatchGroupEntity, ServerId)).value("Batch:DEMO");

        // Export file
        DMFDefinitionGroupName definitionGroupName = 'BatchGroupEntityExport';
		
        try
        {
            DMFEntityExporter exporter = new DMFEntityExporter();

            //There are optional parameters also added
            fileId = exporter.exportToFile(
            entityName,            //Entity label
            definitionGroupName,    //Definition group
            '',                    //ExecutionId group
            'CSV',                 // or 'XML-Element',//Source format to export in
            #FieldGroupName_AllFields,//Specify the field group fields to include in export.
            query.pack(),            //Query criteria to export records
            curExt(),//
            null,                //List of XSLT files
            true,                //showErrorMessages
            false);                //showSuccessMessages

            if (fileId != '')
            {
                //Get Azure blob url from guid
                str downloadUrl = DMFDataPopulation::getAzureBlobReadUrl(str2Guid(fileId));

                System.Uri uri = new System.Uri(downloadUrl);
				
                str fileExt;

                if (uri != null)
                {
                    fileExt = System.IO.Path::GetExtension(uri.LocalPath);
                }

                Filename filename = strFmt('CustomerPaymentData%1',fileExt);
                System.IO.Stream stream = File::UseFileFromURL(downloadUrl);
				
                //Send the file to user
                File::SendFileToUser(stream, filename);
                
                // Below code will delete the export group.
                //DMFDefinitionGroup::find(definitionGroupName, true).delete();
            }
            else
            {
                throw error("The file was not generated succefully. See execution log");
            }
        }
        catch
        {
            throw error("DMF execution failed");
        }

    }
}

Ref: Link


Keep Daxing!!


Thursday, February 17, 2022

Computed column in data entity in D365FO

Hi guys, I got a requirement like I need to send all warehouses of the selected site while exporting using data entity.

Way 1: Computed column:

Step 1: Create a computed column in the Data entity.

Step 2: Create an extension class for Entity.

[ExtensionOf(dataentityviewstr(MyEntity))] public final class MyEntity_Extension { }

Step 3: create a static method in that class.

Write the below logic.

public static str getWarehouse() { //The FOR XML PATH is creates a concatenated string from a result set. TableName entityName = tableStr(MyEntity); DataSourceName dataSourceName = dataEntityDataSourceStr(MyEntity, MyDataSource); FieldName fieldName = fieldStr(MyTable, MYField); SysDictTable myTestTable = new SysDictTable(tableNum(MyTestTable)); str Warehouse = myTestTable.fieldObject(fieldNum(MyTestTable, Field1)).name(DbBackend::Sql); str site = myTestTable.fieldObject(fieldNum(MyTestTable, Field2)).name(DbBackend::Sql); str testTablaName = myTestTable.name(DbBackend::Sql); str entityField = SysComputedColumn::returnField(dataentityviewstr(MyEntity), dataEntityDataSourceStr(MyEntity, MyDataSource), fieldStr(MyTable, MYField)); // we can use like this //entityField = SysComputedColumn::returnField(entityName, dataSourceName, fieldName); return 'SELECT STUFF((SELECT ' + SysComputedColumn::returnLiteral(DirUtility::ListDelimiter) + '+ RTRIM(EL.' + Warehouse +')'+ ' FROM ' + testTablaName + ' EL' + ' WHERE EL.' + site +' = ' + entityField + //' AND EL.' + Field2 + ' = ' + //SysComputedColumn::returnField(entityName, dataSourceName, fieldName) + ' ORDER BY EL.' + Warehouse + ' FOR XML PATH(' + SysComputedColumn::returnLiteral('') + ')),1,1,'+ SysComputedColumn::returnLiteral('') + ')'; // This is retun 'Warehouse' based on site value. }
// return SysComputedColumn::returnLiteral(''); // Retuns empty value.

Step 4: Add in fields properties.


Value : MyClass::getWarehouse



Standard Reference(In D365):

Entity : InventOperationalSitePostalAddressEntity;
Field : AddressLocationRoles
Class: LogisticsEntityLocationMapInterface
Method:concatenatedLocationRolesComputedFieldDefinition


Way 2: Non-Computed column(virtual Field):

Step 1: Create a field in the Data entity.
Step 2: Set is computed fields property to No.


Step 3: Create an extension class for Entity.

[ExtensionOf(dataentityviewstr(MyEntity))] public final class MyEntity_Extension { }

Step 4: Write the postload method

public void postload() { str wareHouse; next postload(); while select InventLocation where InventLocation.inventSiteId == this.OperationalSiteId { wareHouse += InventSite.InventlocationId + DirUtility::ListDelimiter; } this.warehouse = wareHouse; }

OutPut:

Similar output we get




Keep Daxing!!

Get the data from unmapped field into entity.

 Hi Guys, I added a new unmapped field in the Data entity. I need to get the data from user input(excel or XML).

Data : WHS1;WHS2;WHS3.

Entity methods:

public boolean insertEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx) { boolean ret; ret = next insertEntityDataSource(_entityCtx, _dataSourceCtx); if (ret && _dataSourceCtx.name() == dataEntityDataSourceStr(MyEntity, MYDataSource) && this.MyField) { this.operation(_dataSourceCtx); } return ret; } public boolean updateEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx) { boolean ret; ret = next updateEntityDataSource(_entityCtx, _dataSourceCtx); if (ret && _dataSourceCtx.name() == dataEntityDataSourceStr(MyEntity, MYDataSource) && this.MyField) { this.operation(_dataSourceCtx); } return ret; } private void operation(DataEntityDataSourceRuntimeContext _dataSourceCtx) { MyClass myClass = MyClass::construct(_dataSourceCtx);// my class myClass.getData(this.MyField); }

My custom class:

public class MyClass
{
Common     common;

public static MyClass construct(DataEntityDataSourceRuntimeContext _dataSourceCtx)
{
    return new MyClass(_dataSourceCtx);// getting entity data source
}

protected void new(DataEntityDataSourceRuntimeContext _dataSourceCtx)
{
    common = _dataSourceCtx.getBuffer();
}

public void getData(Str    _Warehouse)
{
    Str         warehouse;
    container   pack = str2con(_Warehouse, DirUtility::ListDelimiter);
                         //ListDelimiter ';'

    for (int i = 1; i <= conLen(pack); i++)
    {
        warehouse = conPeek(pack, i);

        if (!warehouse)
        {
            continue;
        }
        // you're logic
    }
}
}
I am getting the data like this. The above code is used to get this type of data and do the
opration.

Keep Daxing!!

Wednesday, February 16, 2022

Data entity methods in d365fo

Data entity methods in d365fo.


  • mapEntityToDataSource

// This method is hitting while updating and inserting // we can assign datasource1 recid values to child data source. // public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx) { if (_entityCtx.getDatabaseOperation() == DataEntityDatabaseOperation::Insert || _entityCtx.getDatabaseOperation() == DataEntityDatabaseOperation::Update) { if (_dataSourceCtx.name() == dataEntityDataSourceStr(MyEntity, MyDataSource)) { TestCustomer testCustomer = _entityCtx.getRuntimeContextByName( dataEntityDataSourceStr(MyEntity, TestCustomer)).getBuffer(); this.CustomerRecid = testCustomer.recid; } } super(_entityCtx, _dataSourceCtx); } -------------------------------------------------------------------------------------------------------------

  • postGetStagingData 

// After inserting into staging this method will trigger // Ref: LedgerJournalEntity public static void postGetStagingData(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution) { MyStaging staging; ttsbegin; while select forupdate staging where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup && staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId && staging.TransferStatus == DMFTransferStatus::NotStarted { staging.Field1 = staging.Field2 + '-' + staging.Field3; staging.Field4 = staging.Field5; staging.update(); }

    /*update_recordset staging     setting OperationalEntityId = curExt() where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup && staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId && staging.TransferStatus == DMFTransferStatus::NotStarted;*/ ttscommit; } -------------------------------------------------------------------------------------------------------------

  • postTargetProcess 

//  Executes the logic once after processing the target data. public static void postTargetProcess(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution) { if (_dmfDefinitionGroupExecution.StagingStatus == DMFBatchJobStatus::Finished) {  MyStaging staging;     ttsbegin;        while select forupdate staging         where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup     && staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId     && staging.TransferStatus == DMFTransferStatus::Completed     {     staging.Field1 = staging.Field2 + '-' + staging.Field3;     staging.Field4 = staging.Field5;     staging.update();     }

    /*update_recordset staging     setting OperationalEntityId = curExt() where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup && staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId && staging.TransferStatus == DMFTransferStatus::Completed;*/     ttscommit; }

---------------------------------------------------------------------------------

  • validateWrite

// Validate the each line. // LedgerJournalEntity public boolean validateWrite() { boolean isValid = super(); // Your logic return isValid; } -------------------------------------------------------------------------------------------------------------

  • validateDelete 

// Validate the each line. // LedgerJournalEntity public boolean validateDelete() { boolean isValid = super(); // Your logic return isValid; } -------------------------------------------------------------------------------------------------------------

  • persistEntity 

//Skip validate field code written in this method //Reference : LogisticsPostalAddressElectronicContactV2Entity public void persistEntity(DataEntityRuntimeContext _entityCtx) { _entityCtx.getEntityRecord().skipDataSourceValidateField( fieldNum(ElectronicContactsEntity, Location), true); super(_entityCtx); } -------------------------------------------------------------------------------------------------------------

  • initValue 

// Assign default values // WE can assign number sequence also. // SMMContactPersonV2Entity public void initValue() { if (!this.skipNumberSequenceCheck()) { NumberSeqRecordFieldHandler::enableNumberSequenceControlForField( this, fieldNum(PIDInvestigatorContactPersonEntity, ContactPersonId), ContactPerson::numRefContactPersonId()); } this.ContactForParty = Parameters::find().ContactForParty; super(); } -------------------------------------------------------------------------------------------------------------

  • initializeEntityDataSource

// Assign values to some fields based on some field values. //Reference : LogisticsPostalAddressElectronicContactV2Entity public void initializeEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx) { if (_dataSourceCtx.name() == dataEntityDataSourceStr(MyEntity, MyDataSource)) { ContactPerson contactPerson = ContactPerson::find(this.contactPersonId); if (this.LocationId == '') { DirPartyLocation dirPartyLocation = DirPartyLocation::findOrCreate( contactPerson.party, false); LogisticsLocation logisticsLocation = LogisticsLocation::find( dirPartyLocation.Location); this.LocationId = logisticsLocation.LocationId; this.Location = logisticsLocation.RecId; this.Party = contactPerson.party; _dataSourceCtx.setBuffer(logisticsLocation);//set buffer } } if (_dataSourceCtx.name() == dataEntityDataSourceStr(MyEntity, MyDataSource1)) { DirPartyLocation dirPartyLocationNew = DirPartyLocation::findByPartyLocation(this.Party, this.Location); _dataSourceCtx.setBuffer(dirPartyLocationNew); } super(_entityCtx, _dataSourceCtx); } -------------------------------------------------------------------------------------------------------------

  • insertEntityDataSource 

// While inserting into target //Reference :InventOperationalSiteV2Entity public boolean insertEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx) { boolean ret; if (_dataSourceCtx.name() == dataEntityDataSourceStr(InventOperationalSiteV2Entity, ReqSitePolicy)) { _dataSourceCtx.setDatabaseOperation(DataEntityDatabaseOperation::Insert); } ret = super(_entityCtx, _dataSourceCtx); return ret; } -------------------------------------------------------------------------------------------------------------

  • updateEntityDataSource:

// While updating into target //Reference :InventOperationalSiteV2Entity public boolean updateEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx) { boolean ret; ret = super(_entityCtx, _dataSourceCtx); return ret; }


Keep Daxing!!