Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

BC Item Card -> Attachments -> link table?

(0) ShareShare
ReportReport
Posted on by 15

Hello I am looking at the item card URL links in the attachments section. 

I want to be able to query the website on the item card, using the item number. Right now it doesn't look like there is any default way to link the URL in the links table, to the item connected with that URL. At least in the table I am looking in. (RecordLinks (2000000068))

All the URls in the table look to be organized in numerical order, based on when they were created.

Can anyone point me in the direction of how to query URLs from the item card, using the item number?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: BC Item Card -> Attachments -> link table?

    Hi, they are linked by RecordID.

    For ease of understanding, I made a test.

    pastedimage1643951134855v4.png

    pastedimage1643951053458v2.png

    Message1:

    pastedimage1643951160030v5.png

    Message2:

    pastedimage1643951168144v6.png

    Message3:

    pastedimage1643951176309v7.png

    Message4:

    pastedimage1643951316842v1.png

    PS: RecordID is mentioned in the following post, hope it can give you some help.

    https://yzhums.com/21163/

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: BC Item Card -> Attachments -> link table?

    A combination of blogs should help here. Getting the record link could happen like this: thinkaboutit.be/.../

    You will need an unbound web service to use similar code to the above blog. This is me doing it the other way by writing a record link: joshanglesea.wordpress.com/.../

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans