News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How can I update image...

Microsoft Dynamics RMS (Archived)

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

(0) Share

Report

Report

Posted on by Bob Johnson

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

TimB 1,175 on at

Like (0)

Report

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')

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans