Service | Customer Service, Contact Center, Fie...

'knowledgearticlescategories' table

(0) Share

Report

Posted on by TedW

479

Hi,

I am trying to locate the 'knowledgearticlescategories' table and can't see it listed as an entity. I can see there is a N:N relationship created in the knowledgearticle table to knowledgearticlescategories so not sure why that table isnt listed in the list.

Does anyone have any suggestions as to where it might be? We are looking to add KB articles to an external Wordpress site and need access to the table for that.

Thanks a lot,

Ted

I have the same question (0)

All responses (3)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Partner，

Is this it?

If so, this table name is category.

https://learn.microsoft.com/en-us/dynamics365/customer-service/create-manage-categories?tabs=customerserviceadmincenter#create-and-manage-categories

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No
TedW 479 on at

Like (0)

Report

Hi Leah Ju,

Thanks for your suggestion. Im still confused about this though, I know there is a relationship between Knowledge Article and Category, but when I look in Power Apps, I can see a field called Relationship name called knowledgearticle_category. But there is also a Relationship table called knowledgearticlecategories and I cant seem to see that Relationship table anywhere.

Thanks

Ted

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

HI Partner,

This relationship type is Many-to-many.

With Many-to-many relationships a Relationship (or Intersect) table stores the data that associates the tables. This table has a One-to-many table relationship with both of the related tables and only stores the necessary values to define the relationship.

You can’t add custom columns to a relationship table and it is never visible in the user interface.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-nn-relationships

So knowledgearticlecategories is this Relationship table, and it's only natural that you won't be able to find it anywhere, which is by-design.

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No