8 – Filtered User View that is Shown to a Logged In User who Selected a Particular Value for a Field

Using Drupal 8 Views, I’d like to make a user view where the Filter Criteria on left specify a certain display of users that will be shown only to a logged in user who has put a specific value in a profile field. Basically access to the view is granted to the logged in user only if they have a particular answer to a field in their profile.

A real world example of this type of view would be a dating website, where the logged in user who answered male in his profile field would see a view of the users who answered female on their profile fields. Another scenario is a person who is a doctor at a clinic who sees a user view of patients who input into a profile field that they were 80 years old, and this doctor is only granted access to this view if he input doctor in his profile field. But if he wrote nurse, he would not see this view. So basically, the right answer in a profile field, grants permission to see the user view.

I’ve tried taxonomy fields, and regular fields, to make a group of doctors who have selected the tag doctor and are allowed to see this view of 80 year old patients. Or to use the dating example, a group of men who have access to the view of women because they’ve selected the tag men. And then used contextual filters, relationships for those fields and the logged in user, but have not hit on the right specific solution.

The solutions I see are generally to provide a user view that is exactly the same group as the logged in user. I’m looking to provide a user view that is unrelated to the logged in user, and shown to him or her only if they answered a particular field with a particular value. I hope someone can provide some clear step by step insight. Thanks.

Create dynamic calculated column for filtered list view

I have a SharePoint list of 20000 items, where each item has 11 different columns, with values (tags) as per the item, that I add manually.

So, I want to create a new column with a URL where the user can click and see a filtered view of all items associated with the same tags across the 11 columns that have been added historically.

I can create a filter for a few items manually but I need to repeat this process for 20 new items everyday, which is time consuming. I also want the filtered views for all historical list items.

Please help me write a conditional formula to achieve this.

networking – Centos7 packets filtered without firewalld

I have 2 centos7 servers, I want to create a glusterfs shared volume on both, to do so I need the port 24007 opened on both.

I am testing with nc for the moment. Here server2 is listening to port 24007

root@swarm-node2 ~ # nc -l 24007
root@swarm-node2 ~ # netstat -na | grep 24007
tcp        0      0 0.0.0.0:24007           0.0.0.0:*               LISTEN

On both server firewalld is disabled :

root@swarm-node2 ~ # systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)

root@swarm-node1 ~ # systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: inactive (dead) since Tue 2021-06-08 14:55:42 CEST; 23h ago

With server1 I am trying to connect to port 22 (for testing, it works) then 24007 (it doesn’t):

