How to avoid the some rows coming in a particular column when pulling from the database

[Anonymous]

Hi,

I have a table with many rows in a particular columsn.

My requirement is I have to avoid or fish out only particular rows from a particular column onto the qlivkiew table.

Wondering how can do I do that in the load script.

I am attaching the picture for your reference.

I want to have only the green color fields in the list box not the red colored one.

Any help is highly appreciated.

regards,

Vamsi.

[sunny_talwar]

Since you are now doing this in the SQL, you need to use SQL equivalent of WildMatch which I think is using Like....

So something like this

SQL SELECT *

  , to_char(recorded_at,'Mon-YYYY') AS date_selector

  , to_char(recorded_at,'YYYYMM') AS date_selector_1

FROM "myhealth_production"."public"."statistic_counters"

Where group_name not in ('Conversation', 'Message') and

          (group_name Like '*service-270*' or group_name Like '*service-271*');

May be you don't need the first statement now because you have more restrictive 2nd statement on group_name. So, this:

SQL SELECT *

  , to_char(recorded_at,'Mon-YYYY') AS date_selector

  , to_char(recorded_at,'YYYYMM') AS date_selector_1

FROM "myhealth_production"."public"."statistic_counters"

Where (group_name Like '*service-270*' or group_name Like '*service-271*');

[Anonymous]

Hi sunny,

It is not throwing error but unless i use Where group_name not in ('Conversation', 'Message') statement , I am not getting any values in the group name. All those '*service-270*' or group_name Like '*service-271 data is inside the group name  which are not in the 'conversation and message' .Dont know how to do this. dat

[stabben23]

in sql, use % instead of *

[Anonymous]

Thanks Staffan .It worked fine now.

[Anonymous]

Thanks sunny It worked fine now.

Great stuff.

Really appreicated.