Hi Listers,
To my surprise a search like '112' LIKE "%'" + $USER$ + "'%" doesn't work in
9.1.x anymore!
I peeked into the sql log and I think I know why:
SELECT * FROM (SELECT AR_SQL_Alias1 FROM (SELECT T426.C1 FROM T426 WHERE
(T426.C112 LIKE '%'' || ';ize0578' || ';'%') ORDER BY T426.C1 ASC)
AR_SQL_Alias1 > 0) AND (AR_RowNumber_Alias$1 < 1102) AND (rownum < 1102))
Since the data in the Assignee Group field (FieldId: 112) is stored like this:
;'username1’; a query like T426.C112 LIKE '%'' || ';ize0578' || ';'%' doesn't
make much sense, does it?
Anyway I just checked Mid Tier 9.1.04 connected to an ARS 7.6.4 server and the
search '112' LIKE "%'" + $USER$ + "'%" is still being correctly transformed into
SELECT * FROM ( SELECT
T3694.C1,C536870915,C536870914,C8,C7,C112,C2,C3,C5,C6,C536870920 FROM T3694
WHERE (T3694.C112 LIKE (('%''' || 'ize0578') || '''%')) ORDER BY C536870915
DESC, 1 ASC ) WHERE ROWNUM <= 1001
and works of course.
Thomas--
ARSList mailing list
[email protected]
https://mailman.rrr.se/cgi/listinfo/arslist
