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.

network – Nmap Scan Shows Filtered Ports for VNC, RDP, SAMBA & SSH on iOS – is this normal?

This can’t be normal, right?

Wrong, it can be normal.

Your scan shows that there is only one open port, on port 62078.

The results will be similar for other iDevices. For example, an iPhone 11 Pro on my network shows 985 closed ports, 14 filtered ports, and one open port (port 62078).

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.

ct.category theory – Filtered 2-colimits commute with finite 2-limits

Is there an explicit proof anywhere in the literature that filtered 2-colimits commute with finite 2-limits (all meant in the weak bicategorical sense) in the 2-category of groupoids? I have only been able to find a handful of papers about filtered 2-colimits, notably Dubuc and Street’s A construction of 2-filtered bicolimits of categories, and have not found this result in any of them.

Of course one could try to deduce this from $infty$-categorical results, but the latter proofs are also often sketchy, and in the case of groupoids it ought to be possible to give a concrete constructive proof.

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.

magento2 – Custom Product Collection not Getting Filtered by Layered Navigation in Magento 2.4.1

I am trying to create a page that show a list of products that have price which is greater than some specific amount and i also want to add Layered navigation for filter these product collection based upon different attribute. But in Magento 2.4.1 when i implement the code for layered navigation in layout file it not properly work and show a layered navigation.

So Here the specific attribute product list are correctly show on custom page, but when i add layered navigation functionality the custom page are not properly render and Layered navigation not work properly.

Custom Product List Page

And When i click on Above page generated link it show product page data like this:-

Product page data

And if we click on any generate data link it redirected to custom product page with already layered navigation applied but not properly worked.

Custom Product page

My Module File Structure

app/code/Test/Special/Block/Navigation State.php

<?php
namespace TestSpecialBlockNavigation;
class State extends MagentoLayeredNavigationBlockNavigationState
{
    public function __construct(
        MagentoFrameworkViewElementTemplateContext $context,
        TestSpecialModelLayerResolver $layerResolver,
        array $data=())
{
            parent::__construct($context, $layerResolver, $data);

}
}

app/code/Test/Special/Block/Product ListProduct.php

<?php
namespace TestSpecialBlockProduct;
class ListProduct extends MagentoCatalogBlockProductListProduct
{
    public function __construct(
        MagentoCatalogBlockProductContext $context,
        MagentoFrameworkDataHelperPostHelper $postDataHelper,
        TestSpecialModelLayerResolver $layerResolver,
        MagentoCatalogApiCategoryRepositoryInterface $categoryRepository,
        MagentoFrameworkUrlHelperData $urlHelper,
        array $data = ()
    ) {
        parent::__construct($context, $postDataHelper, $layerResolver,
            $categoryRepository, $urlHelper, $data);
    }
}

app/code/Test/Special/Block Link.php

<?php
namespace TestSpecialBlock;
class Link extends MagentoFrameworkViewElementHtmlLink
{
    protected function _toHtml()
    {
        if (false != $this->getTemplate()) {
            return parent::_toHtml();
        }
        return '<li><a ' . $this->getLinkAttributes() . ' >' . $this->escapeHtml($this->getLabel()) . '</a></li>';
    }
}

app/code/Test/Special/Block Navigation.php

<?php
namespace TestSpecialBlock;
class Navigation extends MagentoLayeredNavigationBlockNavigation
{
    public function __construct(
        MagentoFrameworkViewElementTemplateContext $context,
        TestSpecialModelLayerResolver $layerResolver,
        MagentoCatalogModelLayerFilterList $filterList,
        MagentoCatalogModelLayerAvailabilityFlagInterface $visibilityFlag,
        array $data = ()
    ) {
        parent::__construct($context, $layerResolver, $filterList,
            $visibilityFlag);
    }
}

app/code/Test/Special/Controller/Index Index.php

<?php
namespace TestSpecialControllerIndex;
class Index extends MagentoFrameworkAppActionAction
{
    protected $_pageFactory;

    public function __construct(
        MagentoFrameworkAppActionContext $context,
        MagentoFrameworkViewResultPageFactory $pageFactory)
    {
        $this->_pageFactory = $pageFactory;
        return parent::__construct($context);
    }

    public function execute()
    {
        return $this->_pageFactory->create();
    }
}

app/code/Test/Special/etc/frontend routes.php

<?xml version="1.0" ?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:App/etc/routes.xsd">
    <router id="standard">
        <route frontName="special-machine" id="special">
            <module name="Test_Special"/>
        </route>
    </router>
</config>

