metasfresh / metasfresh-webui-api-legacy

metasfresh webui API server
GNU General Public License v3.0
30 stars 32 forks source link

error in picking on pick hu by number #543

Open metas-lc opened 7 years ago

metas-lc commented 7 years ago

Is this a bug or feature request?

bug

What is the current behavior?

cannot use "pick hu by number" in picking

Which are the steps to reproduce?

  1. open picking https://w101.metasfresh.com:8443/window/540345?viewId=540345-8ef8ec1a515a48ef88a38c38aec2c881&page=1
  2. select a line
  3. select pick
  4. dropdown -> pick hu by number
  5. start writing something =>

Error: org.postgresql.util.PSQLException: ERROR: column m_hu.m_hu_item_parent... Server error org.postgresql.util.PSQLException: ERROR: column m_hu.m_hu_item_parent does not exist Hint: Perhaps you meant to reference the column "m_hu.m_hu_item_parent_id". Position: 298 SQL: SELECT M_HU.M_HU_ID,NULL,concatws('', NULLIF (TRIM(M_HU.Value), ''), ( select NULLIF (TRIM(M_HU_PI_Version.Name), '') from M_HU_PI_Version where M_HU_PI_Version.M_HU_PI_Version_ID=M_HU.M_HU_PI_Version_ID)),M_HU.IsActive FROM M_HU WHERE / validation rule / ( M_HU.HUStatus='A' AND COALESCE(M_HU.M_HU_Item_Parent,0)<=0 ) AND / filter / unaccent_string(concatws('', NULLIF (TRIM(M_HU.Value), ''), ( select NULLIF (TRIM(M_HU_PI_Version.Name), '') from M_HU_PI_Version where M_HU_PI_Version.M_HU_PI_Version_ID=M_HU.M_HU_PI_Version_ID)), 1) ILIKE unaccent_string('%1%', 1) AND / active / ('N'='Y' OR M_HU.IsActive='Y') AND / security-client / M_HU.AD_Client_ID IN (0,1000000) / security-record / AND M_HU.M_HU_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 540516 AND AD_User_ID <> 2188223 AND IsActive = 'Y' ) ORDER BY 3 OFFSET 0 LIMIT 10

What is the expected or desired behavior?

show the available HUs by the value you set

metas-ts commented 7 years ago

hi @metas-lc we removed that process anyways, but the underlying problem might still be there..do you know about other processes with HU-parameters? or othere places where one can serach for an HU via autocomplete?

Also, if you can, plase provide the stacktrace when you find such errors :-)