Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Which table holds the info for "Links"?

Posted on by Microsoft Employee

Hi,

I trying to get a RapidStart export of a certain table.

Problem is, I am missing the info that shows what links are present for each field.

For example, when I do a export of all contact cards, I want to see as well the Links that each contacts are linked to:

linkscapture.PNG

It has the fields: Link Address , Description, Created (Date), User ID

I want to be able to manipulate these information en bulk as well.

Can anyone let me know if this is possible with RapidStart? Which table do I look for (if there is one)?

Thanks.

Categories:
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,959 Super User 2024 Season 2 on at
    RE: Which table holds the info for "Links"?

    Gary,

    I would not sugget to copy data in a 50000 Table and do any changes in that data.

    Record Link table is specifc for Links and Notifications so dont try to update it manually. The Only Way is using a batch and here is how it will work -

    1. You will update your actual records in the table (lets say Contacts) using RapidStart.

    2. Then Create an Excel/text file which contains two things - Primary Key field value of table (No. in case of contact table), table number and Link address.

    3. Create a batch in NAV which read that file and then insert the record in Record Link table in a batch. (Ask your partner to develop this).

    With these three steps you will be able to acheive what is required.

  • subrata.bauri Profile Picture
    subrata.bauri 1,112 on at
    RE: Which table holds the info for "Links"?

    Create a Table in 50000 Range & try to copy from 2000000068 to your new table. Now you can able to add this new table in RS.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Which table holds the info for "Links"?

    Hi Saurav,

    Many thanks for your assistance.

    Thats a bummer - I have a requirement to place links en bulk to a list of items (eg contacts).

    Do you know of a way a non-programmer like myself can accomplish this rather than a manual operation?

  • Verified answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,959 Super User 2024 Season 2 on at
    RE: Which table holds the info for "Links"?

    Hi,

    Links are stored in Table 2000000068 - Record Link of Type = Link.

    To Export this data out or Update that data it will require C/AL Code. Rapid Start cannot be used to export and modify the data as its a system table which is not supported by RapidStart.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans