Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-1583

Not able to search filter Customer Request Type

XMLWordPrintable

      NOTE: This bug report is for JIRA Service Desk Server. Using JIRA Service Desk Cloud? See the corresponding bug report.

      User is unable to search Customer Request Type from Issue Search Filters.

      When using the basic mode, the Customer Request Type is grayed and un-clickable. Hovering on top on it, shows an error that says :

      Customer Request Type is not applicable for the current project and /or issue type.

      It also does not work with JQL using the advance search option.

      I have verified this with my own machine.

      Workaround:

      Thanks efridge for the tips!

      Customer Request Type values follow the format of "key/lowercased-form-title-hyphenated", so it may be possible to guess.
      For example project key of "ITS":

      1. General Assistance = its/general-assistance
      2. Infrastructure Support = its/infrastructure-support
      3. Telecommunications / Telephones = its/telecommunications--telephones (notice the double hyphen on this one)

      I've also noticed that this value is determined when the form is FIRST created, and if you change the name of the form, it doesn't change the title. I've also seen some values that look like "req/its-request2" where it apparently added a number on the end to make it unique. I think that happened because I had two identically named forms when I first set up that project.
      Maybe that will help you reverse engineer things and get some queries working.

      PSQL Query that can be used to identify Customer Request type name formatting:

      select distinct stringvalue from customfieldvalue cfv
where cfv.customfield = (select id from customfield where cfname = 'Customer Request Type') ;

        1. cust_request_type_group.png
          51 kB
          Aaron St.George
        2. image-2017-02-22-16-29-56-201.png
          122 kB
          Stacy Krueger

            [JSDSERVER-1583] Not able to search filter Customer Request Type

            Jacques added a comment - - edited

            @stacy: In the newer JSD versions, the customer request type name should be as you've written it in your request type list. In your example this would be:

            .... AND ..."Customer Request Type" = "Information Systems"

            Unless you're using Microsoft SQL as a database. Then you'll have to wait for JSD 3.4.2. See more here: https://jira.atlassian.com/browse/JSDSERVER-3715

            Jacques added a comment - - edited @stacy: In the newer JSD versions, the customer request type name should be as you've written it in your request type list. In your example this would be: .... AND ... "Customer Request Type" = "Information Systems" Unless you're using Microsoft SQL as a database. Then you'll have to wait for JSD 3.4.2. See more here:  https://jira.atlassian.com/browse/JSDSERVER-3715

            Stacy Krueger added a comment -

            In Service Desk server 3.3.0 I cannot search with the workaround. 

             

            Stacy Krueger added a comment - In Service Desk server 3.3.0 I cannot search with the workaround.   

            Marlene Cote added a comment -

            Marty,
            is there any way you can fix this in the 2.5.9 version, please?????
            thanks,
            Marlene

            Marlene Cote added a comment - Marty, is there any way you can fix this in the 2.5.9 version, please????? thanks, Marlene

            robertno added a comment -

            You cannot seem to search across multiple projects though e.g. the format is "<ProjectCode>/<Request Name>", but what if you want to search <Request Name> across all Projects?

            I guess the simple answer is: in ("<ProjectCode1>/<Request Name>", <ProjectCode2>/<Request Name>") etc. but wondering is there a global query that does not rely on explicitly adding every project

            robertno added a comment - You cannot seem to search across multiple projects though e.g. the format is "<ProjectCode>/<Request Name>", but what if you want to search <Request Name> across all Projects? I guess the simple answer is: in ("<ProjectCode1>/<Request Name>", <ProjectCode2>/<Request Name>") etc. but wondering is there a global query that does not rely on explicitly adding every project

            Marlene Cote added a comment -

            But that version is not available for jira 6.X

            Marlene Cote added a comment - But that version is not available for jira 6.X

            Marty (Inactive) added a comment -

            Hi marlene.cote,
            this is fixed in Jira Service Desk 3.1.0.

            Thanks,
            Marty

            Marty (Inactive) added a comment - Hi marlene.cote , this is fixed in Jira Service Desk 3.1.0. Thanks, Marty

            Marlene Cote added a comment -

            what release of service desk is this resolved in please? I have 2.5.9 and my installation shows no updates available.

            Marlene Cote added a comment - what release of service desk is this resolved in please? I have 2.5.9 and my installation shows no updates available.

            Steven F Behnke added a comment -

            Are you using Service Desk Cloud?

            Steven F Behnke added a comment - Are you using Service Desk Cloud?

            Michael Ultes added a comment -

            same for me

            Michael Ultes added a comment - same for me

            Sudha added a comment -

            I dont think the issue is resolved

            Sudha added a comment - I dont think the issue is resolved

              Unassigned Unassigned
              astephen@atlassian.com Adrian Stephen
              Affected customers:
              54 This affects my team
              Watchers:
              67 Start watching this issue

                Created:
                Updated:
                Resolved: