CA Service Management

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()

Try this

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

Hi,

I get another error in the stdlog file.Do you have another method?

07/10 08:50:10.78 TESTSDAPP01    domsrvr              2284 ERROR        where.y                908 Parse error at : "( type = 2308 AND delete_flag = 0 AND last_name LIKE 'copste%' AND persistent_id != 'cnt:9E11F5F8EE741D44BB269EAD569535FA'@@member_list.member IN (U'297AC2C6251A25439A7E8FFF15360D07') ) AND ( id!=U'AC..." (syntax error)

07/10 08:50:10.80 TESTSDAPP01    web:local            7108 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 'copste%' AND persistent_id != 'cnt:9E11F5F8EE741D44BB269EAD569535FA'@@member_list.member IN (U'297AC2C6251A25439A7E8FFF15360D07') ) AND ( id!=U'AC..." (syntax error) in the function: generate_autosuggest_response()

Hi,

could you try this one?

<PDM_MACRO name=dtlLookup hdr="New Group" attr=group evt="onBlur=\\\"detailSyncEditForms(this)\\\"" extraURL="QBE.NE.id=9E11F5F8EE741D44BB269EAD569535FA" make_required=yes>

Regards,

cdtj

I wonder if you are experiencing this issue:ADDITIONAL_WHERE BROKEN AFTER APPLYING 14.1.02