topic Custom Datalist with Alvex Datagrid in Alfresco Forum

Custom Datalist with Alvex Datagrid

lmaorence — Mon, 17 Apr 2017 10:44:00 GMT

Hello, has anyone tried using custom datalist using Alvex datagrid? I'm having troubles making my custom datalist work, I tried making my own custom datalist without using alvex and its working but when I add alvex jars, my data items are gone and shows nothing, the "Configure Page" button is showin

Re: Custom Datalist with Alvex Datagrid

vhelmut — Sat, 22 Apr 2017 11:11:06 GMT

Lawrence Albor, say please what version of Alfresco an Alvex are you using?

Can you attach your datalist model?

Re: Custom Datalist with Alvex Datagrid

lmaorence — Mon, 24 Apr 2017 09:12:02 GMT

Hello, thank you for your response. I am using Alfresco Community v5.1.0 with Alfresco Share v5.1.e and I tried using the latest version of Alvex utils, masterdata, and datagrid. But I discovered that the latest version of datagrid is not working for me so I downloaded an older version of datagrid.jar here nexus.itdhq.com that was built on Jan. 7, 2017 and now the filter is working. The problem now is when I edit a datalist item, it redirects to another page (instead of a pop-up) and Save button is not working. I tried older and latter versions but has the same issue. Any ideas?

I'm using this datalist model, this is the one that was working when I used the above mentioned:
<?xml version="1.0" encoding="UTF-8"?>

<model name="dl:dlDatalist" xmlns="http://www.alfresco.org/model/dictionary/1.0">
   <description>Alfresco: PIMS Datalist</description>
   <author>Lawrence Albor</author>
   <version>1.0</version>

    <types>
       <type name="ap:apPims">
           <title>Alfresco: PIMS</title>
           <description>P.O. and Invoice Management System</description>
           <parent>dl:dataListItem</parent>
           <properties>
               <property name="ap:apPONum">
                   <title>PO Number</title>
                   <type>d:text</type>
                   <mandatory>true</mandatory>
                   <index enabled="true" />
               </property>
               <property name="ap:apInvNum">
                   <title>Invoice Number</title>
                   <type>d:text</type>
                   <mandatory>true</mandatory>
                   <index enabled="true" />
               </property>
               <property name="ap:apSupplier">
                      <title>Supplier Name</title>
                   <type>d:text</type>
               <mandatory>true</mandatory>
                   <index enabled="true" />
               </property>
               <property name="ap:apDDR">
                   <title>DDR Number</title>
                   <type>d:text</type>
                   <mandatory>true</mandatory>
                   <index enabled="true" />
               </property>
               <property name="ap:apStatus">
                              <title>Status</title>
                       <type>d:text</type>
                           <mandatory>true</mandatory>
                   <index enabled="true" />
                       </property>
               <property name="ap:apPay">
                   <title>Payment Terms</title>
                   <type>d:text</type>
                   <mandatory>true</mandatory>
                   <index enabled="true" />
               </property>
               <property name="ap:apCreDate">
                   <title>Date Created</title>
                   <type>d:date</type>
                   <protected>false</protected>
                   <mandatory>true</mandatory>
                   <index enabled="true" />
                            </property>
               <property name="ap:apModDate">
                   <title>Date Modified</title>
                   <type>d:date</type>
                   <protected>true</protected>
                   <index enabled="true" />
                            </property>
               <property name="ap:apComments">
                               <title>Comments</title>
                               <type>d:text</type>
                   <mandatory>false</mandatory>
                   <index enabled="true" />
                            </property>
           </properties>

           <associations>
               <association name="ap:apAttachments">
                   <title>Attachements</title>
                   <source>
                       <mandatory>false</mandatory>
                       <many>true</many>
                   </source>
                   <target>
                       <class>cm:content</class>
                       <mandatory>false</mandatory>
                       <many>true</many>
                   </target>
               </association>
           </associations>
       </type>
   </types>
</model>

I tried following this tutorial https://translate.googleusercontent.com/translate_c?depth=1&hl=en&prev=search&rurl=translate.google.com&sl=ru&sp=nmt4&u=… but it gives me this error org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'alvex-documents-registers-deployer' is defined . I already tried using the latest and old version of datalist in this tutorial but still has the same issue.

Re: Custom Datalist with Alvex Datagrid

vhelmut — Mon, 24 Apr 2017 20:44:47 GMT

Say please, have you installed alvex-utils component? Alvex datagrid depends on this component. It may be an answer to this error:

org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'alvex-documents-registers-deployer' is defined

I use the older version of Alvex: Community v2015.08 (dev) and I found bean 'alvex-documents-registers-deployer' in alvex-extension-registry-context.xml

In actual version of alvex I found only one link to this document in utils module

The problem now is when I edit a datalist item, it redirects to another page (instead of a pop-up)

I tried this on my older Alvex -- it looks the same, edit-mode opens in new window

and Save button is not working