app/code/Test/Special/etc di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/ObjectManager/etc/config.xsd">
    <preference for="MagentoCatalogModelLayerContextInterface" type="MagentoCatalogModelLayerContext" />
    <preference for="MagentoCatalogModelLayerItemCollectionProviderInterface" type="MagentoCatalogModelLayerCategoryItemCollectionProvider" />
    <preference for="MagentoCatalogModelLayerStateKeyInterface" type="MagentoCatalogModelLayerCategoryStateKey" />
    <preference for="MagentoCatalogModelLayerCollectionFilterInterface" type="MagentoCatalogModelLayerCategoryCollectionFilter" />
    <preference for="MagentoCatalogModelLayerFilterableAttributeListInterface" type="MagentoCatalogModelLayerCategoryFilterableAttributeList" />
    <preference for="MagentoCatalogModelLayerAvailabilityFlagInterface" type="MagentoCatalogModelLayerCategoryAvailabilityFlag" />
    <preference for="MagentoCatalogModelResourceModelLayerFilterPrice" type="TestSpecialModelResourceModelLayerFilterPrice" />
</config>

app/code/Test/Special/etc module.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
    <module name="Test_Special" setup_version="1.0.0">
    </module>
</config>

app/code/Test/Special/Model/Layer Resolver.php

<?php
namespace TestSpecialModelLayer;
class Resolver extends MagentoCatalogModelLayerResolver
{
    protected $layer;
    protected $layersPool;

    public function __construct(
        MagentoFrameworkObjectManagerInterface $objectManager,
        TestSpecialModelLayer $layer,
        array $layersPool
    ) {
        $this->layer = $layer;
        $this->layersPool = $layersPool;
        parent::__construct($objectManager, $layersPool);
    }

    public function create($layerType)
    {
        if (isset($this->layer)) {
            throw new RuntimeException('Catalog Layer has been already created');
        }
        if (!isset($this->layersPool($layerType))) {
            throw new InvalidArgumentException($layerType . ' does not belong to any registered layer');
        }
        $this->layer = $this->objectManager->create($this->layersPool($layerType));
    }
}

app/code/Test/Special/Model/ResourceModel/Layer/Filter Price.php

<?php
namespace TestSpecialModelResourceModelLayerFilter;
use MagentoFrameworkAppHttpContext;
use MagentoFrameworkIndexerDimensionFactory;
use MagentoFrameworkSearchRequestIndexScopeResolverInterface;

class Price extends MagentoCatalogModelResourceModelLayerFilterPrice
{
    public function __construct(
        MagentoFrameworkModelResourceModelDbContext $context,
        MagentoFrameworkEventManagerInterface $eventManager,
        TestSpecialModelLayerResolver $layerResolver,
        MagentoCustomerModelSession $session,
        MagentoStoreModelStoreManagerInterface $storeManager,
        $connectionName = null,
        IndexScopeResolverInterface $priceTableResolver = null,
        Context $httpContext = null,
        DimensionFactory $dimensionFactory = null
    ) {
        parent::__construct($context, $eventManager, $layerResolver, $session, $storeManager, $connectionName, $priceTableResolver, $httpContext, $dimensionFactory);
    }
}

app/code/Test/Special/Model Layer.php

<?php
namespace TestSpecialModel;
use MagentoCatalogApiCategoryRepositoryInterface;
use MagentoCatalogModelResourceModelProductAttributeCollectionFactory as AttributeCollectionFactory;
use MagentoCatalogModelResourceModelProductCollectionFactory;
class Layer extends MagentoCatalogModelLayer
{
    protected $_productCollectionFactory;
    public function __construct(
        MagentoCatalogModelLayerContextInterface $context,
        MagentoCatalogModelLayerStateFactory $layerStateFactory,
        AttributeCollectionFactory $attributeCollectionFactory,
        MagentoCatalogModelResourceModelProduct $catalogProduct,
        MagentoStoreModelStoreManagerInterface $storeManager,
        MagentoFrameworkRegistry $registry,
        CategoryRepositoryInterface $categoryRepository,
        CollectionFactory $productCollectionFactory,
        array $data = ()
    ) {
        $this->_productCollectionFactory = $productCollectionFactory;
        parent::__construct(
            $context,
            $layerStateFactory,
            $attributeCollectionFactory,
            $catalogProduct,
            $storeManager,
            $registry,
            $categoryRepository,
            $data
        );
    }
    public function getProductCollection()
    {
            $productCollection = $this->_productCollectionFactory->create()
                ->addAttributeToSelect('*')
                ->addAttributeToFilter('price', ('lt' => 95))
                ->setOrder('entity_id', 'ASC');
            return $productCollection;
    }
}

app/code/Test/Special/view/frontend/layout special_index_index.xml

