QueryByExcample

[HeikoOssi]

at QueryByExcample the sql text in upper input field is often not changed anymore.

 

[Marco Kalter]

I cannot immediately reproduce this. Do you have a reproducible scenario?

 

[HeikoOssi]

1.)
i write my sql statement in sql window
select t.test_field from my_table t ;

2.) i click switch 'QueryByExample'

3.) i write a filter 'TEST' in field test_field

In old version the sql text is automatic modified in
select t.test_field from my_table t where test_field = 'TEST';

In beta version the sql text stay unchanged

 

[Marco Kalter]

We'll investigate this.

 

[HeikoOssi]

any news about it?
In version 13 (also beta 6) the behaviour of QueryByExample has changed compared to version 12

 

[Marco Kalter]

We cannot reproduce this yet. It works exactly the same as in 12.0.

Can you send us some screenshots to visualize the problem?

 

[HeikoOssi]

I have described the problem by mail

 

[Marco Kalter]

Thanks. It seems that the editor is not updated if you do not leave the QBE field. For your example with 1 field this therefore never happens.

We'll fix it.

 

[HeikoOssi]

is works if i have one query in sql window.
When i have multible in one sql window and query results in separate tabs then the filters are not transferred in sql text again.

 

[Marco Kalter]

This is a limitation that has always existed.