plugins – Show post only for user that matches category

Disclaimer: I am not a developer. I know really a little code.

Hey!
Thank you for your time!

Well, the situation is like this:

I have posts that are set to “CategoryA” for example.
In Elementor I want to show the user in his personal dashboard only the recent post that matches his Membership(using paid membership pro, membershipname=categoryname).

In the picture, in red the posts that should not be shown because the user is not matching this category.
status 1

Is there is any way to make sure that:

Posts are shown category = user role OR user membership name

Thank you!

google sheets – Conditional formatting if cell text matches one of multiple other checked cells texts

Finally, after literally 8+ hours of trying around, I found a solution.

First I filter all the Recipes that are checked with in cell I3

=FILTER(B3:B,C3:C=TRUE).

Then I use 2 conditional formatting formulas:

Forumla for A1:A

=AND(countif($I$3:$I,B3)>0,B3<>"")

Formula for D3:G7

=AND(countif($I$3:$I,D3)>0,D3<>"")

For anyone wondering, I use AND to include a second rule (D3<>””) to exclude blank cells from highlighting.

Can’t believe it was so easy..

This is how it looks now:
enter image description here

google sheets – “Complicated” Conditional formatting with checkboxes and matches

First of all I apologize that I am failing to come up with a specific title about what exactly I am trying to achieve, so I made this picture as an example result.

enter image description here

If a recipe is checked, I want the formula for the conditional formatting to be looking for a recipe match (of all of the recipes checked (for which rows column C is True)) in D3:G7 and highlight certain cells if a match occurs.

The highlighted cells should be:

  • The cell in the row where the match was found in column A.
  • The cells where the match was found.

I have tried for hours and got familiar with a lot of new functions while working on my sheet but I just keep getting overwhelmed and find myself at a dead end on this specific task.

Would very much appreciate your help!

Comparison – change of the Robocopy file although MD5SUM matches

I recently joined a company where the administrator set up DFS and "manually DFS" it by manually copying files to speed up the process. Now there is a huge backlog on the secondary site, and dfs is barely working at the moment. I'm afraid to destroy and rebuild DFS without doing a full scan because DFS was set up with namespace with both sites active / active so files are present on both sites and out of sync.

Anyway, I wanted to start from scratch, so I did an audit between both systems with robocopy / mir / secfix / timfix / copyall / L from location 1 -> location 2 and from location 2 -> location 1.
My results were pretty strange and interesting at the same time, there are tons of files Robocopy sees as "modified", but they are not really modified. I looked at the attributes, timestamp, security settings, file size and everything identically. To the point that I even ran MD5SUM between files on both sites and the MD5SUM hash was also identical, DFS and Robcopy seem to think there is a change.

Is there any way to find out what changes have been made to both the DFS and the robocopy? Even if it is a program that compares files?

Any help is appreciated and thanks in advance.

Complex key restriction: Only allow if uuid is new or another column matches

For my use case, I try to get something like this to work with Azure Data Factory (ADF).

I am also interested in this question from a theoretical point of view. Is it possible to do something like this in a normal SQL engine like postgres?

I don't want to allow insertions based on this key: (non_unique_id, timestamp) where timestamp is a unique value for this pair.

for example:

Insert data:

non_unique_id: 0cf6c19c14
timestamp: 1970-01-01 00:00:01

case 1

before inserting:

select non_unique_id, timestamp from tbl where non_unique_id = 0cf6c19c14;

0 results

ALLOWED TO

Case 2

before inserting:

select non_unique_id, timestamp from tbl where non_unique_id = 0cf6c19c14;

0cf6c19c14, 1970-01-01 00:00:01
0cf6c19c14, 1970-01-01 00:00:01
0cf6c19c14, 1970-01-01 00:00:01
...

ALLOWED TO

Case 3

before inserting:

select non_unique_id, timestamp from tbl where non_unique_id = 0cf6c19c14;

