What does the server side sql log show when you try to run the setfield through a filter?
On Thu, Mar 15, 2018 at 10:09 AM, Thomas Miskiewicz <tmiskiew@gmail.com> wrote:
Hi Listers,
I got a strange problem: a filter is doing a set fields and finding nothing. I can find the record using the GUI though.
In the client side log I see:
SELECT * FROM (SELECT AR_SQL_Alias0000000000002171 FROM (SELECT T4474.C536870919, T4474.C1 FROM T4474 WHERE ((T4474.C536870921 = '000000000000217') AND (T4474.C536870930 = 0) AND (T4474.C536870913 = 'id')) ORDER BY T4474.C1 ASC NULLS FIRST ) AR_SQL_Alias1 > 0) AND (AR_RowNumber_Alias1.*, rownum as AR_RowNumber_Alias1) WHERE ((AR_RowNumber_Alias1 < 104) AND (rownum < 104))
I tried:
SELECT AR_SQL_Alias0000000000002171 FROM (SELECT T4474.C536870919, T4474.C1 FROM T4474 WHERE ((T4474.C536870921 = '000000000000217') AND (T4474.C536870930 = 0) AND (T4474.C536870913 = 'id')) ORDER BY T4474.C1 ASC NULLS FIRST )
in the Oracle Developer and it works just fine, i.e. finding what the filter was supposed to be finding.
BTW, what is that AR_SQL_Alias thing? Is there any article on that? I was never run such a query I took from the client side (Mid Tier) log as the Oracle Developer say “SQL command not properly ended”…