BookmarkSubscribe
Choose Language Hide Translation Bar
Françoise
Community Trekker

Selection filter in sql query builder with JMP14

Hello,

 

I have a sql query builder with a selection in the filter like this:

image pb sql query.png

 

then I save the sql query builder and close it.

Wen I open it, I have the filter with this selection retained:

image pb sql query v2.png

 It means that the filter doesn't want to select a word written upper-case and lower-case. only one is selected.: in this exemple the lower-case.

 

How to have the two forms?

 

 

 

0 Kudos
3 REPLIES 3
Jeff_Perkinson
Community Manager Community Manager

Re: Selection filter in sql query builder with JMP14

This looks like a bug in the Query Builder. I'll report it and we'll try to address it in a future maintenance release.

 

Unfortunately, I can't find a workaround at the moment. 

 

I'll keep looking at it, but perhaps another community member will have an idea.

-Jeff
0 Kudos
Françoise
Community Trekker

Re: Selection filter in sql query builder with JMP14

Thanks for your answer.

How long to have this pb solved by the support?

 

best regards

0 Kudos
Françoise
Community Trekker

Re: Selection filter in sql query builder with JMP14

It's a big problem: when you have big excel files, the excel filter of the columns doesn't make the difference bettween the 2 forms.

0 Kudos