Store custom field in a database and get it in d365fo project

(0) Share

Report

Posted on by Community Member

Hi Guys,

I am totally new to D365FO. I need to store URL in a database and then get it value in the project.

What is the best way to do it? Was trying to create a custom table in AxDB and pull it in DataEntity, but my table doesn't even appear in DataSource selection list.

I have the same question (0)

All responses (14)

Answers (1)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

What is the URL related to? Perhaps you can store it in some already existing table / field - or add a field to existing table.

Also where do you want to use this URL?

Could you explain your business requirement / functional requirement? Thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Nikolaos,

Thanks for reply!

I need to have a form, where in tab (iframe) would be displayed resourse from another website. For now URL of this website is hardcoded. The requirement is to store this URL in a database and pull it from there in the project to transfer to iframe .

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I would not create a new table for storing one URL.

You talk about projects, so are you using this in Project management module? Then you could add a new field in ProjParameters table via table extension. But you would need to specify the URL in every legal entity separately, since project parameters are not shared across legal entities.

You can access the field in x++ by "ProjParameters::find().MyField".

SystemParameters is a global table shared by all companies.

But I would put it in the parameters of the module that is related to your functionality.

Data entity is needed only if you want to access this field from external systems. And, also then you can add it to an existing entity via extension.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Unfortunately, the exact requirement is to use database.

I am using custom almostly blank module and there are no entities yet.

Could you please tell how to access/modify database correctly in this case?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

ProjParameters and all other tables ARE in the database. The only way to add anything in the database is using tables.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

If it's your custom module, create a paramerer table for it if you don't already have one. Use existing parameter tables as examples, because they differ a bit from most other tables - especially by supporting only one record for each legal entity.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (0)

Report

Hi Polina,

If you want to embed a third party application or website you can read the next post to achieve it using a configuration: docs.microsoft.com/.../embed-third-party-apps--phase-2

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I will try it.

But I am still curios how to deal with AxDB itself? I tried to write queries but always had timeout error, and Data Entity doesn't show a table I created. Maybe I am doing wrong?

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

Like (0)

Report

Forget data entities for now, you don't need them.

What do you mean that queries timeout? Please tell us more details about what you are doing, for example the code of your query.

Are you already familiar with reading data from existing tables with x++? You need to know that before it's useful to add your own tables.

You don't need to deal with AxDB, the system does it for you. You just need to know which table you want to query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here is a query I came up with:

Query query;

QueryBuildDataSource qbds;

QueryBuildRange qbr;

QueryRun queryRun;

Counter resultCnt = 0;

str myRange = 'valueForSearch';

AnyTable anyTable;

query = new Query();

qbds = query.addDataSource(tableNum(AnyTable));

qbr = qbds.addRange(fieldNum(AnyTable,Field));

qbr.value(myRange);

info (query.toString());

queryRun = new queryRun(query);

while (queryRun.next())

{

resultCnt++;

}

info(strFmt("results count: %1",vendCnt));

I was trying to calculate number of records in the existing table for testing purposes. But it returns nothing ("results count : 0").

Also I tried simple update transactions:

ttsbegin;

select forupdate Table

where Table.field == "Value";

Table.field = "newValue";

Table.update();

ttscommit;

In this case I got an error "The record has never been selected"

Was this reply helpful? Yes No