How can I add a find method on my custom table

(0) Share

Report

Posted on by Jacky_Sam

I’m new to Development in D365FO. I’m following the post https://community.dynamics.com/ax/b/axinthefield/posts/using-azure-application-insights-to-monitor-license-usage-in-d365-finance-and-operations

But I’m getting compile errors below.

Severity	Code	Description	Project	File	Line	Suppression State
Error		Table 'AppInsightsParameters' does not contain the static method 'find'.	FinanceOperations1 (USR) [TestModel]	C:\AOSService\PackagesLocalDirectory\Bin\XppSource\TestModel\AxClass_CPR_VendEditInvoice_Form_Extension.xpp	11

This is obvious that I don’t have find method because it is a custom table. But I’m not sure how do I add a find method? Can anyone help me please?

I have the same question (0)

All responses (5)

Answers (0)

Arunraj Rajasekar 1,743 on at

Like (0)

Report
Copy link

Link copied!

Hi Jacky Sam,

Most out-of-the-box tables include a find method, which you can use as a reference to create your own. The link you are referencing is for completely different requirement.

thanks,

Arun

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,208 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Here is a sample: Table name is PayrollPeriod

static PayrollPeriod find(RecId _recId, boolean _forUpdate = false) { PayrollPeriod payrollPeriod; if (_recId) { payrollPeriod.selectForUpdate(_forUpdate); select firstonly payrollPeriod where payrollPeriod.RecId == _recId; } return payrollPeriod; }

Was this reply helpful? Yes No
Jacky_Sam 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks Komi, i followed your suggestion and i was able to add a find method based on Recid. I didn't create any unique index on my table, i'm just passing recid as parameter in find method. is it fine?

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!
For a common table its Ok, but do you have RecId on hand (When you called find method).

If I m not wrong you are trying create a parameter table. This tables generaly has only a row data so find method a little different (You dont need RecId)

public static ParameterTable find(boolean _update = false) { ParameterTable parameter; parameter.selectForUpdate(_update); select firstonly parameter index KeyIdx where parameter.Key == 0; if (! parameter && ! parameter.isTmp()) { Company::createParameter(parameter); } return parameter; }

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

By the way, you can learn more about parameter tables in Parameter System Design Pattern.

Was this reply helpful? Yes No