<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="2columns-left" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
<body>
    <attribute name="class" value="page-products"/>
    <referenceContainer name="content">
        <block class="TestSpecialBlockProductListProduct" name="layerednavigation_index_index" as="product_list" template="Magento_Catalog::product/list.phtml">
            <container name="category.product.list.additional" as="additional" />
            <block class="MagentoFrameworkViewElementRendererList" name="category.product.type.details.renderers" as="details.renderers">
                <block class="MagentoFrameworkViewElementTemplate" name="category.product.type.details.renderers.default" as="default"/>
            </block>
            <block class="MagentoCatalogBlockProductProductListItemContainer" name="category.product.addto" as="addto">
                <block class="MagentoCatalogBlockProductProductListItemAddToCompare"
                       name="category.product.addto.compare" as="compare"
                       template="Magento_Catalog::product/list/addto/compare.phtml"/>
            </block>
            <block class="MagentoCatalogBlockProductProductListToolbar" name="product_list_toolbar" template="Magento_Catalog::product/list/toolbar.phtml">
                <block class="MagentoThemeBlockHtmlPager" name="product_list_toolbar_pager"/>
            </block>
            <action method="setToolbarBlockName">
                <argument name="name" xsi:type="string">product_list_toolbar</argument>
            </action>
        </block>
    </referenceContainer>


    <!--Magento core-->
    <!--<referenceContainer name="sidebar.main">-->
        <!--<block class="MagentoLayeredNavigationBlockNavigationCategory" name="catalog.leftnav" before="-" template="Magento_LayeredNavigation::layer/view.phtml">-->
            <!--<block class="MagentoLayeredNavigationBlockNavigationState" name="catalog.navigation.state" as="state" />-->
            <!--<block class="MagentoLayeredNavigationBlockNavigationFilterRenderer" name="catalog.navigation.renderer" as="renderer" template="Magento_LayeredNavigation::layer/filter.phtml">-->
                <!--<arguments>-->
                    <!--<argument name="product_layer_view_model" xsi:type="object">MagentoLayeredNavigationViewModelLayerFilter</argument>-->
                <!--</arguments>-->
            <!--</block>-->
        <!--</block>-->
    <!--</referenceContainer>-->

    <!--Custom layered Navigation-->
    <referenceContainer name="sidebar.main">
        <block class="TestSpecialBlockNavigation" name="catalog.leftnav" as="navigation" before="-" template="Magento_LayeredNavigation::layer/view.phtml">
            <block class="TestSpecialBlockNavigationState" name="catalog.navigation.state" as="state" template="Magento_LayeredNavigation::layer/state.phtml"/>
            <block class="MagentoLayeredNavigationBlockNavigationFilterRenderer" name="catalog.navigation.renderer" as="renderer" template="Magento_LayeredNavigation::layer/filter.phtml"/>
        </block>
    </referenceContainer>

</body>
</page>

How to get max value of filtered query post

I have a query post to filter my post in my CPT, filtered on front end by a form filter.

The problem is that with different filter, I have different max value.

For example I have the following custom field meta value:

  • filter #1 – Ford, Nissan, Toyota
  • filter #2 – Blue, Red, White
  • and on with other filter#3, #4 etc…

Choosing different filter (for example ‘Ford and Red’ vs ‘Nissan and White’), I may have different max value price of total cars in the same query post, that have the same characteristics.

How I can get the max value of current filter on query post, and use this value on each line of same query post to show the different price from the max?

Someone can help me?
Thanks in advance

forms – DropDown menu link to database and filtered

Morning,
I’m doing free integration work for a non-profit organization that also works with people with disabilities.

This organization at the regional level promotes and organizes events to which provincial “societies” enroll participants electronically through their website.

The events are then divided into provincial and regional, so the ability to register for a particular event is restricted to companies in a particular province or to all companies if regional.

For the management I used this plugin : https://wp-events-plugin.com/

I have solved this problem by associating to each society account (e.g. society 1, society 2) a role corresponding to the province (e.g. society of province 1, society of province 2) in order to automatically filter the events (e.g. regional events, events by province 1, events by province 2).

With this criterion each society can see and enroll its participants only in the events that belong to it.

Now I find a difficulty because every time the main organization creates an event one of the companies must be available to organize it … I thought I could manage it with a form, so that the companies select from a drop-down menu the event, then filled in the required fields the form is forwarded by mail or on wordpress portal to the organization that examined the valid request.

The problem is that with the plugins that manage the forms I can not create a dropdown menu that goes to read the events on the database of the plugin and filters them according to the role that the authenticated user has.

Example: company 1 belonging to the province 1 accesses the organization request form and must select from a drop-down menu, populated by events open to the province 1 or regional, the event he wants to organize, then fill out the form and send it.

Eventually I accept suggestions to manage it differently from the form.

Any help is deeply appreciated.

Andrea

P.S. = Sorry for my poor English 🙂

Can a platform be filtered independently?

Hello, can a platform be filtered independently?
For example:
I want to filter on the platform: URL shortener, only URL greater than 4 PR
I was playing for a while, but all search engines are selected in general.