In X++ OnClosing Event.

(0) Share

Report

Posted on by Riyas ahamed F

1,215

Hi guys,

my requirement when i am creating new lead i want must be filled in Contact details so that i wrote onClosing Event below the Code.

[ExtensionOf(formStr(smmLeadTable))]
final class SmmLeadTable_TWI_Extension
{
    /// 
    ///
    /// 
    /// 
    /// 
    [FormEventHandler(formStr(smmLeadTable), FormEventType::Closing)]
    public static void smmLeadTable_OnClosing(xFormRun sender, FormEventArgs e)
    {
        FormDataSource fds = sender.dataSource('smmLeadTable');
        smmLeadTable leadTable = fds.cursor();
        LogisticsPostalAddress logisticsPostalAddress;
        DirPartyTable dirpartytable;

        select leadTable
           exists join dirpartytable
             where dirpartytable.RecId == leadTable.Party
              exists join logisticsPostalAddress
                  where logisticsPostalAddress.PrivateForParty == dirpartytable.RecId;
        if (leadTable)
        {
            throw error("Must be filled in Phone!");
        }
    }

}

Now, in this code after filed in Contact details and close the form came error.

And sometime after closed in smmLeadTable form 'must be filled in phone' in listapge throwing also One form only it's used in menuitem FormViewOpiton <grid>

what to be done two kind of error.

Thanks.

I have the same question (0)

All responses (16)

Answers (1)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report
Your select statement is not linked to the current record at all. Since you already have the current leadTable cursor at hand, you should not do a "select leadTable" because that would replace your current leadTable buffer with whatever comes out of your select statement.

If you want to find the phone number for this lead, select something like this:

select firstonly LogisticsElectronicAddress where logisticsElectronicAddress.PrivateForParty == leadTable.Party && logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Phone;

Also, as my code indicates, phone numbers are stored in LogisticsElectronicAddress, not LogisticsPostalAddress.

About your second issue, unfortunately I don't understand your description. Could you try to describe it more clearly? Thanks!

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

thanks for your replay Nikolaos Mäenpää,

in LogisticsPostalAddress coming a Address in SmmLeadTable so that i wrote a code.

The new lead created and once filled in a address then close form came error again ?

what should i do ?

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

So what code do you have in your system now?

And what is your functional requirement? Check that a postal address (LogisticsPostalAddress) exists or check that a phone number (in LogisticsElectronicAddress) exists?

Also, I suggest debugging your code, that usually gives you quite a good understanding what's happening under the hood.

The code in your original message is not going to work. It just searches for any party that has address and that is related to any lead in the system. Then, if it finds such party, it throws an error.

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

i got a is there no LogisticsElectronicAddress

but i tried in your logic same it is not working once filled in contact details then i will try close form

came "Must be filled in phone" what did i mistake.

below the code.

[ExtensionOf(formStr(smmLeadTable))]

final class SmmLeadTable_TWI_Extension

{

/// <summary>

///

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

[FormEventHandler(formStr(smmLeadTable), FormEventType::Closing)]

public static void smmLeadTable_OnClosing(xFormRun sender, FormEventArgs e)

{

FormDataSource fds = sender.dataSource('smmLeadTable');

smmLeadTable leadTable = fds.cursor();

LogisticsElectronicAddress logisticsElectronicAddress;

DirPartyTable dirpartytable;

select firstonly LogisticsElectronicAddress where logisticsElectronicAddress.PrivateForParty == leadTable.Party

&& logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Phone;

if (!LogisticsElectronicAddress)

{

throw error("Must be filled in Phone!");

}

}

}

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Can you show a screenshot where we can see that this lead has a phone number?

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

it's an address details by mistake.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

So is it working now?

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

No, still not working what could be causes and resolutions ?

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

I'm still waiting for the screenshot.

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Was this reply helpful? Yes No

Join the conversation

Community site session details

In X++ OnClosing Event.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

In X++ OnClosing Event.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates