How to Filter More than 10 Criteria Using Calculated Fields

Sorry but I’m not too familiar with SharePoint so hopefully my terminology is correct. From our Document Library we are trying to create two separate Lists, that will display various documents. These two Lists will each have 4 Subjects with various sub-Categories (no more than 3). I thought I found a solution by modifying the view of the page and using the Filter option. The problem was that I needed a few more lines of Filters. I did find this post that sounds like Option 1 of ECM4D’s answer would suit our needs:

“1. Simplify your filter query with calculated fields. When you have complex queries it is good practice to create calculated columns with formula which has some boolean logic of the view and returns TRUE or FALSE results, and then you can create views using these calculated column(s). This technique is highly recommended because can help you to strongly simplify your queries and improve performance.”

Can someone provide a few more details or an example of how this would be done? Or point me in the right direction? Thanks! 🙂

SharePoint list filter based on another list

Thank you for reading

I want to create a filtered view based on another list.

I plan to have a list with the location of users, and a list where users have to answer a questionnaire. I want the questionnaire list to show the questionnaire and answers for the user’s country only.

I guess I can query the “User list” to detect the [me] user and select only the country, but I don’t know who to do it. Could you help?

Thank you

Leonel

Designing database with filter tables

I am tasked with the redesign of an old database that is not performing very efficiently. Now I am no where near an expierenced database designer, so I am hoping you guys can help me figure out some things.

First of all the application has the user answer a few questions and performs some calculations based on the answers. This is the base of the application and the database should perform this with the best possible performance. So we have products that can be shown based on the answers of the questions. But the questions can also be “filtered” based on the answer(s) of a previous question(s). And also based on the user logged in and whether the user is using the application from within the platform instead of a webmodule. So the current structure has entities that can be “filtered” with each a filter table. So products has a product_filter table and questions has a question_filter table.

To explain the current structure further here is a diagram:

product ------------- product_id   product_filter ------------------- product_filter_id product_id // FK filter_label operator // i.e. equals, not equals, greather than etc. filter_value   question ------------- question_id   question_product ---------------------- question_product_id question_id // FK product_id // FK   question_product_filter ------------------- question_product_filter_id question_product_id // FK depenend_on_question_product_id filter_label operator // i.e. equals, not equals, greather than etc. filter_value 

For context the application currently is running on ASP classic and the wish for the database to be redesigned is because the system will be migrated to a ASP.NET application with the use of Entity Framework. So the senior dev has asked me to take a code first approach on redesigning the Database.

How to take screenshots with light filter enabled

The background color of my website is #0062cc. When using flux (blue light filter software) this color gets darker. I want to use this new darker color as a background color.

I took several screenshots (pressing PrtSc), but they all ignored the blue filter, so I can’t know which color corresponds to the darker color.

How to take a screenshot and get the same colors that I see when flux is turned on ?

Efficient algorithm to filter off points from a point cloud

I have a master point cloud, which essentially just a list of points with {x,y} coordinates.

The point cloud is HUGE ( like, it can contain more than 1 million points). The problem now is that I have another (sub)set of point clouds, and I need to check whether the points inside the second point clouds are the same with any of the points in the first point clouds, and then remove them from the list.

The characteristics of the second point cloud:

  1. The second point cloud points are usually clustered in a corner of the first point cloud ( but not always).
  2. None of the points from the second point cloud will lie outside of the first point cloud ( the first point cloud always contain every single point of the second point cloud)

The naive algorithm will be something like this:

   public static List<Point> FilterPoints(Lis<Point> master, List<Point> subset)    {         var FilteredPoints = new List<Point>();         for(int i=0; i< subset.Count; i++)      {         var isContained = false;         for(int j=0; j< master.Count; j++)         {           if(subset[i].X==master[j].X && subject[i].Y==master[j].Y)           {               isContained = true;               break;           }         }         if(!isContained)         {            FilteredPoints.Add( master[i]);         }          }       return FilteredPoints;  } 

But is there anyway to improve over the above naive algorithm in terms of speed, given the known characteristics of the both point clouds?

PS: I’ve also asked about how to make use of C# language characteristics( if any) in order to improve the speed for the above algorithm at SO.

Filter or Extract Data from RAW Data for $15

Hello, I will help you Filter or Extract Data Why choose me? 1. You will receive Professional Excel Data Workbook. 2. You will be working with Professional Excel Programmer and is Professional to work with. 3. You will enjoy how incredibly fast and convenient my process from pre-ordering to after sale service. 4. I provide Extra Fast Delivery Service. 5. My service is available 24/7. 6. Life-time support. I still support you even when your order is finished. 7. I always offer you Unlimited Revisions until you’re 100% Satisfied or Money Back Guarantee Feel Free to contact me if you have any concerns or questions Come with me to experience One of The Best Services on Seoclerk Thank you and Look forward to working with you.

by: Tommy1003
Created: —
Category: Data Entry
Viewed: 216


Filter a Library and multiple Lists on a Page based on the same column (date)

In classic mode a List Filter Web Part is available but what to do in a modern site. Is it still possible to use a classic page in a modern site with the List Filter Web Part? If yes how if no, is there an other way?

To use a classic page in a Modern site I found https://sharepointmaven.com/how-to-bypass-the-new-modern-team-site-page-experience/ To use a List Filter Web Part I read at https://support.office.com/en-gb/article/connect-a-filter-web-part-to-a-list-view-web-part-on-a-classic-page-4f3f6c10-0a1b-479d-8b4d-c4f1bf49bb3f?ocmsassetID=HA010250989&CorrelationId=850a38b4-541c-4c06-aa66-3785530925e6&ui=en-US&rs=en-GB&ad=GB#BMs1

But the Filter Web Part is not available in the categories on the classic page. Who can help me?