sharepoint online – Can we create a lookup relation between 2 lists even if the 2 lists exceeds the threshold limitation

We have 3 sharePoint online lists A,B & C .. where lists B & C has a lookup field to list A. now all of the 3 lists will contain around 1 million record.. so when we create or edit items from lists B & C will we be able to select the related list A item? or the lookup field inside lists B & C create/edit forms will not show the 1 million options? we will be using the modern ui.

Regards

sql server – Should I change parallelism (MaxDop and Threshold) on a single database or the whole instance?

Seems like I have problems with parallelism because largest wait types are CXCONSUMER and CXPACKET.

Server has 8 cores.
So I am planning to bump up
Cost Threshold to 50 and
MaxDop to 4

Currently I have default values, which is

5 - cost threshold for parallelism

0 - max degree of parallelism

enter image description here

Mostly, only a couple of databases are used intensively out of all databases we have on instance.

So do I need to change it on the whole instance or only on databases that are used the most?

Cumulative Sum until Threshold is Reached in R

I am trying to produce a code that sums the values in a column of a data frame. The sum cannot exceed 6 and should reset once the threshold is reached.However, there are some data where the value is greater than 6. Those values should be ignored since their max exceeds the threshold. Here is what I have now.


alpha = 2.0
beta = 0.5

list <-c()

#Simulation of years until failure
gamma<-data.frame(rgamma(1000,alpha,rate=beta))
names(gamma)(1) <- "Gamma"

gamma$replace <- cumsum(gamma$Gamma)

