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

laurent_h posted 12 months ago in General

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 posted 12 months ago

Try this:

^x?lab
laurent_h posted 12 months ago

Hi,

not working and not simple way...

Thank you

ansgar posted 12 months ago

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

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

kalvaro posted 12 months ago

not working and not simple way...

Is there something you haven't told us?

No filter:

No filter

Filter:

Filter

laurent_h posted 12 months ago

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 posted 12 months ago

Strange.

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

kalvaro posted 12 months ago

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 posted 12 months ago

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 posted 11 months ago

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

laurent_h posted 11 months ago

Hi,

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

Thanks again

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