[Multiple Selection Dropdown Widget (Reactive And Mobile)] pass multiple selected value from dropdown in IN clause

Solved

[Multiple Selection Dropdown Widget (Reactive And Mobile)] pass multiple selected value from dropdown in IN clause

Question

JavaScript

SQL

Aggregate

Reactive

Forge

Application Type

Reactive

Hi,
I'm trying to pass the selected items from dropdown, convert them into list using split() in js and them pass the list into SQL IN clause to get data from entity.

On passing input as "C4C","CaptureMail" in SQL for testing purpose gives error. so I don't know what to do. Unfortunately, on converting them into list gives me error as below.

Dropdown:

Error:

JS :
$parameters.selectedProject = (document.querySelector('#b4-CurrentSelectedItems').textContent).split(",");

SQL :

SELECT {allappsdata}.[IssueType], Count({allappsdata}.[IssueType]) FROM {allappsdata} WHERE {allappsdata}.[Impactedsystem] IN (@impactedsystem) GROUP BY {allappsdata}.[IssueType]

Also it is not possible to test SQL when I use IN clause.

Apologies, but I cannot upload an OML as I have private data.

13 days ago

Solution

Hi Aman,

You don't need to use javascript for that. I'm attaching a full example on how to achieve this.

Take a look at the SQL query in the "GetSelectedItems" data action to see how to correctly configure the input parameter and set its test value:

See solution in context

MultiSelectDemo.oml

12 days ago

13 replies

Last reply 7 days ago

Show thread

Hide thread

Hi,

Thank you for the reply. can you please share OML again ? On downloading, the file name comes as download and size is 0kb

12 days ago

Replying to Aman Devrath's comment on 24 Jun 2022 10:58:30

Here it is. The download did work on my side though.

MultiSelectDemo.oml

12 days ago

Hi Aurelio,

Thank you for jumping in so quickly with an excellent example .oml to help Aman.

Great work!

Kind Regards,
Chris.

12 days ago

Hi Aurelio,

I'm getting below error when I'm trying it in my application. Even yours is giving me error if I try to change something, If i don't change anything it works perfectly.

Regards,
Aman

9 days ago

Replying to Aman Devrath's comment on 27 Jun 2022 06:37:31

Hello,

What exactly do you mean by "change something"? What are you changing?

9 days ago

Replying to Aurelio Junior's comment on 27 Jun 2022 07:01:24

Hi,

I moved the condition in the same line as WHERE keyword.

9 days ago

Replying to Aman Devrath's comment on 27 Jun 2022 07:05:03

You're probably missing the value for the "SelectedIds" input parameter in the "Test Inputs" tab, as shown in one of the screenshots in my first reply.

9 days ago

Replying to Aman Devrath's comment on 27 Jun 2022 07:05:03

If the {TestData}.[Id] column holds string values, you want @SelectedIds = "'a','b','c','d'" (notice each item is a SQL string - has single quotes around it).

If the {TestData}.[Id] column holds integer values, you want @SelectedIds = "1,2,3" (notice each item is an integer)

Hope this solves your issue.

9 days ago

Solution

To answer your question on how to get the returned list (here so others can benefit)

To get the returned list you need to define an OnChange handler (Screen Action). It's in this action that you perform any logic you want to that uses the results of the list.

9 days ago

Hi @Aurelio Junior ,

Thank you for the help. It worked perfectly. As you said, I missed the test inputs, I didn't understand why I needed to pass the test inputs. Should the SQL work regardless of the inputs?

Anyways, Marking yours and Chris's answer as solution.

Regards,
Aman Devrath

8 days ago

Replying to Aman Devrath's comment on 28 Jun 2022 07:47:13

Hi Aman,

Happy to hear all's working now.

When you set a parameter's "Expand Inline" property to Yes, you're specifying that the parameter's value is going to be a part of your SQL command. So if you ommit the Test Value when testing the query, you'll end up with an incomplete SQL statement and, thus, an incorrect syntax error.

8 days ago

Replying to Chris Stacey's comment on 27 Jun 2022 07:28:23

To add to the above mentioned answer gave by Chris.
I assigned MenuItems (of MultiSelect_ReactAndMobOnChange action) to itself and then assigned the value of MenuItems to a local variable - MenuItemsVar - of MultiSelect_ReactAndMob List type.

Regards,
Aman Devrath

8 days ago

Replying to Aman Devrath's comment on 28 Jun 2022 07:53:32

Glad we could help.

Good luck with your developing!

7 days ago

Solution

To answer your question on how to get the returned list (here so others can benefit)

To get the returned list you need to define an OnChange handler (Screen Action). It's in this action that you perform any logic you want to that uses the results of the list.

See solution in context

9 days ago

Solution

Hi Aman,

You don't need to use javascript for that. I'm attaching a full example on how to achieve this.

Take a look at the SQL query in the "GetSelectedItems" data action to see how to correctly configure the input parameter and set its test value:

MultiSelectDemo.oml

12 days ago

13 replies

Last reply 7 days ago

Show thread

Hide thread

Hi,

Thank you for the reply. can you please share OML again ? On downloading, the file name comes as download and size is 0kb

12 days ago

Replying to Aman Devrath's comment on 24 Jun 2022 10:58:30

Here it is. The download did work on my side though.

MultiSelectDemo.oml

12 days ago

Hi Aurelio,

Thank you for jumping in so quickly with an excellent example .oml to help Aman.

Great work!

Kind Regards,
Chris.

12 days ago

Hi Aurelio,

I'm getting below error when I'm trying it in my application. Even yours is giving me error if I try to change something, If i don't change anything it works perfectly.

Regards,
Aman

9 days ago

Replying to Aman Devrath's comment on 27 Jun 2022 06:37:31

Hello,

What exactly do you mean by "change something"? What are you changing?

9 days ago

Replying to Aurelio Junior's comment on 27 Jun 2022 07:01:24

Hi,

I moved the condition in the same line as WHERE keyword.

9 days ago

Replying to Aman Devrath's comment on 27 Jun 2022 07:05:03

You're probably missing the value for the "SelectedIds" input parameter in the "Test Inputs" tab, as shown in one of the screenshots in my first reply.

9 days ago

Replying to Aman Devrath's comment on 27 Jun 2022 07:05:03

If the {TestData}.[Id] column holds string values, you want @SelectedIds = "'a','b','c','d'" (notice each item is a SQL string - has single quotes around it).

If the {TestData}.[Id] column holds integer values, you want @SelectedIds = "1,2,3" (notice each item is an integer)

Hope this solves your issue.

9 days ago

Solution

To answer your question on how to get the returned list (here so others can benefit)

To get the returned list you need to define an OnChange handler (Screen Action). It's in this action that you perform any logic you want to that uses the results of the list.

9 days ago

Hi @Aurelio Junior ,

Thank you for the help. It worked perfectly. As you said, I missed the test inputs, I didn't understand why I needed to pass the test inputs. Should the SQL work regardless of the inputs?

Anyways, Marking yours and Chris's answer as solution.

Regards,
Aman Devrath

8 days ago

Replying to Aman Devrath's comment on 28 Jun 2022 07:47:13

Hi Aman,

Happy to hear all's working now.

8 days ago