dp2 | Integrated Library System / Library Integrated System | Game Engine library

I'm unsure what I'm missing here, but I cannot connect from Logic App to Azure SQL. Any help is appreciated.

Steps performed:

1. Enabled System Assigned Managed Identity (SAMI) for the Logic App

2. Added the SAMI in a Contributor role for the SQL Server (its in another resource group)

3. Verified the SAMI role by clicking the Azure role assignments button

4. Added the SAMI in both the db_datareader and db_datawriter roles within the SQL Server itself using:

I am attempting to alter values in multiple columns based on corresponding values in other columns. I have been able to do this by hard coding, but I would appreciate any help in automating the following code so it can be replicated for any number of samples. Below, I share a minimal example input, ideal output and the working code. Note - I am still a bit green in python so comments go a long way.

Input-

I created my first database (let's call it MyDB) on Azure and created a user that I want to use to query the DB from my applications. I only wanted to give that user db_datawriter and db_datareader because I think that is all this user needs to do from the application.

When I run this on MyDB:

I want to connect two shiny pages coded in separate R6 classes. I am really stuck on how to go about this. Below is a simple working example. When private$..counter == 4 in Page1, I want to hide all contents in Page1 and activate Page2. I know a simple showModal, modal dialog could say "Thanks". I just used a simple example. In reality, this new page would also show more complex content like Page1. Is there any way to achieve what I want using shinyjs? Or other means?

Page 1

I have a v-data-table in vueJS that contains some numeric columns and some string columns. In each column, some of the values are null. I am trying to create a custom sorting function that will place null values last. This is what I tried so far:

I have an R6 class that I am using to organize my shiny application. Essentially, I want to connect different R6 classes for an experimental interface I am creating and want to reuse my code. As a simplified working example, see the code below.

In my application I am using variables with names like dp1,dp2,....dp13 in order to use them in loops and I want to call thame in a for loop. I want to use it something like given below.

I'm using SQL Server and trying to retrieve the minimum of multi averages of salaries in or group by their departments.

I can retrieve the salary's averages of all departments by (group by) by using this query:

I have an ObservableCollection of DataPoint objects. That class has a Data property. I have a DataGrid. I have a custom UserControl called NumberBox, which is a wrapper for a TextBox but for numbers, with a Value property that is bind-able (or at least is intended to be).

I want the DataGrid to display my Data in a column NumberBox, so the value can be displayed and changed. I've used a DataGridTemplateColumn, bound the Value property to Data, set the ItemsSource to my ObservableCollection.

When the underlying Data is added or modified, the NumberBox updates just fine. However, when I input a value in the box, the Data doesn't update.

I've found answers suggesting to implement INotifyPropertyChanged. Firstly, not sure on what I should implement it. Secondly, I tried to implement it thusly on both my DataPoint and my NumberBox. I've found answers suggesting to add Mode=TwoWay, UpdateSourceTrigger=PropertyChange to my Value binding. I've tried both of these, separately, and together. Obviously, the problem remains.

Below is the bare minimum project I'm currently using to try to make this thing work. What am I missing?

MainWindow.xaml