## the sharepoint flow condition runs with False always

To solve this problem, create variables and write the values ​​of the type of abort and expression that you use to establish "more than 10 days" in these variables. Do this BEFORE the action condition.

Run the workflow and check the contents of the variables.

You can now see what is the entry of the condition and take the appropriate steps to correct the errors.

## Google Xlookup sheets do not work but require results in the table showing the maximum date according to the condition of the user list.

Problem 1:

`Page-2-Seznam članov > Coloumn C` : It must be the maximum dates.
The function must search the list for the name of `Page-2-Seznam članov > Coloumn B` and in the area `Page-3-Podaljsave` to give the same person the exact maximum output of `Page-3-Podaljsave > Coloumn E`

In `Page 2 > column C > cell C3` you can use `vlookup`.

``````=VLOOKUP(B3,'Page-3-Podaljsave'!\$B:\$E,4,false)
``````

A `=sort` function to guarantee that the output will be the max Availability date.

``````=VLOOKUP(B3,sort('Page-3-Podaljsave'!\$B:\$E,4,false),4,false)
``````

Then use a `arrayformula` to cover the range.

``````=arrayformula(VLOOKUP(B:B10,sort('Page-3-Podaljsave'!\$B:\$E,4,false),4,false))
``````

Be careful, the larger the range in this search, the slower the sheet will be to open / process new data.

Problem 2:

`Page-2-Seznam članov > Coloumn D` : It must be the maximum dates.
The function must search the list for the name of `Page-2-Seznam članov > Coloumn B` and in the area `Page-3-Podaljsave` to give the result of the same person the exact max date of `Page-3-Podaljsave > Column F`

Same idea:

``````=arrayformula(VLOOKUP(B3:B10,sort('Page-3-Podaljsave'!\$B:\$F,5,false),5,false))
``````

You can combine the two formulas in one table with that in `C3` :

``````={arrayformula(iferror(VLOOKUP(B3:B10,sort('Page-3-Podaljsave'!\$B:\$E,4,false),4,false))),arrayformula(iferror(VLOOKUP(B3:B10,sort('Page-3-Podaljsave'!\$B:\$F,5,false),5,false)))}
``````

Bonus: you can reduce `'Page-3-Podaljsave'!\$B:\$E` to a table with only two columns: `{'Page-3-Podaljsave'!\$B:\$B,'Page-3-Podaljsave'!\$E:\$E}` then use it in the function like this:

``````={
arrayformula(iferror(
VLOOKUP(B3:B10,
sort({'Page-3-Podaljsave'!\$B:\$B,'Page-3-Podaljsave'!\$E:\$E},2,false),
2,false))),
arrayformula(iferror(
VLOOKUP(B3:B10,
sort({'Page-3-Podaljsave'!\$B:\$B,'Page-3-Podaljsave'!\$E:\$E},2,false),
2,false)))
}
``````

## php – How to make the IF condition recognize values ​​greater than 100 and / or how to browse a table obtained from a csv file and get the desired value?

Good night!

Gentlemen, I'm new to PHP and have the following problem.
I have two options below to solve my problems. However, I can not make them work completely.

FIRST OPTION:

This condition of the IF mine does not calculate the freight value if the distance exceeds 1000 km.

The distance is calculated correctly using the Google Distance Matrix API.

Follows the SI section:

``````if (\$distance > 0 && \$distance <= 100)
{
\$frete = (100 * 2.19);
}elseif (\$distance > 100 && \$distance <= 200)
{
\$frete = (100 * 1.35);
}elseif (\$distance > 200 && \$distance <= 300)
{
\$frete = (100 * 1.18);
}elseif (\$distance > 300 && \$distance <= 400)
{
\$frete = (100 * 1.11);
}elseif (\$distance > 400 && \$distance <= 500)
{
\$frete = (100 * 1.07);
}elseif (\$distance > 500 && \$distance <= 600)
{
\$frete = (100 * 1.04);
}elseif (\$distance > 600 && \$distance <= 700)
{
\$frete = (100 * 1.02);
}elseif (\$distance > 700 && \$distance <= 800)
{
\$frete = (100 * 1.01);
}elseif (\$distance > 800 && \$distance <= 900)
{
\$frete = (100 * 1.00);
}elseif (\$distance > 900 && \$distance <= 1000)
{
\$frete = (100 * 0.99);
}elseif (\$distance > 1000 && \$distance <= 1100)
{
\$frete = (100 * 0.99);
}elseif (\$distance > 1100 && \$distance <= 1200)
{
\$frete = (100 * 0.98);
}
elseif (\$distance > 1200 && \$distance <= 1300)
{
\$frete = (100 * 0.98);
}elseif (\$distance > 1300 && \$distance <= 1400)
{
\$frete = (100 * 0.97);
}elseif (\$distance > 1400 && \$distance <= 1500)
{
\$frete = (100 * 0.97);
}elseif (\$distance > 1500 && \$distance <= 1600)
{
\$frete = (100 * 0.97);
}
elseif (\$distance > 1600 && \$distance <= 1700)
{
\$frete = (100 * 0.97);
}elseif (\$distance > 1700 && \$distance <= 1800)
{
\$frete = (100 * 0.97);
}elseif (\$distance > 1800 && \$distance <= 1900)
{
\$frete = (100 * 0.97);
}elseif (\$distance > 1900 && \$distance <= 2000)
{
\$frete = (100 * 0.97);
}
elseif (\$distance > 3000){
\$distance = 3000;
\$frete = (100 * 0.64);
}