Gamma       Replace     
1.6035570   1.603557        
9.8213100   11.424867   
1.0840621   12.508929   
11.0941952  23.603124   
1.9282187   25.531343   
3.5725685   29.103911   
4.1402250   33.244137       
12.7360978  45.980234       
8.0572729   54.037507       
5.1241140   59.161621
```

sharepoint online – Recursive function to handle list view threshold not working

We have a list with 0.5 Million items.

The end goal is to get and handle threshold using recursive function. Followed the below article however didn’t work as per our requirement.
Rest to read more than 5000 items from document library

Code

function FilteredInvoiceNew(ColumnName,ColumnVal){
 
var dataset = ();
var FltrInv = ();
var response = response || ();
var ApprovalStatus = "";
var listName="Claimlist";
var myQuery= _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('ListName')/items?$select=ID,P_x0020_No,Inv_x0020_Date,Item_x0020_No,ProductCode,Qty,Prj_x0020_Name,
Distributor_x0020_No,Distributor_x0020_Name,Contractor_x0020_Name,Claim_x0020_Amount,YourReference,YourProductCode,YourPONumber,IsApproved,Comments";

if(ColumnName!=="" && ColumnVal!==""){
            
  myQuery+="&$filter=substringof('"+ColumnName+"',"+ColumnVal+")";      
}   

myQuery+="&$top=500";
myQuery+="&$orderby=ID desc";
 
 debugger;
 
        return $.ajax({
            url: myQuery,  
            method: "GET",  
            headers: {  
                "Accept": "application/json; odata=verbose"  
            },
            success: function(data){
                response = response.concat(data.d.results);
                if (data.d.__next) {
                    myQuery = data.d.__next;
                    FilteredInvoiceNew();
                }
              
                const lookup = response.reduce((a, e) => {
                a(e.YourReference) = ++a(e.YourReference) || 0;
                return a;
                }, {});

                FltrInv = response.filter(e => lookup(e.YourReference));
                console.log(FltrInv);
                
                $.each(FltrInv, function(index, row) {
                    
                    // SomeCode
                    
               });
   
 },
 
 error: function(error){
 
  console.log(error);
 }
 
  });// End of Ajax Call
 
}

Executing the function goes to the error section and throws the threshold error as shown below

enter image description here

Also tried nested function to include the below logic and it skips the nested function.

Would be extremely grateful if anyone could let us know if this is achievable.

Thanks in advance

SharePoint Modern List view threshold error for Some users

I have migrated the SharePoint list (Exceeds threshold limit) from MOSS 2007 to SP 2019 using ShareGate tool. When I open that list using User A (Same permission as User B) account the List was rendering without any issue but when I open that same list using User B, it show “Something went wrong. List exceeds threshold limit”

Check List

  1. Same List View.
  2. List Permission
  3. List View filters
  4. Indexed Columns (Same as source)
  5. Does not have any view filter like (Me)

Can anyone help to find out the issue

Sharepoint List Threshold Limit Causing the sharepoint designer workflow to Suspend

One of the task lists which was used in designer workflow reached the threshold limit and because of which the workflows are suspending with the below error.

RequestorId: f307e5c6-0c50-b022-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ApplicationException: HTTP 500 {“error”:{“code”:”-2147024860, Microsoft.SharePoint.SPQueryThrottledException”,”message”:{“lang”:”en-US”,”value”:”The attempted operation is prohibited because it exceeds the list view threshold.”}}}

There is a line in the workflow where it fetches the assignedTo field with taskname filter condition and the same exact line is throwing the above error.

Can someone please suggest to me how to overcome this error without increasing the threshold limit because the list can hold upto 30 million items as Microsoft document.

accessibility – Why do many prominent web apps use blue primary button with white text, when it fails the WCAG 2.1 contrast threshold

Accessibility modes are likely the reason. Twitter has a high-contrast mode for users who need it:

The accessibility setting of the web app now has a new “increase color
contrast” toggle button. The button once turned on, activates the high
contrast colors for UI elements. The high contrast mode makes it
easier for people with visual impairments to use the Twitter Web app.

Outlook’s desktop app adopts the operating system’s higher-contrast settings when activated.

Mac OS setting to increase contrast

Outlook – regular contrast mode

Outlook - regular contrast

Outlook – increase contrast mode

Outlook - high contrast mode

Unsure why Figma has a lower-contrast button – it doesn’t seem to be modal.

taproot – What is the point of miner signaling in a soft fork activation mechanism? What should the threshold be on miner signaling?

What is the point of miner signaling in a soft fork activation mechanism?

Miners are signaling readiness for a soft fork activation, they are not signaling to support (or vote for) a soft fork. It seems generally accepted at the time of writing (February 2021) that any opposition towards a soft fork should be raised and discussed before an activation mechanism is proposed. If arguments are raised that haven’t previously been considered or that opposition is material and sustained across the wider community, activation for that soft fork shouldn’t be considered.

Ideally you want as many miners enforcing the Taproot rules at the point it activates as possible. Otherwise an invalid Taproot spend could creep into a block and some miners wouldn’t reject it as they would be treating it as an anyone-can-spend. It would need a small, naturally occurring re-org to get that invalid Taproot spend out of the blockchain. This wouldn’t be a disaster but ideally you don’t want a greater frequency or greater magnitude of re-orgs than usually occur. Ideally you want all miners enforcing the Taproot rules from the point of activation.

As devrandom pointed out on IRC there is motivation for presumably unready miners who haven’t yet signaled to get ready urgently if the soft fork is activating soon. They don’t want to expend resources mining blocks (with an invalid Taproot spend in them) that will ultimately be rejected by a proportion of the network. But that doesn’t guarantee they will be ready and may lead to miners rushing to get ready for activation which again is not optimal.

There is also the consideration of miners deliberately or inadvertently producing blocks with invalid Taproot spends in them fooling SPV/non-upgraded clients that is discussed here.

What should the threshold be on miner signaling?

This is harder to answer as the threshold chosen appears to be a trade-off between ensuring as many miners are ready to activate the soft fork as possible and preventing a small minority of miners from unnecessarily delaying the soft fork for political or strategic reasons. With the SegWit soft fork in 2017, a BIP 148 user activated soft fork needed to be proposed because miners were assessed to be deliberately blocking activation to attempt to force through an additional block size increase.

In this developer survey conducted by AJ Towns the question “What do you consider a reasonable threshold for activation by hashpower supermajority?” it appears 90 percent or 95 percent would be the preferred threshold. The threshold for the SegWit activation was set initially at 95 percent.

c++ – Calling a function once a threshold is met

I’m currently writing an API for our codebase that allows us to use an Arduino Leonardo for our tests. This code is uploaded to the Arduino, and we read through the analog for work.

As stated in the docstring, this function calls a passed function once a threshold has been met. However, I need there to be a delay between function calls, as signals read from the analog can fluctuate and cause the callback function to be called more than expected. So, I devised a solution that requires the signals to depreciate 1/10 of the threshold value in order for callback to be executed again. The secondFactor is if the user wants to define their own limit of when they want the function to be called again. For example:

NeuroBoard board;
board.setTriggerOnEvenlope(700, Serial.println("Reached!");

This executes the statement once 700 is reached. Then once 630 is reached (700 - (700 x .10)), it set a boolean flag so that once 700 is reached again, it will be called. For another example:

NeuroBoard board;
board.setTriggerOnEnvelope(700, Serial.println("Reached!"), 500);

Same as above, however the boolean flag will only be set once the signals reach 500.

I hope I’ve explained everything so that it’s easily understandable. If anything is unclear, please leave a comment and I’ll address it! Below is the code:

NeuroBoard.hpp (code omitted for brevity)

class NeuroBoard {

    private:
        bool thresholdMet = false;

    public:
        /**
         * Calls the passed function when the envelope value is greater 
         * than the passed threshold.
         * 
         * @param threshold Threshold for envelope value.
         * @param callback Function to call when threshold is reached.
         * @param secondFactor Optional parameter for the second threshold the data must pass.
         * 
         * @return void.
        **/
        void setTriggerOnEnvelope(const unsigned int& threshold, void callback(), const unsigned int& secondFactor=0);
}

NeuroBoard.cpp (code omitted for brevity)

The ISR is basically a timer that runs on the Arduino. I’ve configured it so every second I get about ~50,000 readings from the analog per second. The envelopeValue is the highest reading recorded, then subtracted by one every time a reading isn’t equal to or greater than it.

int envelopeValue;

ISR (TIMER1_COMPA_vect) {
    int reading = analogRead(channel);
    envelopeValue = (reading >= envelopeValue) ? reading : envelopeValue - 1;
}

void NeuroBoard::setTriggerOnEnvelope(const unsigned int& threshold, void callback(), const unsigned int& secondFactor=0) {

    // TODO: Call callback when passed threshold is met by envelope value.

    const int THRESHOLD_SCALE_FACTOR = threshold / 10;
    int secondThreshold = secondFactor;

    if (secondFactor == 0) {
        secondThreshold = threshold - THRESHOLD_SCALE_FACTOR;
    }

    if (envelopeValue >= threshold) {
        if (!this->thresholdMet) {
            this->thresholdMet = true;
            callback();
        }
    } else {
        if (envelopeValue <= secondThreshold) {
            this->thresholdMet = false;
        }
    }

}

Note: Because this code is for an Arduino, I cannot use any standard library functions or imports. However, because this section of our code is pure c++, I don’t think it will be an issue. But please consider that if you decide to write an answer. Thanks!