Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Microsoft CRM: how to automatically publish articles

Posted on 2012-03-22
2
Medium Priority
?
257 Views
Last Modified: 2012-04-06
See attatched. To publish I have to submit the one in draft>which goes to unapproved and only after I approve it, it goes to published. After it is published, it is searchable.

How do I made it automaically publish when the article is created? I did find a table in database called kbArticleBase where I can set both stateCode and StatusCode to 3. It does move the article to published folder but it is not searchable from workplace.

I compared the ones which I did from Draft>Upapproved>Published Vs the one I manually set the codes to 3. The difference was that the manual one didnt seem to put the template. I open the article and the entries are blank.

So if there a way set the CRM so that it automatically publish the articles without having to go through draft and unapproved folders? Is there somewhere else in the database table I see to set the flags?

Thanks
Capture.JPG
noTemplate.JPG
Template.JPG
0
Comment
Question by:itbossman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 30

Accepted Solution

by:
Feridun Kadir earned 2000 total points
ID: 37754936
You really shouldn't play around with values in the database tables. As you've discovered doing what looks like the right thing may not work.

I would consider using an automatic workflow that runs when an article record changes status. In the workflow, check that the status is unapproved and add a step to change the status to published.
0
 

Author Comment

by:itbossman
ID: 37817074
thanks, I have given creaters to have ability to publish their own articles. That way I dont have to work with database on the backend.
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question