In this article we cover the steps for using the use the Join() aggregate function to concatenate all values based on a specific condition. The function will concatenate values into a single string separated by the specified separator (if you do not specify a separator, the function defaults to a comma). The Join() function uses the following syntax: [Collection][Condition].Join(Expression) [Collection][Condition].Join(Expression, Separator) The following expression conca

Welcome to our blog post on optimizing your VDM / Scheduler experience by clearing Historical Data in the settings! In this guide, we will walk you through the step-by-step process of running VDM as an admin, accessing the Settings menu, adjusting the Historical Data setting, and effectively managing database bloat caused by logging. By following these instructions, you can streamline your Scheduler database and ensure smooth operation of your Scheduler jobs. Let's dive in an

In this post I want to share how to leverage a new feature inside VDM. This feature gives users the ability to paste in a list of values for IN type parameters. First begin by running your view to get to the parameter prompts. Once you get to the IN type parameter, click in the manual entry box of the parameter. From this point, paste in your list of values, then click the + icon to the right of the box. The values you pasted into the parameter should then be selected as the

In this post I am going to discuss filters that are applied in the Visualize Designer ONLY. What this means is that these filters are applied to the data at the designer level not the viewer level for the end user. There are two key levels / areas that the filter can be applied. First is at the data source level which will filter all other elements inside your Visualize. The second option allows you to apply filters on the data on the individual element / widget. Below we wi

In this post I want to talk about valid and invalid ways of sending API calls with the parameter values for In / In No Paren types. If you are sending parameter values for the IN / IN NO PARENTHESIS parameter type, you will need to use pipes ( | ) to escape out each value if any of your data has a comma in it. Example Data WITHOUT comma: "ABC, DEF, BridgeWorks VDM" Example Data WITH comma: "ABC, DEF, BridgeWorks, VDM" Example Regular API: https://webreports.bridgeworksllc.com