Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

How can I update image field in items by categoryid with a query?

Posted on by 620

I need to help out the ordering dept by populating the image field in items.  I want to run a query that would use ILC and add .jpg to it and insert into the image field. I would need to be able to select by category or some filter so I can limit what is being changed.  I have seen a post that used this command is this correct?

UPDATE dbo_item.image SET dbo_item.image = "C:\IMAGEPATH\"  where categoryid = xxx

Also is there away to rename a current ILC in bulk?  Like ILC "028" to  "B028" by supplier or some other meaningful filter?

*This post is locked for comments

  • Verified answer
    TimB Profile Picture
    TimB 1,175 on at
    Re: How can I update image field in items by categoryid with a query?

    Hi, you need to set the path to the pictures in SO administrator. File --> Configuration --> Paths --> pictures field. No, the query in your post will not work. You could use the following, it should work.

    UPDATE item SET picturename = itemlookupcode + '.jpg'  where categoryid = xxx

    If you know the category name and not the id, you could replace this query with the xxx in the previous query including the parenthesis. (select id from category where name = 'CategoryNameHere')

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans