Schema Creation Help

Development
1

Hi,
We have been using Squidex as CMS and so far it is working as expected. Recently we came across a use case and I’m unable to define schema for it. The requirement is a parent child relationship in SQL speak. Below is the screenshot

image

Editors would like to use the above data to tag existing content. In order to support tagging of existing content, I can use the “References” field type and it works great as long as the referenced schema contains only one field in it.

But I am not sure of how to represent the above table as a schema in Squidex. Should I represent them as a flat structure ? Also, while tagging, editors would like to search and select items in “Sub Category” column and behind the scenes we should populate both the “Categories” and “Ids” data associated with the selected option. For example: If the user selects “ABD” as “Sub Category”, then we should tag the content as "A (the Category), ABD (the SubCategory), (123,321,874) (the Ids) .

I defined a schema called “test” as below and added couple of items.

image
image906×512 16.6 KB

Also, I configured “Sub Category” as assigned fields for reference fields.

image
image935×393 15.4 KB

Now when I try to tag an item, I’m not seeing the value of items in “SubCategory” rather I just see “2 Items” as below.

image
image1002×818 18.6 KB

Can you provide some insights on how to approach this use case?

Thanks,
Sudharsan N.

2

I would use your approach with the arrays for the categories and then a simple tags field with a custom editor to select the tags: https://docs.squidex.io/02-documentation/developer-guides/editors

There is also a sample for a tree like structure: https://docs.squidex.io/02-documentation/developer-guides/editors#3-product-taxonomy

3

With custom editors, the data (category,subcategory,ids) needs to pulled from Squidex on document ready? If so, then we have to store the credentials to access Squidex also in the html , right? Or, keep it as a JSON file ?

BTW, the example custom editor page (https://squidex.github.io/squidex-samples/editors/tags-category.html, https://squidex.github.io/squidex-samples/editors/country-selector.html) is not working.

4

Y

No, you get the access token as context: https://docs.squidex.io/02-documentation/developer-guides/editors#context

There is a demo editor for the context only:https://cloud.squidex.io/scripts/editor-context.html

What is not working with the editors you mentioned?

5

I will take a look at the context object.

Below is the error when I try the country-selector.

image
image1892×763 46.9 KB

6

Works for me. Perhaps the CDN does not deliver the file (company firewall or so?)

7

Oh! may be. Will double check.