0cf6c19c14, 2038-01-19 03:14:05
0cf6c19c14, 2038-01-19 03:14:05
0cf6c19c14, 2038-01-19 03:14:05
...

NOT ALLOWED

Of course there are other columns, but this shows the simplest cases

Google Sheets – Find entire column from a cell with multiple conditions returns multiple matches, separated by a comma for each search key

My data template:

data sheet

My desired lookup table (no formula in B3: B, only in B2):

Desired result

See this sheet for reference:

https://docs.google.com/spreadsheets/d/1TVU87H1fUDINQAhD5Cu5LXLuWW0GS4s6-FL274RVDz8/edit?usp=sharing

I have been struggling with this problem for a while now … Every few months I try to solve this problem on my own.

I've tried querying and filtering, but none works with ArrayFormula, while Vlookup can only return the first match …

Thank you in advance <3

C # – Search for words and matches in a text string

I have the following code:

Estaciones = Estaciones.Where(e => e.DireccionRural.Contains(address));

An address is searched for which is stored in a database.

for example: KALLE 37 A # 11-70

If you enter the sample address as it is in the (input), there is no problem and it will bring me the result. The problem is when I type the following:

KALLE 37 A 11-70

As you can see, I removed the special character (#) from the address string. If you place it like this, I will get no results. The idea is that it gives me the address, regardless of which character either removes the (-) or in this case if I remove the (11) and stay KALLE 37 A -70 so.

Any suggestion, thank you very much

Forward – How to ensure that the URL of the custom post type category matches the permalink

I have a custom post type with a rewrite rule that contains a variable that will later be defined by the category term & # 39; smoothie_category & # 39; is replaced. The argument line was passed to register_post_type is:

'rewrite' => ['slug' => 'smoothies/%smoothie_category%'],

An example URL:

/smoothies/category-slug/smoothie-slug

I use that post_type_link Check to replace this with the category of the post – everything works correctly so far.

The problem I have is that the URL can be manipulated to use any string instead of the real category:

/smoothies/any-string-here/smoothie-slug

As it reaches the right content, I want to be able to redirect to the right permalink that I think blog posts do – I have the post category as part of the URL: /blog/category/post-slugUsing an invalid category slug causes a 301 to switch to the correct post permalink. This is the behavior that I want to replicate.

I can insert code into my template, but which is the right or recommended hook to catch invalid URLs and redirect them to my custom post permalink?

Same value to return multiple matches in Google Sheets

I don't know if the title reflects the situation, but here it is. I have this type of information (picture below) where:

  • Column A: 1 serial for 100 cells
  • Column B: 10 series for 100 cells
  • Column C: 100 series for 100 cells

I would like to know if there is a formula that I can use to filter a list of boxes and return the appropriate box and ID with that formatting.

Enter the image description here

entity – "EntityMetadataWrapperException: Invalid data value specified. Make sure that it matches the required data type and format for the date field."

I'm working on creating a calendar event, so I've created a custom event storage module for a custom content type. I installed the entity and date modules and created a date field (partner_event_date) that accepts values ​​from and up to the date.

In my custom module I use the following code.

$wrapper->field_partner_event_date->set(array(
  'value' => date('Y-m-d H:i:s',$dateFrom),
  'value2' => date('Y-m-d H:i:s', $dateTo),
));

The following output is displayed at the top of the screen.

array(
  'value' => '2022-02-05 00:00:00',
  'value2' => '2024-07-03 00:00:00',
)

The error I get is the following.

EntityMetadataWrapperException: Invalid data value specified. Make sure it matches the required data type and format. Value at node () -> field_partner_event_date:. in EntityMetadataWrapper-> set () (line 122 of /sites/all/modules/entity/includes/entity.wrapper.inc).

I installed my module on a new Drupal installation. It works fine while the client site (which has already been created) displays this error message during installation and configuration. Can anyone help?