Question & Answer > View Question

configure jdbc binder- how to create multiple query in "SQL SELECT Query"

Confluence User - 03 Dec, 2020

Good day to all master, i want to ask about creating multiple query in SQL SELECT Query.

now i just using this script SELECT COUNT(*) AS id_totalsubmitted FROM app_fd_task_submission WHERE c_field01_approval_radio ='Submitted'; to show out the total, please refer the picture.

this script only working for one field (Train Inspection Submitted).

I want to use SELECT COUNT(*) AS id_totalapproved FROM app_fd_task_submission WHERE c_field01_approval_radio ='Approved'; to show the data in field (Train Inspection Approved).

How to separate this two query? using semi colon ; is not working.

TQ so much to all expert...

database;forms;query;multiplequery

2

Confluence User •

03 Dec, 2020 •

confluenceUser •

•

confluenceUser •

Hi,

I would suggest you use the section load/store binder instead of the form. As for the query, it looks like it's getting from the same table and you could retrieve all the values in a single query.

After some googling, I was able to find the following for your reference:

mysql - Grouping based on the status, then count its product and the total based on its category ID - Database Administrators Stack Exchange

sql - Count all rows by status - Stack Overflow

Confluence User •

04 Dec, 2020 •

confluenceUser •

•

confluenceUser •

Hi sir,

Thanks for your idea.

1

CSV | Excel | XML | PDF

Your answer

Print

configure jdbc binder- how to create multiple query in "SQL SELECT Query"

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-00927d07-36a9-44ee-9013-3ca598d33ab1{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-b5bf223e-6685-4813-a76e-e319f9f04075{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer