Filters not found when created graph from SQL editor Question

1-This is the first case:
when we create graph directly from table.
23%20PM

All Catagory filter are shown.

2- Second Case:

When we create after written query in SQL editor , here is the query

SELECT "source"."id" AS "id", "source"."name" AS "name", "source"."linkedin_url" AS "linkedin_url", "source"."scrape_url" AS "scrape_url", "source"."notes" AS "notes", "source"."is_stealth" AS "is_stealth", "source"."created_at" AS "created_at", "source"."updated_at" AS "updated_at", "source"."education_details" AS "education_details", "source"."is_export" AS "is_export", "source"."affinity_error_response" AS "affinity_error_response", "source"."is_poi" AS "is_poi", "source"."type_of_poi" AS "type_of_poi", "source"."is_scraped" AS "is_scraped", "source"."added_by" AS "added_by", "source"."added_by_email" AS "added_by_email", "source"."tagline" AS "tagline", "source"."sales_navigator_url" AS "sales_navigator_url", "source"."companies_last_updation_date" AS "companies_last_updation_date", "source"."source" AS "source", "source"."added_on" AS "added_on", "source"."archive" AS "archive", "source"."proxycurl_error_response" AS "proxycurl_error_response", "source"."rescrape_count" AS "rescrape_count", "source"."Type of POI (Classification)" AS "Type of POI (Classification)"
FROM (SELECT "public"."persons"."is_poi" AS "is_poi", "public"."persons"."type_of_poi" AS "type_of_poi", "public"."persons"."id" AS "id", "public"."persons"."name" AS "name", "public"."persons"."linkedin_url" AS "linkedin_url", "public"."persons"."scrape_url" AS "scrape_url", "public"."persons"."notes" AS "notes", "public"."persons"."is_stealth" AS "is_stealth", "public"."persons"."created_at" AS "created_at", "public"."persons"."updated_at" AS "updated_at", "public"."persons"."education_details" AS "education_details", "public"."persons"."is_export" AS "is_export", "public"."persons"."affinity_error_response" AS "affinity_error_response", "public"."persons"."is_scraped" AS "is_scraped", "public"."persons"."added_by" AS "added_by", "public"."persons"."added_by_email" AS "added_by_email", "public"."persons"."tagline" AS "tagline", "public"."persons"."sales_navigator_url" AS "sales_navigator_url", "public"."persons"."companies_last_updation_date" AS "companies_last_updation_date", "public"."persons"."source" AS "source", "public"."persons"."added_on" AS "added_on", "public"."persons"."archive" AS "archive", "public"."persons"."proxycurl_error_response" AS "proxycurl_error_response", "public"."persons"."rescrape_count" AS "rescrape_count", CASE WHEN "public"."persons"."type_of_poi" isnull THEN 'Unclassified' ELSE "public"."persons"."type_of_poi" END AS "Type of POI (Classification)" FROM "public"."persons") "source"
WHERE "source"."is_poi" = TRUE
LIMIT 1048576

27%20PM

Then some catogaory from Filters vanish.

please suggest me solution.

Hi @varnika

  1. Post "Diagnostic Info" from Admin > Troubleshooting
  2. You are likely seeing this issue:
    https://github.com/metabase/metabase/issues/13186 - upvote by clicking :+1: on the first post

YES, I SEE THE SAME ISSUE.

but what is the solution?

@varnika I feel like I'm constantly repeating myself.

When you open topic in this forum, then please provide "Diagnostic Info" from Admin > Troubleshooting.

If you are seeing an issue, then check for comments for possible workarounds. If no workaround is written, then there probably isn't a workaround - at least not any simple workarounds.
In this case, you can create a database View, to handle the problem with null until the release of 0.39