root@swarm-node1 ~ # nc -zv swarm-node2 22
Ncat: Version 7.50 ( https://nmap.org/ncat )
Ncat: Connected to @ipsrv2:22.
Ncat: 0 bytes sent, 0 bytes received in 0.24 seconds.

root@swarm-node1 ~ # nc -zv swarm-node2 24007
Ncat: Version 7.50 ( https://nmap.org/ncat )
Ncat: Connection timed out.

I am running a tcpdump on server2 so we can see packets arriving from srv1

root@swarm-node2 ~ # tcpdump -i eth0 -nn port 24007
listening on eth0, link-type EN10MB (Ethernet), capture size 262144 bytes
14:41:20.223909 IP @ipsrv1.54398 > @ipsrv2.24007: Flags (S), seq 2092224680, win 29200, options (mss 1460,sackOK,TS val 85574120 ecr 0,nop,wscale 7), length 0
...
3 packets captured
3 packets received by filter

It says received by filter, I am not sure what is filter at this step (firewalld is off) so it might be iptables ?

I don’t see anything in iptables logs (it is empty even though rsyslog is saying DROP packets should be log) So I added a rule in iptables on srv2 to accept all packets comming from srv1

-A INPUT -s @ipsrv1/32 -i eth0 -m comment --comment "050 allow all from other nodes: 46.105.47.47" -j ACCEPT

As seen by TCPDUMP, packets are arriving to server2 and passed to filter but what is filter here ? firewalld is disabled and iptables should allow or at least log these packets.
Do you have any ways of testing that with more details

Create a Flow to transfer sharepoint list entries to another sharepoint list filtered

I Have one SP list called “Main” with columns “Sales Order”, “Sales Rep”, “Customer Name”, “Product”, “Amount”.

Depending on the Sales Rep Name, the respective entries of the “Main” list, should be updated with a flow to another list, so that each Sales Rep can see only their own orders (access setup for the individual lists is set).

Cannot figure out how to set the flow to filter the entries of the “Main” list and update the entries to the shortlists of each sales representative.

Any suggestion would be highly appreciated.

8 – View groups by vocabulary in wrong order when being filtered by a second vocabulary

I am having a problem with my ‘Grouped By’ groups (term reference) being re-ordered when there is a filter for a second term reference.

Details:

  1. My People content type has a People Category.
  2. People are ‘Grouped By’ People Category vocabulary in order by term weight. This order is important.
  3. People can also be placed in a Department vocabulary.
  4. Not all People have a Department.
  5. The View filters by Department. The filter is exposed.
  6. The Sort Criteria is only People Category (asc)

Here is how they are displayed:

People Category 2

Person 1 (Department 1)

People Category 1

Person 2 (No department)

To summarize: If a Person has no Department, its Category grouping is pushed down out of order.

Here is what I have tried:

  1. Added People Category as a sort criteria.
  2. Added People Category and Department as sort criteria
  3. Changed Department filter from “Is not empty” to “is one of”
  4. People Category is already before Department in the Filter Criteria
  5. Moved the Department filter to a second filter group.
  6. Moved the People Category filter to a second filter group.

2016 – Threshold error message upon opening filter drop-down on indexed column already filtered by *one* value

I have a list with 7000+ items on a SP 2016 environment that has the default threshold of 5000 items. I created a view filtered on ‘ID is less than 2500’. This view contains 5 columns (all indexed), has no sorting, grouping, or totals, and is paged in batches of 30. The view displays just fine.

Issue: error message on returning to filter drop-down

When I pull down the column head drop-down menu, select one filter value, close the drop-down, the filtering is applied correctly.
However, when I return to that drop-down, the following error alert appears.

Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.

Inspecting in F12, I found the offending request is:

https://(sitecollection)/(web)/_layouts/15/filter.aspx?ListId=(ListId)&FieldInternalName=(fieldname)&ViewId=(ViewId)&FilterOnly=1&Filter=1&FilterField1=(fieldname)&FilterValue1=abc

When more than one value have been selected previously, the request becomes (note the plural on FilterFields1 and FilterValues):

https://(sitecollection)/(web)/_layouts/15/filter.aspx?ListId=(ListId)&FieldInternalName=(fieldname)&ViewId=(ViewId)&FilterOnly=1&Filter=1&FilterFields1=(fieldname)&FilterValues1=abc%3B%23def

Related issue: Filter.aspx and GetDistinctValues

Notes:

  • After I click OK to get rid of the error message, the filter drop-down only displays ‘Clear Filters on (this column)’, not the actual filter values.
  • This only happens when I select one filter value from the drop-down and only on indexed columns

A second, possibly related issue is the following:
When I filter out one value on an indexed column, then try to filter one value in another column (whether or not indexed), the second filtering is not done and an HTTP 601 error appears on the POST call to inplview.aspx. The second filtering only gets done after I unfilter the first column.

Any ideas on why this happens or better still, how to solve this?

kql – Show a filtered document library from Sharepoint site to another site (same intranet)

I’m trying to design a site in our intranet to show documents related to our department. I want to show documents in libraries/folders/lists from the main site on our site and be able to filter them depending on the Properties (columns in the libraries/folders/lists) they are defined with (for example “Process”, “Document Type” & “Target Group”).
I try to use a Higlighted Content web part and write a query with KQL. However i cannot access them as i hoped, for example:

Process: "Standards"

I’ve read that they must be Queryable and such, but how do i find that out? I have no admin access to the main site and cant seem to find the info.

Any way to do a draw from a filtered SharePoint list (multiple random items)?

I have a list in SharePoint online where I want to filter on several columns and then select a specific number of random items that meet the filter criteria. Is this possible?

For example, I may have 3000 items in my list, but I want to choose some from the ones who have Status = Approved and School = Central High School. After I filter on the Status and School columns, I may have 75 list items. From those items, I need to define the number to be selected (let’s say in this case it was 50), and I’d like SharePoint to do a random selection of 50 items (from the 75 who met the filter criteria, out of the 3000 in the list). Ideally, I’d then like to use Flow to change the Status value for those list items, to change them from Approved to Placed.

I have a list where I’ll need to make multiple draws, where there may be 7-10 fields used to filter the list first.

My first thought was to do something manually (filter the list items, then have a “DrawNumber” column where I could assign each item a sequential number, then use a standalone RNG to pull from those numbers before manually reconciling the SharePoint list items to the RNG selections), but it will be time-consuming, so if I can automate it I’d prefer that.

If needed, I could create a view for each permutation and build some kind of flow around that, but what I’d love to do is be able to dynamically filter my results in the browser, choose the number of items to be picked, apply my “picker”, and then apply a flow to those items.

Another alternative that wouldn’t be too bad would be to generate the set of numbers in a standalone RNG if I could somehow paste them in (or otherwise access them) for the DrawNumber column filter.

So I could go to https://numbergenerator.org/ and set it to pull 50 numbers between 1 and 75, and then open that set of numbers in Excel:

Set of random numbers

But then, in my SharePoint list, the only way I see to choose the filter values is to click on each individual box (this screenshot shows ID, but I’d want to use my DrawNumber column):

SharePoint filter pane

Even if I create a view and try to paste in the numbers for the filter value, it only seems to accept a single number at a time (not a set of comma or space-delimited numbers). If I enter “1 2”, I get an error telling me that’s not a number. If I enter “1,2”, like this…

filter criteria

… it removes the comma and treats it like “12”.

Any suggestions on how to streamline this process?