Hi
I have used the following query from controller but understand from the error report that the view is not referred correctly in the query. Thanks for any help.
private List<ArticleColour> loadArticleColour(UUID articleId) {
LoadContext loadContext = LoadContext.create(ArticleColour.class)
.setQuery(LoadContext.createQuery("select c from dynamiccolumnedit$ArticleColour c where c.article.id = :articleId")
.setParameter("articleId", articleId))
.setView("articleColour-view");
return dataManager.loadList(loadContext);
}
and getting the following error
com.haulmont.cuba.core.global.ViewNotFoundException: View dynamiccolumnedit$ArticleColour/local not found
at com.haulmont.cuba.core.sys.AbstractViewRepository.getView(AbstractViewRepository.java:200)
at com.haulmont.cuba.core.global.LoadContext.setView(LoadContext.java:147)
at com.company.dynamiccolumnedit.web.order.OrderEdit.onRefreshSizeColor(OrderEdit.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
I have attached the articleColour-view ref.