Improve current search dialog box
Description
Environment
None
Attachments
1
- 22 Jan 2013, 03:28 AM
relates to
Activity
Show:
Juliana Corredor T. January 22, 2013 at 3:28 AM
CORRECT BUG:
1) Lookup button on toolbar continues to insert a new record
Carlos Ruiz October 23, 2012 at 7:14 AM
https://bitbucket.org/idempiere/idempiere/changeset/446e6cc
https://bitbucket.org/idempiere/idempiere/changeset/b251024
Fixed by Heng Sin can't search using invisible lookup field ( for e.g, CreatedBy and UpdatedBy ).
Carlos Ruiz October 3, 2012 at 2:52 AM
False alarm - Deepak let us notice that it was wrong configuration.
Juliana Corredor T. September 20, 2012 at 10:09 PM
Appear exception in the console when I open a window
09:56:32.914===========> GridTable.open: Count SQL=SELECT COUNT(*) FROM AD_Schedule WHERE (Processed='N' OR Updated>SysDate-1) AND AD_Schedule.AD_Client_ID=0 AND AD_Schedule.AD_Org_ID=0 AND (AD_Schedule.AD_Schedule_ID IS NULL OR AD_Schedule.AD_Schedule_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 200020 AND AD_User_ID <> 100 AND IsActive = 'Y' )) [17]
org.postgresql.util.PSQLException: ERROR: no existe la columna «processed»
Position: 41; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:125)
at $Proxy0.executeQuery(Unknown Source)
at org.compiere.model.GridTable$Loader.open(GridTable.java:3338)
at org.compiere.model.GridTable.open(GridTable.java:609)
at org.compiere.model.GridTab.query(GridTab.java:754)
at org.adempiere.webui.panel.ADTabpanel.query(ADTabpanel.java:711)
at org.adempiere.webui.panel.AbstractADWindowPanel.initFirstTabpanel(AbstractADWindowPanel.java:540)
at org.adempiere.webui.panel.AbstractADWindowPanel.initTab(AbstractADWindowPanel.java:528)
at org.adempiere.webui.panel.AbstractADWindowPanel.initPanel(AbstractADWindowPanel.java:306)
at org.adempiere.webui.panel.ADWindowPanel.initPanel(ADWindowPanel.java:208)
at org.adempiere.webui.window.ADWindow.doCreatePart(ADWindow.java:79)Fixed
Details
Assignee
Deepak PansheriyaDeepak PansheriyaReporter
Carlos RuizCarlos RuizLabels
Components
Priority
Major
Details
Details
Assignee
Deepak PansheriyaReporter
Carlos RuizLabels
Components
Priority
MajorCreated August 9, 2012 at 9:29 AM
Updated March 13, 2014 at 2:20 PM
Resolved October 3, 2012 at 2:52 AM
For better usability we want to improve current search dialog box with the following proposals:
Remove history button from toolbar and implement the same options into search box
Implement saved searches drop-down from search button
Implement or and parenthesis search (like Adaxa did for Swing) - note that MjMcKay already did some port work for zkwebui
Add search sequence support for search dialog (this is something like adding a column AD_Column.SearchSeqNo)
Review the operators for all reference (for example IDs just allow equal (=), but it could allow more ( > >= < <= ...)