Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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*');
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
in sql, use % instead of *
Thanks Staffan .It worked fine now.
Thanks sunny It worked fine now.
Great stuff.
Really appreicated.