topic Re: How to covert multiselect to Drop down with option of "All" values in Dashboards & Visualizations

How to covert multiselect to Drop down with option of "All" values

aditsss — Thu, 28 Jan 2021 15:39:59 GMT

Hi Everyone,

I have one requirement . I have one multiselect like below:

<fieldset submitButton="false" autoRun="true">
<input type="multiselect" token="OrgName" searchWhenChanged="true">
<label>Salesforce Org Name</label>
<choice value="*">All Salesforce Org</choice>
<search>
<query>index="abc" sourcetype="xyz" | lookup Org_Alias.csv OrgFolderName OUTPUT OrgName as OrgName | stats count by OrgName</query>
<earliest>-30d@d</earliest>
<latest>now</latest>
</search>
<fieldForLabel>OrgName</fieldForLabel>
<fieldForValue>OrgName</fieldForValue>
<prefix>(</prefix>
<valuePrefix>OrgName ="</valuePrefix>
<valueSuffix>"</valueSuffix>
<delimiter> OR </delimiter>
<suffix>)</suffix>
<initialValue>*</initialValue>
<default>*</default>
</input>

My requirement is I want to convert it into drop down . So I converted with below code:

<input type="dropdown" token="OrgName" searchWhenChanged="true">
<label>Salesforce Org Name</label>
<choice value="*">All Salesforce Org</choice>
<search>
<query>index="abc" sourcetype="xyz" | lookup Org_Alias.csv OrgFolderName OUTPUT OrgName as OrgName | stats count by OrgName</query>
</search>
<fieldForLabel>OrgName</fieldForLabel>
<fieldForValue>OrgName</fieldForValue>
<prefix>OrgName="</prefix>
<suffix>"</suffix>
<initialValue>OneForce</initialValue>
<default>OneForce</default>
</input>

This is working fine but what I want is " All Salesforce Org" value should come at end.

Can someone guide me.

Re: How to covert multiselect to Drop down with option of "All" values

ITWhisperer — Thu, 28 Jan 2021 15:58:46 GMT

Try moving the choice to after the search

<input type="dropdown" token="OrgName" searchWhenChanged="true"> <label>Salesforce Org Name</label> <search> <query>index="abc" sourcetype="xyz" | lookup Org_Alias.csv OrgFolderName OUTPUT OrgName as OrgName | stats count by OrgName</query> </search> <choice value="*">All Salesforce Org</choice> <fieldForLabel>OrgName</fieldForLabel> <fieldForValue>OrgName</fieldForValue> <prefix>OrgName="</prefix> <suffix>"</suffix> <initialValue>OneForce</initialValue> <default>OneForce</default> </input>

Re: How to covert multiselect to Drop down with option of "All" values

aditsss — Thu, 28 Jan 2021 16:10:20 GMT

@ITWhisperer

I have done like this but still "All Salesforce Org" is coming at the top.

I have made "OneForce" as default and initial and I want " All Salesforce Org" should come at the end.

<input type="dropdown" token="OrgName" searchWhenChanged="true">
<label>Salesforce Org Name</label>
<search>
<query>index="abc" sourcetype="xyz" | lookup Org_Alias.csv OrgFolderName OUTPUT OrgName as OrgName | stats count by OrgName</query>
</search>
<choice value="*">All Salesforce Org</choice>
<fieldForLabel>OrgName</fieldForLabel>
<fieldForValue>OrgName</fieldForValue>
<prefix>OrgName="</prefix>
<suffix>"</suffix>
<initialValue>OneForce</initialValue>
<default>OneForce</default>
</input>

Attached is the screenshot for the same.

Re: How to covert multiselect to Drop down with option of "All" values

ITWhisperer — Thu, 28 Jan 2021 16:17:39 GMT

Looks like they are in alphabetical order - try reversing the order returned by the query and see if it gets re-ordered back to alphabetical. If it doesn't you could try appending a result to query to represent the all option you want.

Re: How to covert multiselect to Drop down with option of "All" values

aditsss — Thu, 28 Jan 2021 16:25:20 GMT

@ITWhisperer

"All Salesforce Org" is coming before Accertify.

All the values in drop down are different different Orgs and their is one common option that is "All Salesforce Org" .

How can I put it at the end.

<input type="dropdown" token="OrgName" searchWhenChanged="true">
<label>Salesforce Org Name</label>
<search>
<query>index="abc" sourcetype="xyz" | lookup Org_Alias.csv OrgFolderName OUTPUT OrgName as OrgName | stats count by OrgName</query>
</search>
<choice value="*">All Salesforce Org</choice>
<fieldForLabel>OrgName</fieldForLabel>
<fieldForValue>OrgName</fieldForValue>
<prefix>OrgName="</prefix>
<suffix>"</suffix>
<initialValue>OneForce</initialValue>
<default>OneForce</default>
</input>

How can I reverse . Please guide.

Re: How to covert multiselect to Drop down with option of "All" values

ITWhisperer — Fri, 29 Jan 2021 09:33:39 GMT

As I said "If it doesn't you could try appending a result to query to represent the all option you want."

<input type="dropdown" token="OrgName" searchWhenChanged="true"> <label>Salesforce Org Name</label> <search> <query>index="abc" sourcetype="xyz" | lookup Org_Alias.csv OrgFolderName OUTPUT OrgName as OrgName | dedup OrgName | eval Value=OrgName | append [| makeresults | eval OrgName="All Salesforce Org" | eval Value="*" ]</query> </search> <fieldForLabel>OrgName</fieldForLabel> <fieldForValue>Value</fieldForValue> <prefix>OrgName="</prefix> <suffix>"</suffix> <initialValue>OneForce</initialValue> <default>OneForce</default> </input>

Re: How to covert multiselect to Drop down with option of "All" values

aditsss — Fri, 29 Jan 2021 13:57:25 GMT

@ITWhisperer

you are best as always thank you.