echo \$distance;
echo "";
echo \$frete;
``````

Can someone help me with what I am going wrong?

SECOND OPTION:

I've tried doing this via an external CSV file. However, I can not scan this file to see if this distance is in an array.

Here is the code below my first try. I would even prefer this option to have a cleaner code and easier maintenance when prices change.

`````` foreach( \$csv->ler() as \$linha ) //AQUI TRAGO AS INFORMAÇÕES DO ARQUIVO CSV.{
if (\$distance >= \$linha(0) && \$distance <= \$linha(1)){
for (\$i = 0; \$i < count(\$linha); \$i++){
if (\$distance != \$linha(\$i)(0) && \$distance != \$linha(\$i)(1)) {
echo floatval(\$distance);
echo \$linha;
}
}
}
var_dump( \$linha );//TRÁS TODOS OS DADOS ARRAYS CORRETAMENTE.
}
``````

Example VARDUMP:

``````array (size=3)
0 => string '1' (length=1)
1 => string '100' (length=3)
2 => string '2.19' (length=4)
``````

If anyone can help me with one or the other option, I will be very grateful to you.

## SQL Server – The filtered index is not used when the variable is in the WHERE condition

Why does MS SQL Server refuse to use a filtered index supported in this scenario?

``````-- demo data
CREATE TABLE #Test (
ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Test_ID PRIMARY KEY
,Col1 NVARCHAR(36) NOT NULL DEFAULT NEWID()
,Col2 NVARCHAR(20) NOT NULL DEFAULT N''  -- !!
);

WITH
L0   AS(SELECT 1 AS C UNION ALL SELECT 1 AS O), -- 2 rows
L1   AS(SELECT 1 AS C FROM L0 AS A CROSS JOIN L0 AS B), -- 4 rows
L2   AS(SELECT 1 AS C FROM L1 AS A CROSS JOIN L1 AS B), -- 16 rows
L3   AS(SELECT 1 AS C FROM L2 AS A CROSS JOIN L2 AS B), -- 256 rows
L4   AS(SELECT 1 AS C FROM L3 AS A CROSS JOIN L3 AS B), -- 65,536 rows
L5   AS(SELECT 1 AS C FROM L4 AS A CROSS JOIN L4 AS B), -- 4,294,967,296 rows
Nums AS(SELECT ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS N FROM L5)
INSERT INTO #Test(Col2)
SELECT TOP 100000 N''
FROM Nums;

INSERT INTO #Test(Col2)
VALUES(N'ABC');

-- FILTERED index to support filter predicate of a query
CREATE NONCLUSTERED INDEX IX_Test_Col2_filtered ON #Test (Col2 ASC) WHERE Col2 <> N'';

-- just checking statistics
DBCC SHOW_STATISTICS('#Test', 'IX_Test_Col2_filtered')

-- condition on variable = index scan :-(
DECLARE @Filter NVARCHAR(20) = N'ABC'

SELECT Col1
FROM #Test
WHERE Col2 = @Filter
AND Col2 <> N'';
``````

Everything goes as expected when you use literals.

``````-- condition on literal value - index seek + key lookup :-)
SELECT Col1
FROM #Test
WHERE Col2 = N'ABC';
``````

## Search Results – Refiner OOTB with And Condition

Is it possible to configure a refiner to refine according to a value in a column and a content type.

