InfoQube IM - Community

Submitted by lbw2112 on 2020/05/16 16:42

Hi,

I'm trying to learn InfoQube better and know i can do this through fields, but I want to know if it can be done in filter. I did read about Filters and everything but nothing I was trying was working.

I'm trying to create a Grid Filter to not include Items with a certain word in them. I've tried a few things but none are working so I don't know if I just don't have the right syntax or if I'm just doing it plain wrong.

This is what I have-

Journal entries mostly with Item names like this: Journal 20200516 Saturday, May 16, 2020.

I have supplementary Items with just the word at the end like this: Journal 20200516 Saturday, May 16, 2020 Supplementary

I have a grid containing all,Journal Items, plus one of just the Supplementary Items (by Grid Filter). I'm also looking to have a a grid that I can just not show the Supplementary items in it through the filter.

I've tried NOT and a few other things but don't think I'm using them correctly.

Thanks,

Larry

Comments

Hi Larry,

This should work:

[item] like "*journal*" and [item] not like "*supplem*"

BTW, it would useful, in the long term, to use a date field for the journal date, you'd gain in easier filtering / sorting. Do not hesitate to ask on how to do it using a batch command

I updated the doc with this example: Source Filter Editbox

Pierre_Admin

IQ Designer

Hi Pierre,

Thanks for the really fast response. And thanks for the solution. I wasn't anywhere close to that but you just showed me how the syntax is written.

And I appreciate the tip on using a date field. How would I go about using a batch command for that? I thought I'd have to enter every date in each Item manually.

You did an amazing job with InfoQube.

Larry

If your date format is systematic, it will be dead easy...

That is, is it always the word "journal", a space, then the date in YYYYMMDD format ?

Pierre_Admin

IQ Designer

Hi Pierre,

Yes, for sorting reasons each one is named as such

Journal Lbw 20190801 Thursday, August 1, 2019, etc.

They all begin with "Journal Lbw YYYYMMDD" format and end with other info.

Larry