AnsweredAssumed Answered

ADDITIONAL_WHERE & dtlLookup

Question asked by melis.yazici on Jul 7, 2017
Latest reply on Jul 10, 2017 by Lindsay_Estabrooks

Hello,

 

I used  ADDITIONAL_WHERE on the dtlLookup. But I have an error in the stdlog file. Do you have another method?

 

 

<PDM_MACRO name=dtlLookup hdr="New Group" attr=group evt="onBlur=\\\"detailSyncEditForms(this)\\\"" extraURL="ADDITIONAL_WHERE=id != U'9E11F5F8EE741D44BB269EAD569535FA'" make_required=yes>

 

 

07/07 14:56:43.42 TESTSDAPP01 domsrvr 11844 ERROR where.y 908 Parse error at : "type = 2308 AND delete_flag = 0 AND last_name LIKE 'arçelik%' AND id != U'9E11F5F8EE741D44BB269EAD569535FA'@@member_list.member IN (U'297AC2C6251A25439A7E8FFF15360D07')" (syntax error)
07/07 14:56:43.42 TESTSDAPP01 web:local 11340 ERROR freeaccess.spl 6933 error in sync_fetch: AHD03053:Bad where clause: Parse error at : "type = 2308 AND delete_flag = 0 AND last_name LIKE 'arçelik%' AND id != U'9E11F5F8EE741D44BB269EAD569535FA'@@member_list.member IN (U'297AC2C6251A25439A7E8FFF15360D07')" (syntax error) in the function: generate_autosuggest_response()

Outcomes