PS Query & SQL

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.

Good Morning Mital - There are several differences in Connected Query and Composite query, but the primary idea behind the two is the same. Both tools allow users to combine (in various ways) the results of multiple queries.  Both tools can be scheduled, with output going to a mounted drive, to an email address or to Report Manager. 

But, these tools differ in several important ways.  First, the UI is more user friendly in Composite Query.  It is easier and more intuitive, and once you become accustomed to how it works, it feels quite similar to Query Manager.  Second, Composite Query can create aggregate functions, expressions, and drilling queries  URLs.  This means you have the choice of creating some expressions in the initial queries, or in Composite Query as well as access to other functionalities.  Also, Composite Query can write to HTML, XML or Excel format, like Query Manager.  Finally, Connected Query produces XML output, and is used with BI Publisher. 

The Use Cases follow from these capabilities. 

• Connected Query is needed if you are creating a BI Publisher report. Or, it is often called upon if you need to create an XML file for an integration of some sort.  
• Composite Query is useful if you are creating a specific report and you need the results written into a spreadsheet format.  It is also easier to tweek and update, if you know a report will need to be changed over time. 

Take Care, and I am sure Dan will have other uses. 

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.

Original Message:
Sent: 3/3/2025 6:25:00 AM
From: Tom Johnson
Subject: RE: Composite Query Field Reordering

Good Morning Mital - There are several differences in Connected Query and Composite query, but the primary idea behind the two is the same. Both tools allow users to combine (in various ways) the results of multiple queries.  Both tools can be scheduled, with output going to a mounted drive, to an email address or to Report Manager. 

But, these tools differ in several important ways.  First, the UI is more user friendly in Composite Query.  It is easier and more intuitive, and once you become accustomed to how it works, it feels quite similar to Query Manager.  Second, Composite Query can create aggregate functions, expressions, and drilling queries  URLs.  This means you have the choice of creating some expressions in the initial queries, or in Composite Query as well as access to other functionalities.  Also, Composite Query can write to HTML, XML or Excel format, like Query Manager.  Finally, Connected Query produces XML output, and is used with BI Publisher. 

The Use Cases follow from these capabilities. 

• Connected Query is needed if you are creating a BI Publisher report. Or, it is often called upon if you need to create an XML file for an integration of some sort.  
• Composite Query is useful if you are creating a specific report and you need the results written into a spreadsheet format.  It is also easier to tweek and update, if you know a report will need to be changed over time. 

Take Care, and I am sure Dan will have other uses. 

------------------------------
Tom Johnson
Sr Business Systems Analyst
Duke University
tom.johnson@duke.edu
"None of us is as smart as all of us"

Original Message:
Sent: 03-02-2025 11:46 AM
From: Mital Naik
Subject: Composite Query Field Reordering

Original Message:
Sent: 2/28/2025 4:29:00 PM
From: Daniel Labrecque
Subject: Composite Query Field Reordering

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.

------------------------------
Daniel Labrecque
Senior 2 Business Systems Analyst/Functional Architect
University of Nevada, Las Vegas
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Good Morning Mital - There are several differences in Connected Query and Composite query, but the primary idea behind the two is the same. Both tools allow users to combine (in various ways) the results of multiple queries.  Both tools can be scheduled, with output going to a mounted drive, to an email address or to Report Manager. 

But, these tools differ in several important ways.  First, the UI is more user friendly in Composite Query.  It is easier and more intuitive, and once you become accustomed to how it works, it feels quite similar to Query Manager.  Second, Composite Query can create aggregate functions, expressions, and drilling queries  URLs.  This means you have the choice of creating some expressions in the initial queries, or in Composite Query as well as access to other functionalities.  Also, Composite Query can write to HTML, XML or Excel format, like Query Manager.  Finally, Connected Query produces XML output, and is used with BI Publisher. 

The Use Cases follow from these capabilities. 

• Connected Query is needed if you are creating a BI Publisher report. Or, it is often called upon if you need to create an XML file for an integration of some sort.  
• Composite Query is useful if you are creating a specific report and you need the results written into a spreadsheet format.  It is also easier to tweek and update, if you know a report will need to be changed over time. 

Take Care, and I am sure Dan will have other uses. 

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.

Hello all,

I just added an Idea Lab: Field Reordering Improvement for Composite Query.   Here is what I am asking:

Please provide a way to reorder the fields for Composite Query rather than using the Action icon and moving the field up or down one step at a time for each click. This can take an inordinate amount if you have many fields that will be used in the output.

For instance, if I have 80 fields and add a new field, it will be added at position 81. Say I want to move that field to position 40, then I have to click the Action icon > Move Up for every single step.

Is there a way to create a drag and drop utility or even having the option to reorder fields as already exists in Query Manager.

Please vote. Currently, having to use that Action icon to move the fields is less than ideal.