Button is not active or just nothing happens when you click on it? Do you use folder rules in your datagrid space? I try to solve problem with similar behavior in my project

Your model looks like valid, but why you use dl prefix to your model?

<model name="dl:dlDatalist" xmlns="http://www.alfresco.org/model/dictionary/1.0">

It must be "ap" as your namespace prefix, I think

Re: Custom Datalist with Alvex Datagrid

lmaorence — Tue, 25 Apr 2017 01:34:24 GMT

Victoria Helmut wrote:
Say please, have you installed alvex-utils component? Alvex datagrid depends on this component. It may be an answer to this error:
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'alvex-documents-registers-deployer' is defined
I use the older version of Alvex: Community v2015.08 (dev) and I found bean 'alvex-documents-registers-deployer' in alvex-extension-registry-context.xml
In actual version of alvex I found only one link to this document in utils module

Yes, I have installed alvex-utils but still have the same issue.

The problem now is when I edit a datalist item, it redirects to another page (instead of a pop-up)

I tried this on my older Alvex -- it looks the same, edit-mode opens in new window
Oh I see, one of my requirements is not to refresh the page if a user edits a datalist item, I guess I also have to deal with that.
and Save button is not working
Button is not active or just nothing happens when you click on it? Do you use folder rules in your datagrid space? I try to solve problem with similar behavior in my project
When I hit Save, it displays Failure, Could not update details.

Your model looks like valid, but why you use dl prefix to your model?
<model name="dl:dlDatalist" xmlns="http://www.alfresco.org/model/dictionary/1.0">
It must be "ap" as your namespace prefix, I think
Oops, my bad there. Thank you for pointing it out. I changed it to ap:dlDatalist but still the same issue.
Currently, I am also trying using FME Datalist filter, have you also tried using this and on Alfresco v5.1?

Re: Custom Datalist with Alvex Datagrid

vhelmut — Tue, 25 Apr 2017 14:46:41 GMT

Unfortunately, version Alfresco is used in my company is too old: Alfresco: Community v4.2.0

Thank you for link to FME Datalist , I haven't use this extension, but I'll take a look for it

org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'alvex-documents-registers-deployer' is defined

I think this problem is on the Alvex's side: 3 hours ago somebody created task with same problem.

About problem with edit on older version of alvex: can you attach log? In my case problem with number-commit.post.json.ftl when the document instance is saved. I'd like to see your log to understand if we have similar errors)

Re: Custom Datalist with Alvex Datagrid

lmaorence — Wed, 26 Apr 2017 01:02:37 GMT

Unfortunately, version Alfresco is used in my company is too old: Alfresco: Community v4.2.0
Thank you for link to FME Datalist , I haven't use this extension, but I'll take a look for it

Oh, I see. I managed to make FME work for my project but with few bugs, but it works. Let me know if you have some questions about it.

I think this problem is on the Alvex's side: 3 hours ago somebody created task with same problem.
About problem with edit on older version of alvex: can you attach log? In my case problem with number-commit.post.json.ftl when the document instance is saved. I'd like to see your log to understand if we have similar errors)

Yeah, I guess so, or maybe the latest version is not yet optimized for my Alfresco version as of the moment. About the editing, I discovered that the one causing it is the masterdata.jar so I removed it and the edit now works but still in a new page, I want it on just a modal/pop-up though.

Are you working with lots of dataitems? Are the filtered item results consistent/complete?

Thank you for your responses, I really appreciate it. Cheers!

Re: Custom Datalist with Alvex Datagrid

vhelmut — Wed, 26 Apr 2017 18:45:37 GMT

Let me know if you have some questions about it.

Thank you so much

but still in a new page, I want it on just a modal/pop-up though

Look at this file i found in alvex repository: Config for using popup dialogs for view and edit forms

I don't test it, but it may be thing that you looking for

Are you working with lots of dataitems? Are the filtered item results consistent/complete?

I'm a developer, not an end user exactly, but I take a look now filter works correct (max quantity instances in one datagrid: 75). I did not hear any complaints about datagrid from users

There are some bugs in custom workflow instrumental in version that used in my company, but datagrids work fine

I would be pleased to answer any questions)

Re: Custom Datalist with Alvex Datagrid

lmaorence — Fri, 28 Apr 2017 08:22:40 GMT

Look at this file i found in alvex repository: Config for using popup dialogs for view and edit forms
I don't test it, but it may be thing that you looking for

Yep, this is the one. thank you so much

Re: Custom Datalist with Alvex Datagrid

vhelmut — Fri, 28 Apr 2017 08:47:57 GMT

I'm very glad that I could help you!

Good luck!)

Re: Custom Datalist with Alvex Datagrid

lmaorence — Wed, 03 May 2017 09:51:45 GMT

Hello again, I discovered an issue where the filter will not work after clicking the create new item or edit item buttons and not hitting save. Any ideas? Here is the error log:

2017-05-03 17:49:06,734 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-9] Exception from executeScript - redirecting to status template error: 04030002 Wrapped Exception (with status template): 04030004 Error during processing of the template 'The following has evaluated to null or missing:
==> data  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 16]

Tip: If the failing expression is known to be legally null/missing, either specify a default value with myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (These only cover the last step of the expression; to cover the whole expression, use parenthessis: (myOptionVar.foo)!myDefault, (myOptionVar.foo)??

The failing instruction:
==> ${data.query} auto-escaped  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 14]'. Please contact your system administrator.
org.springframework.extensions.webscripts.WebScriptException: 04030002 Wrapped Exception (with status template): 04030004 Error during processing of the template 'The following has evaluated to null or missing:
==> data  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 16]

Tip: If the failing expression is known to be legally null/missing, either specify a default value with myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (These only cover the last step of the expression; to cover the whole expression, use parenthessis: (myOptionVar.foo)!myDefault, (myOptionVar.foo)??

The failing instruction:
==> ${data.query} auto-escaped  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 14]'. Please contact your system administrator.
    at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1138)
    at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
    at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:505)
    at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
    at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:580)
    at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:649)
    at org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:421)
    at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:301)
    at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
    at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
    at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
    at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2403)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.alfresco.service.cmr.repository.TemplateException: 04030004 Error during processing of the template 'The following has evaluated to null or missing:
==> data  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 16]

Tip: If the failing expression is known to be legally null/missing, either specify a default value with myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (These only cover the last step of the expression; to cover the whole expression, use parenthessis: (myOptionVar.foo)!myDefault, (myOptionVar.foo)??

The failing instruction:
==> ${data.query} auto-escaped  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 14]'. Please contact your system administrator.
    at org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:227)
    at org.springframework.extensions.webscripts.AbstractWebScript.renderTemplate(AbstractWebScript.java:967)
    at org.springframework.extensions.webscripts.DeclarativeWebScript.renderFormatTemplate(DeclarativeWebScript.java:267)
    at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:147)
    ... 33 more
Caused by: freemarker.core.InvalidReferenceException: The following has evaluated to null or missing:
==> data  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 16]

Tip: If the failing expression is known to be legally null/missing, either specify a default value with myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (These only cover the last step of the expression; to cover the whole expression, use parenthessis: (myOptionVar.foo)!myDefault, (myOptionVar.foo)??

The failing instruction:
==> ${data.query} auto-escaped  [in template "alvex/datalists/datalist-search.post.json.ftl" at line 4, column 14]
    at freemarker.core.InvalidReferenceException.getInstance(InvalidReferenceException.java:98)
    at freemarker.core.UnexpectedTypeException.newDesciptionBuilder(UnexpectedTypeException.java:41)
    at freemarker.core.UnexpectedTypeException.<init>(UnexpectedTypeException.java:24)
    at freemarker.core.Dot._eval(Dot.java:81)
    at freemarker.core.Expression.eval(Expression.java:111)
    at freemarker.core.ListLiteral.getModelList(ListLiteral.java:126)
    at freemarker.core.MethodCall._eval(MethodCall.java:94)
    at freemarker.core.Expression.eval(Expression.java:111)
    at freemarker.core.Expression.evalAndCoerceToString(Expression.java:115)
    at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
    at freemarker.core.Environment.visit(Environment.java:265)
    at freemarker.core.MixedContent.accept(MixedContent.java:93)
    at freemarker.core.Environment.visit(Environment.java:265)
    at freemarker.core.EscapeBlock.accept(EscapeBlock.java:85)
    at freemarker.core.Environment.visit(Environment.java:265)
    at freemarker.core.MixedContent.accept(MixedContent.java:93)
    at freemarker.core.Environment.visit(Environment.java:265)
    at freemarker.core.Environment.process(Environment.java:243)
    at org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:223)
    ... 36 more

Re: Custom Datalist with Alvex Datagrid

vhelmut — Sun, 07 May 2017 10:49:19 GMT

Hi, Lawrence!

I try to understand brief. Say please if i understand you correctly:

You create or edit datalist item;
Click button Save;
When try to use filter?

the filter will not work after clicking the create new item or edit item buttons and not hitting save.

If you try to find something when there is an open modal window and this issue is reproduced I think it's normal: you don't complete one transaction and try to start new.

If you don't mind, I suggest you to define exact sequence of actions, next i'll try to reproduce issue

Have a nice day!

Re: Custom Datalist with Alvex Datagrid

lmaorence — Mon, 08 May 2017 01:50:57 GMT

Ok here's what happpens:
1. Create / Edit datalist item (modal window opens)

2. Click "Cancel" or close the modal

3. Then there's the issue, filter is not working

But when you try:

1. Create / Edit datalist item (modal window opens)

2. Click "Save"

3. Filter is working

I think the problem is when you hit Cancel or just close the modal window, The buttons from the modal still persists and conflicts with filter's buttons. But when you hit Save, the list refreshes and also the filter thus (maybe) moving filter buttons up the reference stack making it work. idk haha