Microsoft CRM: how to automatically publish articles

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
itbossmanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Feridun KadirPrincipal ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
itbossmanAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.