APP> Database filter and table filter> multiple option comma sperator

laurent_h's profile image laurent_h posted 7 years ago in General Permalink

Hi,

Is it possible in the main interface to add a comma , or ; to database and table filter ?

Example : I want to filter only table tha begins by Lab and Xlab :

so I type in table filter => Lab; Xlab the tree is updated with table begins by Lab or Xlab

Thanks

kalvaro's profile image kalvaro posted 7 years ago Permalink

Try this:

^x?lab
laurent_h's profile image laurent_h posted 7 years ago Permalink

Hi,

not working and not simple way...

Thank you

ansgar's profile image ansgar posted 7 years ago Permalink

That should work, as it works here, exactly like kalvaro wrote.

Welcome to the world of regular expressions, by the way :)

kalvaro's profile image kalvaro posted 7 years ago Permalink

not working and not simple way...

Is there something you haven't told us?

No filter:

No filter

Filter:

Filter

laurent_h's profile image laurent_h posted 7 years ago Permalink

Hi,

It doesn't work I have Windows 7 - HeidiS QLversion 9.4.0.5174

Very stange...

But this sequence works: ^(x|lab)

Thank you

ansgar's profile image ansgar posted 7 years ago Permalink

Strange.

However, ^(x|lab) will find all tables starting with an x. Well, not necessarily a problem.

kalvaro's profile image kalvaro posted 7 years ago Permalink

It doesn't work I have Windows 7 - HeidiS QLversion 9.4.0.5174

Very stange...

But this sequence works: ^(x|lab)

Could you please share a screen-shot?

laurent_h's profile image laurent_h posted 7 years ago Permalink

Hi,

the goal is to list all tables that begins by : E or P, here three screenshot :

  • no filter
  • filter bug
  • filter ok
3 attachment(s):
  • hgeisql_nofilter
  • hgeisql_filter_bug
  • hgeisql_filter_ok
kalvaro's profile image kalvaro posted 7 years ago Permalink

I meant a screen-shot related to the question you've asked in this thread...

laurent_h's profile image laurent_h posted 7 years ago Permalink

Hi,

Sorry I can't beacause it is confidential data...

Thanks again

Please login to leave a reply, or register at first.