crossreference | CrossReference plugin for CKEditor

You need to use a format from bookdown to get cross references, see https://bookdown.org/yihui/rmarkdown-cookbook/cross-ref.html

You can do this with the following VBA-script. There might be still ways to improve it, so I am happy about constructive comments.

The following converts figure captions like "Figure 3: Some Text" to "Figure 1.3: Some Text," hence includes the chapter numbers. If you want to exclude the chapter number, you cannot simply set IncludeChapterNumber to False because otherwise, the code cannot distinguish between the old and the new captions. One solution would be to set IncludeChapterNumberto False and change the new text to "Figure 1. Some Text." Hints to that are in the code.

To change the table captions, just replace "Figure" with "Table" and run the code again.

you are not saying what your error message is, but one obvious error is the quotes you are using are not being escaped. Also you have one ( too many at the beging of the query ("((SELECT...) So you need to escape the quotes in your query like so

Uses filter to filter for matching id. Mutates orders array objects.
For large data sets, you will want to use an object map lookup table to track ids so you don't have to iterate the entire products array for every order (O(N) vs O(N^2))
(You would create an object map on orders ids, so you iterate orders array only once and then products array only once)

For the solution of the problem you can see here:

http://www.cs.ru.nl/J.Hooman/DSL/AdvancedXtextManual.pdf

But I will explain it.

First you will creat an IQualifideNameProvider that extends the original IQualifiedNameProvider. Inside this classe you will creat how your QualifiedName should be composed. Here is how I did:

First of all, you cannot have such a result using this kind of structure since Map has only one value. Although the value is a list of items, for the map it is still one value.

JAXB cannot handle complex/nested data structures such as Map>. You have to create a wrapper ex. WrappedStringList for the values of the map, i.e. Map.

If you want add line Cross-Reference to existing stock Item your request should work. Just check that you use correct type - "PUT" and correct endpoint:

Use cross apply to unpivot: