Customer configures a form field using 'Dynamic Query' with a query 'Select locationname from servicedesklocationmaster'and maps it to the additional field drop down of a project but the field is not getting loaded with the required values. Any issue?

hari · March 10, 2021, 11:11am

The dynamic queries for the drop down fields should always be configured with two columns in the select query. For e.g., the correct query will be “Select locationname, locationname from servicedesklocationmaster where locationname <> ‘’ order by location name”

Important Note: The first column used in the query will be stored in the DB (you may also provide LocationID in this case), wherease the second column used in the query will be used for display purpose i.e., to show the value in the UI (ticket submit / edit page). Please configure the query as per your use case.

Topic	Replies	Views
How customer can add few additional fields under the users record listing view who have only the 'Submitter' role access, as customer doesn't have the option to customize the view to add the fields he require for the users who have only submitter roles? Fields, Forms and Validations how-to	271	March 10, 2021
While submitting a request, the 'Impacted Asset' drop down is used to select the asset against which the record is being submitted. One of the customer wanted to display 'Hostname' instead of asset numbers in this dropdown. How will you achieve this? Fields, Forms and Validations how-to	254	March 10, 2021
Customer has added a state called 'Assign to helpdesk'. When he is trying to change the state, he is not getting the 'Technician/user list selection' to assign the record to a owner. Any configuration mistake causing this issue? Service Desk Settings how-to , faq	247	March 10, 2021
Do you have an option to control next possible state display based on Additional field value of record? State Machine and Workflow how-to	312	March 29, 2021
How do we come to know the availability of a Technician based on his current workload with respect to record assignment? Service Desk how-to	281	March 24, 2021

Customer configures a form field using 'Dynamic Query' with a query 'Select locationname from servicedesklocationmaster'and maps it to the additional field drop down of a project but the field is not getting loaded with the required values. Any issue?

Related Topics