Glenn Justo Galvizo created ASTERIXDB-3062:
----------------------------------------------
Summary: Parameter / External Variables in the UI
Key: ASTERIXDB-3062
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3062
Project: Apache AsterixDB
Issue Type: New Feature
Components: UI - Web Interface
Reporter: Glenn Justo Galvizo
It would be nice to have a way specify a query with an external variable /
parameterized variable *without* having to change the query itself in the UI.
Currently, we can only execute such queries through the API. For example,
suppose I wanted to execute the following:
{code:java}
FROM Users U
WHERE U.user_id = $1
SELECT U;{code}
The UI would return the following:
ERROR: Code: 1 "ASX1086: No value for parameter: $1"
It would be nice to specify a value for $1 here either through the query itself
or through the web interface. Neo4J currently supports this in their UI by
allowing users to specify a ":param " option prior to their query. Here's an
example of such an option adapted to the query above:
{code:java}
:param $1 'ASB3D'
FROM Users U
WHERE U.user_id = $1
SELECT U;{code}
Another option would be to allow users to specify parameters and their values
through some sort of menu item (I think a few SQL browsers offer this).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
