To update enum value on multi select record

(0) Share

Report

Posted on by vinaytak

371

7827.demo.jpg

the last column is Select category it is by default "A"..now the thing is if i select the multiple account name and click on the sales category a new form will open it ask to change the value from "A" to "B",or "C"...if i select the the "C" the selected customer category change to "C"...it is possible to update the multiple name

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Suggested answer

Pravasti AK 2,985 on at

Like (1)

Report
Copy link

Link copied!

Hi Vinay,

use a tmp table, fill with the enum values and use the SysLookupMultiSelectCtrl Class.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

It has been asked before multiple times. Use multi-select lookup

community.dynamics.com/.../171480

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Vinay,

Yes you can update the name as you require, because name is non unique index, so it will allow duplicate records for customer accounts. you can update the name by using job or from front end you can modify the record.

Thanks

Suresh

Was this reply helpful? Yes No
vinaytak 371 on at

Like (0)

Report
Copy link

Link copied!

@Kavitha Rajan i already tried that but not succeed..the enum value i put in Dir party table...

Was this reply helpful? Yes No
vinaytak 371 on at

Like (0)

Report
Copy link

Link copied!

@Suresh potlakayala.. i want to do this when i select the multiple record from the front end like all customer i select the 3 customer then the new form pop up it ask to change when i choose the value from it it will update the value ..

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Then you need to do validation on that field, Please check the below link. it may be useful for you.

daxmusings.codecrib.com/.../multi-select-on-form-datasource-grid.html

Thanks

Suresh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please find the below link also,

community.dynamics.com/.../how-to-select-multiple-selected-values-records-from-lookups-in-dynamics-ax

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (1)

Report
Copy link

Link copied!

Hi Vinay,

static void lookupOpportunityId(FormStringControl _callerControl, smmOpportunityId _opportunityId, DirPartyId _partyId)

{

Query query = new Query();

QueryBuildDataSource queryBuildDataSource, queryBuildDataSource1;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(smmOpportunityTable), _callerControl);

;

sysTableLookup.addLookupfield(fieldnum(smmOpportunityTable, OpportunityId),true);

sysTableLookup.addLookupfield(fieldnum(smmOpportunityTable, Subject));

sysTableLookup.addLookupfield(fieldnum(smmOpportunityTable, PartyId));

sysTableLookup.addLookupfield(fieldnum(smmOpportunityTable, ProbabilityId));

queryBuildDataSource = query.addDataSource(tablenum(smmOpportunityTable));

queryBuildDataSource1 = queryBuildDataSource.addDataSource(tablenum(smmQuotationProbabilityGroup));

// queryBuildDataSource1.relations(true);

queryBuildDataSource1.joinMode(JoinMode::ExistsJoin);

queryBuildDataSource.fetchMode(QueryFetchMode::One2One);

queryBuildDataSource1.addLink(fieldnum(smmOpportunityTable, ProbabilityId), fieldnum(smmQuotationProbabilityGroup, ProbabilityId));

queryBuildDataSource1.addRange(fieldnum(smmQuotationProbabilityGroup, INU_smmProbabilityStatus)).value(queryvalue(INU_smmProbabilityStatus::Active));

queryBuildDataSource.addRange(fieldnum(smmOpportunityTable, Status)).value(queryNotValue(smmOpportunityStatus::Won));

queryBuildDataSource = queryBuildDataSource.addDataSource(tablenum(DirPartyTable));

queryBuildDataSource.joinMode(JoinMode::ExistsJoin);

queryBuildDataSource.fetchMode(QueryFetchMode::One2One);

queryBuildDataSource.addLink(fieldnum(smmOpportunityTable, PartyId), fieldnum(DirPartyTable, PartyId));

queryBuildDataSource.addRange(fieldnum(DirPartyTable, PartyId)).value(_partyId);

//INU_smmProbabilityStatus //BACK

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

Was this reply helpful? Yes No
vinaytak 371 on at

Like (0)

Report
Copy link

Link copied!

@Kavitha Rajan ....where to write this code

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

go to datasource in form, go to the field RC >> override methods you get lookupreference

Was this reply helpful? Yes No