Our search results page has several types of content.

All content types have column A, for example.

We want a refiner to display all the values ​​of a content type and where col value A = x

## Condition that the linear map applied to the basic vectors always gives a base?

Let $$T in mathcal {L} (V, W)$$ or $$dim V = dim W = n$$. If the list of vectors $$v_1, dots, v_n$$ forms a basis for $$V$$. What is the condition that must be satisfied so that the list $$Tv_1, dots, Tv_n$$ forms a basis for $$W$$?

I remember that there is a vulnerability related to TOCTOU, in which it is recommended to never set a user's default access to true and set it to false in case of a problem, but set it to false and set it to true only if everything goes well. However, I do not remember the precise vulnerability or the name of the anti-pattern. If help could be provided to provide these details, I would be very grateful.

Background: I'm part of a team trying to justify why we need to set the default validation functions to false rather than true (although it may sound obvious, I want to give a solid justification).

## unit – Make the timer a condition

I realize an interactive game that uses a sensor as input to the game. As part of my initial prototype, I used the sensor's analog values ​​as a condition in an if statement. But now, I want to use as a condition the time during which the sensor is pressed. However, I do not know how to do that. Below, I have attached the two scripts.

This is the timer script:

``````using UnityEngine;
using System.Collections;
using UnityEngine.UI;
using UnityEngine.SceneManagement;

public class Timer : MonoBehaviour
{
public int timeLeft = 5;
public Text countdownText;

// Use this for initialization
void Start()
{
StartCoroutine("LoseTime");
}

// Update is called once per frame
void Update()
{
countdownText.text = ("Time Left = " + timeLeft);

if (timeLeft <= 0)
{
StopCoroutine("LoseTime");
countdownText.text = "Times Up!";
Invoke("ChangeLevel", 0.1f);
}

}

IEnumerator LoseTime()
{
while (true)
{
yield return new WaitForSeconds(1);
timeLeft--;
}

}
void ChangeLevel()
{

}
}
``````

and this is the sensor code:

``````using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System.IO.Ports;
public class Arduino3 : MonoBehaviour
{

SerialPort sp = new SerialPort("\\.\COM7", 9600);// Com port and the baud rate of the arduino
Material m_Material;
GameObject Sphere;

void Awake()
{
Sphere = GameObject.FindWithTag("Player");
m_Material = GameObject.FindWithTag("Player").GetComponent().material;
}
void Start()
{
if (!sp.IsOpen)
{ // If the erial port is not open
sp.Open(); // Open
}
}

// Update is called once per frame
void Update()
{
if (sp.IsOpen)
{ // Check to see if the serial port is open
try
{

//string portreading = sp.ReadLine(); // get the string output of the serial port
float amount = float.Parse(value);

if ((amount > 25f))
{
m_Material.color = Color.yellow;
Renderer _rend = Sphere.GetComponent();
Sphere.GetComponent().material = _rend.material;
Sphere.transform.localScale = new Vector3(2f, 1f * amount, 2f);
}
else
{
m_Material.color = Color.white;
Sphere.transform.localScale = new Vector3(2f, 10f, 8f);
}

}
catch (System.Exception)
{

}

}

}
void ApplicationQuit()
{
if (sp != null)
{

{
sp.Close();
}
}
}
}
``````

any help will be most appreciated

## 5th dnd – If an Eidolon uses Divine Dread then enters his sacred statue, is the frightened condition transferred?

We feel really ambiguous, but the wording makes it a little clearer.

Each creature within 60 feet of the eidolon who can see her must succeed in her DC 15 wisdom save throw or be afraid for a minute …

From the sacred animation

When the eidolon moves in a space occupied by a sacred statue, he can vanish

In addition, Sacred Animation also indicates

The eidolon uses the statistics of the sacred statue in its place.

The statue block of the sacred statue has:

False Appearance Although the statue remains motionless, it is impossible to distinguish it from a normal statue.

So, if Eidolon disappears, it is reasonable to say that the targets of Divine Dread can not see it, because it looks like the sacred statue, which looks like a normal statue (if it stays still).

## If the statue looks like Eidolon.

At this point, I'm not sure. I think there are arguments for and against that. The discretion of the SM is probably appropriate.

## If an Eidolon throws Divine Dread into his sacred statue, is the frightened condition transferred?

Or would a PC be only scared by eidolon? And if the sacred statue looks exactly like the eidolon?

RAW, I can not find any proof, but I always ask the question.