How to check Duplicate Records using AL code?

(0) Share

Report

Posted on by Inkey Solutions

2,086

Hi All,

I need to check the duplicate records from the table and if I found duplicate address in the records then I need to move that record in the Custom Log table,

So, can anyone tell me How Can I check the duplicate records in the AL?

Thank You.

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

Hi,

Can you export all the data using config. package? or use Edit in Excel feature of the page.

Thanks.

Was this reply helpful? Yes No
Inkey Solutions 2,086 on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

Hi, Nitin Verma ,

I need to do it dynamically, so can you please provide any suggestion that is used by AL code? Thanks.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

There is no way to do it dynamically in standard system. You need to customize it.

Was this reply helpful? Yes No
Inkey Solutions 2,086 on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

Hi, Nitin Verma ,

I tried this code, does this works?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

PS - ALWAYS SEND CODE IN TXT FORMAT

You can try to put logic like this.

If you want me to edit it. share you code in txt format.

Thanks.

Was this reply helpful? Yes No
Inkey Solutions 2,086 on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

Nitin Verma :

Here it is,

[EventSubscriber(ObjectType::Table, Database::"Fixed Asset", 'OnAfterModifyEvent', '', false, false)]

begin

if rec.Address1 <> '' then begin

Rec.SetRange(Address1, Rec.Address1);

if Rec.FindSet() then begin

Message('Duplicate Found');

end else begin

Message('Not Found');

end;

end;

end;

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,696 Moderator on at

Like (1)

Report

RE: How to check Duplicate Records using AL code?

You can try this

[EventSubscriber(ObjectType::Table, Database::"Fixed Asset", 'OnAfterModifyEvent', '', false, false)]

local procedure OnAfterModifyEventFA(var Rec: Record "Fixed Asset")

var

FixedAsset: Record "Fixed Asset";

begin

if rec.Address1 <> '' then begin

FixedAsset.Reset();

FixedAsset.setfilter(Address1, Rec.Address1);

if FixedAsset.Count > 1 then

Message('Duplicate Found')

else

Message('Not Found');

end;

end;

Was this reply helpful? Yes No
Inkey Solutions 2,086 on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

Thank You Nitin Verma , this is works for me.

Can you tell us that How we can prevent the Insertion of duplicate records? [we want that do not allow the insert duplicate records.]

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: How to check Duplicate Records using AL code?

You need to write the code OnbeforeInsert event and put the error if any duplicate found or ignore the record by putting Error('')

Thanks

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to check Duplicate Records using AL code?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to check Duplicate Records using AL code?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates