×

Archives

  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • September 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • August 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • January 2013
  • December 2012
  • October 2012

Categories

  • Bots & AI
  • Business Applications
  • Industry Solutions
  • InfoPath Replacement
  • Microsoft Teams Integration
  • News & Press Releases
  • NITRO Studio
  • Remote Workforce
  • Security Management
  • Uncategorized

HOW TO SHOP

1 Login or create new account.
2 Review your order.
3 Payment & FREE shipment

If you still have problems, please let us know, by sending an email to support@website.com . Thank you!

SHOWROOM HOURS

Mon-Fri 9:00AM - 6:00AM
Sat - 9:00AM-5:00PM
Sundays by appointment only!
Questions? Email us at sales@crowcanyon.com
  • +1 (925) 478-3110

Crow Canyon SoftwareCrow Canyon Software

Crow Canyon Software

No-Code Business Process Automation for Microsoft 365, Teams, & SharePoint!

Call: +1 (925) 478-3110
Email: sales@crowcanyon.com

Crow Canyon Software
Offices in Benicia, CA & Wakefield, RI

  • HOME
    • ARIES HOMEPAGE
    • HOMEPAGE 4
    • ATHOS ONE-PAGENEW
  • Portfolio
  • HERO
  • FEATURES
    • BLOG
    • BLOG STYLE #2
    • s
    • s
    • CUSTOM SUBHEADERS
      • Sep
  • PAGES
    • THE COMPANY
      • ABOUT US
    • WORK & STORIES
    • DYNAMICS
      • F.A.Q.
    • SYSTEM
      • 404 PAGE
Free Demo
  • Home
  • Blog
  • NITRO Studio
  • Query List Action Provides Powerful Workflow Capabilities to NITRO Studio

Query List Action Provides Powerful Workflow Capabilities to NITRO Studio

by crowcanyon / Tuesday, September 03, 2019 / Published in NITRO Studio
Query Blog Preview

The “Query List” action in Crow Canyon’s NITRO Studio is one of those seemingly obscure functions that actually provides tremendous value. Many business processes require multiple steps involving related sources of data. Query List can tie these data sources together and allow complex workflows to be automated.

Query List comes with NITRO Studio, Crow Canyon’s workplace automation tool for SharePoint and Office 365. It is one of the many tools in NITRO Studio that provide the power and flexibility to meet an organization’s workflow needs, whether those are simple or complex.

The “Query List” Action in NITRO Studio Has Many Uses
Let’s take the case of ordering new computer equipment. The Purchase Order issued for the new supplies may have multiple items listed. When the shipment arrives, a NITRO Workflow using Query List can run a process on the Purchase Order. For each line item, the workflow can add the item, with all its details, to an Asset Management database and also create a deployment task for it while sending out notifications that equipment has arrived. This accelerates workplace efficiency by automatically taking the next steps in order fulfillment.

Another use is in a Ticketing system where a support ticket or change request has sub-tasks. When the ticket reaches a certain status, actions can be run on one or more of the sub-tasks. This could be as simple as closing the sub-tasks when the ticket is closed, or more complex, such as tracking time with sub-tasks and generating an Invoice based on the details of each sub-task.

Query List can also be used when tracking parts used in a Work Order system. The Work Order can list the parts used, and a workflow can be setup to issue orders to re-stock inventory for each part when the quantity of that part falls below a certain threshold.

These are just some of the many examples of how Query List can be used to manage multiple interacting and cascading processes. This is just one of the many great features of NITRO Studio that help drive workplace automation and business process efficiency.

How Query List Works

Query List is used in NITRO Custom Actions and NITRO Workflows. Both of these tools can have a series of actions that are run in sequence.

To use Query List, first a “Query List Action” is set up, then a subsequent action (or actions) can use the Query List results.
How Query Lists Work

In the Workflow in the above image, the actions run on a Work Order This Work Order has a list of parts on it because the technician, while fulfilling the Work Order, chose the parts used from a Parts list and added the quantity consumed and other details. The result is that the Work Order has a list of the parts used to complete the order.

The Workflow is setup to run when the Work Order is marked “Completed”. The first action in this workflow is the “Query Parts List”, which returns all parts used for that particular Work Order. It could also run a more sophisticated Query where it will only return those Parts used where the “Quantity Used” exceeds a certain pre-set “Threshold.”

The next action, “Create New Order”, uses the list of Parts returned in the Query. It can create an Order item in an “Orders” list and assign it to a person or group. Fields from the Part list can be mapped to the new Order so that it is clear what needs to be ordered and how many.

Alternatively, an email can be sent to the purchasing agents to inform them to order the parts.

In a more sophisticated and integrated scenario, the Workflow can run an action that uses a script or web service to write directly to a financial system.

In the below image, any, or all, of these Actions can be run, based on the results of the Query List.

Even in this one example, it is clear that Query List can add much value to workflow automation. The possible uses of Query List, along with NITRO Custom Actions and Workflows, cover a wide-range of important business processes. This kind of workflow automation drives productivity and lowers overall expenses while increasing profits. It is time to put NITRO Studio, with its Query List Action, to use!

This KB article goes into detail about using Query List: https://www.crowcanyon.help/article/470/. And we are always here to assist and provide guidance to help you achieve your workplace automation goals.

  • Tweet

What you can read next

Working from Home
Crow Canyon Software Reacts to Capital’s Major Investment in Nintex
Omnichannel Support: NITRO Studio Gives Users the Communication Options They Need
NITRO Managed Columns

Categories

  • Bots & AI
  • Business Applications
  • Industry Solutions
  • InfoPath Replacement
  • Microsoft Teams Integration
  • News & Press Releases
  • NITRO Studio
  • Remote Workforce
  • Security Management
  • Uncategorized

Recent Posts

  • PR: NITRO Studio Brings Business Process Automation to Microsoft 365 GCC High Users

  • Working from Home

    Crow Canyon Software Reacts to Capital’s Major Investment in Nintex

  • PR: Crow Canyon Software Awarded GSA Schedule 70 MAS Contract

  • Crow Canyon Software reacts to TPG Capital’s Major Investment in Nintex

  • Approvals: Critical Component of Many Business Process Workflows

Crow Canyon Software Logo

Crow Canyon builds upon your existing collaboration platforms in Office 365 and SharePoint to give your staff the tools they need to drive business process automation. Pick and choose the best solution for your organization.

  • Business Applications
  • Company Overview
  • NITRO Studio
  • Partners & Resellers
  • Solutions
  • Newsroom
  • Services
  • Purchase
  • Resources
  • Careers
  • Support
  • Request a Demo

Questions? Contact Us!

+1 (925) 478-3110
Email: sales@crowcanyon.com

Crow Canyon Systems, Inc.
Offices in Benecia, CA & Wakefield, RI

  • GET SOCIAL

© 2021 Crow Canyon Systems, Inc. All rights reserved. Privacy Policy | Disclosure Agreement | Cookie Policy

TOP