nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to display the results based on selected values from select box?

Sudarshan K R

Hi,

can any one answer my question with example?

I would like to display the result on change of select box value and even in the select options will also come from database.

1. how to display the mysql records in select box?

2. how do I display the mysql results onchange of select box options?

ex: I have 3 different countries in select box like(India, Dubai & London)

when I select India it should retrieve all major city names from India,

when I select Dubai it should retrieve all major city names from Dubai,

when I select London it should retrieve all major city names from London,

can this be done using RUN and Scaffolding plugin, I'm not sure as I'm beginner.

If you provide any example will be great help.

Regards

Sudhu

Accepted answers

All comments

Nic Brough -Adaptavist-

Jira doesn't have a scaffolding plugin. That's for Confluence.

We can't really give you a decent answer to this until we know whether it's Jira or Confluence and if you really mean scaffolding or something else.

Alexej Geldt

question is tagged for confluence.

Nic Brough -Adaptavist-

Ta. It wasn't when it was first published.

Sudarshan K R

I had changed it to confluence

Bob Swift

You use the Run macro to allow the user to make the selection and then SQL-query Macro to run the query against the database based on the user selected values. Start with that before doing anything with dynamically generating the choice values. Look at the Documentation and various How to's for the run macro and similarly the Documentation and How to's for the sql macro.

Sudarshan K R

can you tell me, what am I doing wrong here?

{run:autorun=false|heading=Heading text|prompt=Prompt text|titleRun=Submit|help=help page|

replace=

s1:choice value 1:?Select:select::choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text

}

Regards

Sudhu

Bob Swift

This works for me:

{run:autorun=false|heading=Heading text|prompt=Prompt text|titleRun=Submit|help=help page|
replace=
s1:choice value 1:?Select:select::choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text}
$s1
{run}

Sudarshan K R

Thanks Bob, however I have one more doubt regarding sql parameters.

Please find below attached image and also how do I pass region name dynamically through variable in sql query?

Sudarshan K R

I found the answer

here is the documentation

· Go to the page where you want to add drop box

· Click on edit page

· Click on Insert

· Select "Other Macros"

· Choose "Run with user form and parameters"

· On the right side of the popup window enter necessary fields.

· Eg :

· Unique id for this run macro instance = name of the macros

· Replace parameter list = " {run:autorun=true|heading=Heading text|prompt=Prompt text|titleRun=Submit|help=help page| replace=g2::hidden value:Hidden description:hidden,s1::?Location:select::India::Dubai::England"

Text which is highlighted in blue are optional parameters.

Text which is highlighted in green replace - parameters, this parameter will act like dummy parameters and some times it must be declared with any value(but hidden field will be preferred) and some times it is not required.

Text which is highlighted in red is actually the parameters for the select box, which can only be static values and it should correspond to the values in the database and is not case sensitive.

{run:autorun=true|heading=Heading text|prompt=Prompt text|titleRun=Submit|help=help page| replace=g2::hidden value:Hidden description:hidden, s1::?Location:select::India::Dubai::England

{run:autorun=true|heading=Heading text|prompt=Prompt text|titleRun=Submit|help=help page| replace= g2::hidden value:Hidden description:hidden, s1::?Location:select::india:India:dubai:Dubai:England:London

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

atlassian-marketplace

jira

scaffolding

run