I cant seem to disable User Parameters

Answered
Avatar
Permanently deleted user
Created

Hello

Every time I use a ? te IDE thinks I want to add a parameter when actually I'm trying to search a JSON field on a postgres DB.
This is dispite going into Preferences > Database > User Parameters and unticking both the enable box and even deleting the patterns containing ?.

Any ideas?

Thanks,
Ben

Votes

9

Share

34 comments
Avatar
Jack Goslin
Created

Thanks for the info! @... will this also be fixed in PyCharm or is this functionality built differently in each product?

0
Avatar
Arina Efremova
Created

Jack Goslin Database support in other IDEs is based on the functionality of DataGrip, so yes, it should also be fixed in PyCharm 2023.2.

1
Avatar
Jack Goslin
Created

It still is not fixed in PyCharm #PY-232.9921.89 using Snowflake. I can't begin to describe how inconvenient it is to have to run *some* queries in PyCharm and and *some* queries in the Snowflake website. If this problem is 8 years old I'm going to assume it will never be fixed.

    SELECT date
         , dates.year
         , month_int
         , month_name
         , month_year
         , date_trunc_month
         , day_of_month
         , day_of_week_int
         , day_of_week_name
         , week_int
         , date_formatted_mdy
         , date_timestamp_start
         , date_timestamp_end
         , is_weekday
         , in_last_30_days
         , in_last_60_days
         , in_last_90_days
         , in_last_120_days
         , in_last_180_days
         , is_current_year
         , is_current_month
         , is_last_month
         , is_holiday
      FROM (SELECT DATEADD('day', SEQ4(), :start_date::DATE)                                             AS date
                 , YEAR(date)                                                                            AS year
                 , MONTH(date)                                                                           AS month_int
                 , TO_CHAR(date, 'MMMM')                                                                 AS month_name
                 , CONCAT(month_name, ' ', YEAR(date))                                                   AS month_year
                 , DATE_TRUNC('month', date)                                                             AS date_trunc_month
                 , DAYOFMONTH(date)                                                                      AS day_of_month
                 , DAYOFWEEK(date)                                                                       AS day_of_week_int
                 , DAYNAME(date)                                                                         AS day_of_week_name
                 , WEEK(date)                                                                            AS week_int
                 , TO_CHAR(date, 'MM-DD-YYYY')                                                           AS date_formatted_mdy
                 , date::TIMESTAMP_TZ                                                                    AS date_timestamp_start
                 , DATEADD('millisecond', -1, DATEADD('day', 1, date))                                   AS date_timestamp_end
                 , DAYOFWEEK(date) BETWEEN 1 AND 5                                                       AS is_weekday
                 , date >= DATEADD('day', -30, CURRENT_DATE)                                             AS in_last_30_days
                 , date >= DATEADD('day', -60, CURRENT_DATE)                                             AS in_last_60_days
                 , date >= DATEADD('day', -90, CURRENT_DATE)                                             AS in_last_90_days
                 , date >= DATEADD('day', -120, CURRENT_DATE)                                            AS in_last_120_days
                 , date >= DATEADD('day', -180, CURRENT_DATE)                                            AS in_last_180_days
                 , YEAR(date) = YEAR(CURRENT_DATE())                                                     AS is_current_year
                 , DATE_TRUNC('month', date) = DATE_TRUNC('month', CURRENT_DATE())                       AS is_current_month
                 , DATE_TRUNC('month', date) =
                   DATEADD('month', -1, DATE_TRUNC('month', CURRENT_DATE()))                             AS is_last_month
                 , date IN ('2023-01-02',
                            '2023-05-29',
                            '2023-07-04',
                            '2023-09-04',
                            '2023-11-23',
                            '2023-12-25'
              )                                                                                          AS is_holiday
              FROM TABLE (GENERATOR(ROWCOUNT => :days_into_future)))

 

0
Avatar
Aleksandr Molchanov
Created

Jack Goslin It's being worked on as we speak. Please follow this ticket to stay updated on the progress.

0

Please sign in to leave a comment.