jeffblankenburg

{"uuid":"6174c38a-fdac-11ee-8a4c-ab4e5d6fca92","page":{"id":264450033,"data":{"appState":"[\"~#iR\",[\"^ \",\"n\",\"appTemplate\",\"v\",[\"^ \",\"isFetching\",false,\"plugins\",[\"~#iOM\",[\"add_player_button\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"add_player_button\",\"uuid\",\"71e92930-943b-4b6b-94c9-f9b74f3f4ae5\",\"type\",\"widget\",\"subtype\",\"ButtonWidget2\",\"namespace\",null,\"resourceName\",null,\"resourceDisplayName\",null,\"template\",[\"^3\",[\"heightType\",\"fixed\",\"horizontalAlign\",\"stretch\",\"clickable\",false,\"iconAfter\",\"\",\"submitTargetId\",null,\"hidden\",false,\"text\",\"Outside Module\",\"margin\",\"4px 8px\",\"showInEditor\",false,\"tooltipText\",\"\",\"styleVariant\",\"solid\",\"submit\",false,\"iconBefore\",\"\",\"events\",[\"~#iL\",[[\"^3\",[\"event\",\"click\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"query1\",\"targetId\",null,\"params\",[\"^3\",[\"options\",[\"^ \",\"onSuccess\",null,\"onFailure\",null,\"additionalScope\",nul

jeffblankenburg

I want to conditionally have a WHERE clause depending on a choice a user makes in the UI.

When the boolean value is true, I want the where condition:

SELECT *
FROM table
WHERE boolean_value = 1

When the boolean value is false, I want no where condition:

jeffblankenburg

'use strict';

var Alexa = require('alexa-sdk');
var AWS = require('aws-sdk');
var https = require('https');
var util = require('util');

const SNS = new AWS.SNS();
console.log("SNS INITIALIZED: " + JSON.stringify(SNS));
var APP_ID = "amzn1.ask.skill.adc621ec-b41c-40ba-bc05-489b10ba392f";  // TODO replace with your app ID (OPTIONAL).

jeffblankenburg

Aditi
Amy
Astrid
Bianca
Brian
Camila
Carla
Carmen
Celine
Chantal

jeffblankenburg

[Card Number] [Player(s)] [Team] [Available Quantity]

U-3	Trea Turner, Wilmer Difo	Washington Nationals	1
U-4	Mike Trout	Los Angeles Angels	3
U-5	Starlin Castro	Washington Nationals	3
U-9	Ken Griffey Jr.	Seattle Mariners	1
U-10	Anthony Alford	Toronto Blue Jays	2
U-11	Chris Owings	Colorado Rockies	1
U-12	Aaron Bummer	Chicago White Sox	1
U-13	Jose Martinez	Tampa Bay Rays	1

jeffblankenburg

U-1	Bo Bichette	Toronto Blue Jays
U-22	Cody Stashak	Minnesota Twins
U-31	Curt Casali	Cincinnati Reds
U-36	Robinson Cano	New York Yankees
U-52	Kyle Higashioka	New York Yankees
U-62	David Ortiz	Boston Red Sox
U-64	Alex Bregman	Houston Astros
U-69	Derek Holland	Pittsburgh Pirates
U-71	Jesus Aguilar	Miami Marlins
U-76	Edwin Encarnacion	Chicago White Sox

jeffblankenburg

[Card Number] [Player Name] [Player Team] [Quantity]

1	Lorenzo Cain	Milwaukee Brewers	2
4	Luis Severino	New York Yankees	2
7	Brandon Crawford	San Francisco Giants	2
9	Blake Snell	Tampa Bay Rays	2
15	D.J. LeMahieu	New York Yankees	2
16	Jorge Alfaro	Miami Marlins	1
20	Javier Baez	Chicago Cubs	2
22	Trey Mancini	Baltimore Orioles	2

jeffblankenburg

[Card Number] [Player Name] [Player Team] [Quantity]

4	Larry Doby	Cleveland Indians	4
7	Tim Lincecum	San Francisco Giants	2
9	Rhys Hoskins	Philadelphia Phillies	3
13	Aaron Judge	New York Yankees	5
15	Kris Bryant	Chicago Cubs	3
16	Bryce Harper	Washington Nationals	2
17	Ken Griffey Jr.	Seattle Mariners	2
22	Eddie Mathews	Milwaukee Braves	2

jeffblankenburg

1	Tom Glavine	Atlanta Braves
2	Randy Johnson	Arizona Diamondbacks
8	Jeff Bagwell	Houston Astros
10	Rod Carew	California Angels
12	George Springer	Houston Astros
18	George Brett	Kansas City Royals
25	Carl Yastrzemski	Boston Red Sox
28	Juan Soto	Washington Nationals
29	Willie Mays	San Francisco Giants
35	Rickey Henderson	Oakland Athletics

jeffblankenburg

11	Tim Lincecum	San Francisco Giants
12	Eric Hosmer	San Diego Padres
19	Kyle Freeland	Colorado Rockies
26	Michael Kopech	Chicago White Sox
27	Clayton Kershaw	Los Angeles Dodgers
32	Carlos Correa	Houston Astros
33	Aaron Judge	New York Yankees
34	Trevor Story	Colorado Rockies
38	Gerrit Cole	New York Yankees
43	Matt Kemp	Miami Marlins