Who can apply for PASARA Registration?

Eligiblity:-

  • Limited Liability Partnership (LLP)
  • Private Limited Company
  • Sole Proprietorship
  • Partnership Firm
  • One Person Company (OPC)

Name & Business Aim: – Security Services or similar work need to be specified in the company name. Company objects require to be security services.
Director’s Eligibility: – For Police Verification applicant must be a Resident of India. The applicant must have financials stable (Income Tax Returns required)
MOU with Training Institute: – MOU needs to be inserted within the application of PASARA and training institute or an association as approved by the State. For ex-servicemen it’s free.
India First: – PSARA License cannot be granted to a person if he is found to following Links with organizations or corporations, who are banned In India. Etc.

.(tagsToTranslate)webmaster forum(t)internet marketing(t)search engine optimization(t)web designing(t)seo(t)ppc(t)affiliate marketing(t)search engine marketing(t)web hosting(t)domain name(t)social media

uicomponent – how to apply last filters saved in custom bookmark in frontend UI Component listing?

I created listing using UI Component in frontend. I also created custom bookmark for saving the state of the UI Component because I want store it as a customer, because the default bookmark only save state of admin user.

UI Component XML

<?xml version="1.0" encoding="UTF-8"?>
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
    <argument name="data" xsi:type="array">
        <item name="js_config" xsi:type="array">
            <item name="provider" xsi:type="string">rendyep_orderexport_log_listing.rendyep_orderexport_log_listing_data_source</item>
        </item>
    </argument>
    <settings>
        <spinner>rendyep_orderexport_log_columns</spinner>
        <deps>
            <dep>rendyep_orderexport_log_listing.rendyep_orderexport_log_listing_data_source</dep>
        </deps>
    </settings>
    <dataSource name="rendyep_orderexport_log_listing_data_source" component="Magento_Ui/js/grid/provider">
        <settings>
            <storageConfig>
                <param name="indexField" xsi:type="string">log_id</param>
            </storageConfig>
            <updateUrl path="mui/index/render"/>
        </settings>
        <dataProvider class="MagentoFrameworkViewElementUiComponentDataProviderDataProvider" name="xtento_orderexport_log_listing_data_source">
            <settings>
                <requestFieldName>id</requestFieldName>
                <primaryFieldName>log_id</primaryFieldName>
            </settings>
        </dataProvider>
    </dataSource>
    <listingToolbar name="listing_top">
        <bookmark name="bookmarks">
            <settings>
                <storageConfig>
                    <param name="saveUrl" xsi:type="url" path="rendyep/bookmark/save"/>
                    <param name="deleteUrl" xsi:type="url" path="rendyep/bookmark/delete"/>
                </storageConfig>
            </settings>
        </bookmark>
        <columnsControls name="columns_controls"/>
        <filters name="listing_filters"/>
        <paging name="listing_paging"/>
    </listingToolbar>
    <columns name="rendyep_orderexport_log_columns">
        <selectionsColumn name="ids">
            <settings>
                <indexField>log_id</indexField>
            </settings>
        </selectionsColumn>
        <column name="log_id" sortOrder="10">
            <settings>
                <filter>textRange</filter>
                <label translate="true">Log ID</label>
            </settings>
        </column>
        ....
        <column name="profile_id" component="Magento_Ui/js/grid/columns/select" sortOrder="40">
            <settings>
                <dataType>select</dataType>
                <filter>select</filter>
                <options class="RendyepOrderExportUiComponentListingOptionsOrderExportLogProfiles"/>
                <label translate="true">Profile</label>
            </settings>
        </column>
        ....

Custom bookmark table & related things

Basically the custom bookmark table, model, controller that handle the save and delete, and all PHP classes related to it (BookmarkManagement, BookmarkRepository, etc) is the same as the default bookmark, except that the user_id field is linked to customer_entity instead of admin_user.
The data is also stored successfully in database when the listing requested data update using the custom saveUrl:
https://domain.com/rendyep/bookmark/save/

# bookmark_id   user_id namespace   identifier  current title   config  created_at  updated_at
14  15  rendyep_orderexport_log_listing current 0       {"current":{"filters":{"applied":{"placeholder":true,"profile_id":"2"}},"displayMode":"grid","columns":{"log_id":{"visible":true,"sorting":false},"files":{"visible":true,"sorting":false},"records_exported":{"visible":true,"sorting":false},"result":{"visible":true,"sorting":false},"result_message":{"visible":true,"sorting":false},"ids":{"visible":true,"sorting":false},"export_type":{"visible":true,"sorting":false},"entity":{"visible":true,"sorting":false},"profile_id":{"visible":true,"sorting":false},"created_at":{"visible":true,"sorting":false},"manual_export":{"visible":true,"sorting":false}},"paging":{"options":{"20":{"value":20,"label":20},"30":{"value":30,"label":30},"50":{"value":50,"label":50},"100":{"value":100,"label":100},"200":{"value":200,"label":200}},"value":30},"positions":{"ids":0,"log_id":1,"export_type":2,"entity":3,"profile_id":4,"files":5,"records_exported":6,"result":7,"result_message":8,"created_at":9,"manual_export":10}}}   0000-00-00 00:00:00 0000-00-00 00:00:00
15  15  rendyep_orderexport_log_listing default 1   Default View    {"views":{"default":{"label":"Default View","index":"default","editable":false,"data":{"filters":{"applied":{"placeholder":true}},"displayMode":"grid","columns":{"log_id":{"visible":true,"sorting":false},"files":{"visible":true,"sorting":false},"records_exported":{"visible":true,"sorting":false},"result":{"visible":true,"sorting":false},"result_message":{"visible":true,"sorting":false},"ids":{"visible":true,"sorting":false},"export_type":{"visible":true,"sorting":false},"entity":{"visible":true,"sorting":false},"profile_id":{"visible":true,"sorting":false},"created_at":{"visible":true,"sorting":false},"manual_export":{"visible":true,"sorting":false}},"paging":{"options":{"20":{"value":20,"label":20},"30":{"value":30,"label":30},"50":{"value":50,"label":50},"100":{"value":100,"label":100},"200":{"value":200,"label":200}},"value":20},"positions":{"ids":0,"log_id":1,"export_type":2,"entity":3,"profile_id":4,"files":5,"records_exported":6,"result":7,"result_message":8,"created_at":9,"manual_export":10}},"value":"Default View"}}}    0000-00-00 00:00:00 0000-00-00 00:00:00

The Issue

After applying any filter(s), the custom bookmark data is updated successfully in database. But when I reload the listing page, the filter is gone and is not populated, and the custom bookmark data is reset to its original state without any filters in it.

Is there a way to populate the filters using the last saved ones in custom bookmark data upon reloading the listing page?

mariadb – Does binary logging apply to ColumnStore?

When binary logging is enabled, does MariaDB’s binary logging also record ColumnStore events, and not just InnoDB events? For example, does it log an UPDATE made to a ColumnStore table row?

I’ve searched the MariaDB documentation and it doesn’t mention whether binary logging applies only to some, but not all, storage engines. Is binary logging independent of the storage engine used?

Why does Google Sheets Conditional Formatting not apply properly to all cells?

Alright, so I’ve been having this issue for a few hours now and am confident to say that I can’t fix it by myself.

I’ve been playing around with Google Sheets trying to apply Conditional Formatting when another referenced cell is not empty.

Here’s an image of the issue, it will definitely help you understand what I’m trying to do.

However, here’s what happens when I do the following two things (using an IF function to determine the state and then parse the true or false state towards the Conditional Formatting rule), here’s where the broken magic comes into play.

When I set it to =IF(ISBLANK(B2), false, true), this happens.
But when I reverse it and set it to =IF(ISBLANK(B2), true, false), this happens again.

I am lost to why this happens as from what you can see in the screenshots, B2 is never empty.

EDIT: For whatever reason, when I set it to =IF(ISBLANK(B2), true, true), it works as expected, as seen here. I would still like to hear an explanation if anybody has one.

pathfinder 1e – Does the cleric’s ability to spontaneously cast cure spells apply to the Breath of Life spell?

Unfortunately, the “spontaneous casting” class feature for clerics (which is the one that allows this trade) clearly states.

 A cure spell is any spell with “cure” in its name

So no, a “breath of life” is not allowed by the rules as written.
Obviously, nothing is stopping your GM from allowing it anyway, but the rules are against you

magento2 – Error: Unable to apply data patch when running setup:upgrade after magento version upgrade to 2.3.5-p2

I am getting this error when i run bin/magento setup:upgrade command

Unable to apply data patch MagentoSalesSetupPatchDataConvertSerializedDataToJson for module Magento_Sales. Original exception message: Notice: Undefined index: option_type in /chroot/home/a0a91d92/int.parriscues.com/vendor/magento/module-sales/Setup/SerializedDataConverter.php on line 33

When i remove data from sales_order_item table then it works fine.
I upgraded from magento 2.1 to 2.3.5-p2.

In sales_order_item table product_options column is showing data like this

a:2:{s:15:"info_buyRequest";a:6:{s:4:"uenc";s:0:"";s:7:"product";s:3:"103";s:28:"selected_configurable_option";s:0:"";s:15:"related_product";s:0:"";s:7:"options";a:0:{}s:3:"qty";i:1;}s:7:"options";a:0:{}}

and i think the issue is in this format.

linux networking – Apply DNS configuration to all interfaces

On Ubuntu 20.04, how can I configure DNS for all Ethernet interfaces, regardless of how they’ve been named? I have some machines with eth0 as the primary network interface and others with ens5. I’d like to use the same DNS configuration regardless of interface names. A colleague had recommended NetPlan, so that’s what I’ve been trying first. The following configuration (with placeholder IP addresses, domain names, and MAC addresses) avoids some errors, such as an unescaped * being interpreted as a YAML alias attempt, or match: {name: {}} generating a Name= networkd configuration line that its logs flag as ignored. But it renders the machine unreachable.

network:
  version: 2
  ethernets:
    all-ethernet-interfaces:
      match:
        name: "*"
      dhcp4-overrides:
        use-dns: no
      nameservers:
        addresses: (10.1.2.3, 10.1.2.4)
        search: (my.domain.com)

The only other netplan configuration fragment is 50-cloud-init.yaml:

network:
    ethernets:
        eth0:
            dhcp4: true
            dhcp6: false
            match:
                macaddress: 01:20:34:50:67:08
            set-name: eth0
    version: 2

I have been able to work around the issue with duplicate, interface-specific, configuration sections, but I’d prefer to use a less repetitious and more flexible approach. I’m open to configuring systemd-networkd or systemd-resolved more directly instead of using netplan. I’ll be using Ansible to apply the configuration once it’s developed.

google sheets – How to apply DATEVALUE to column

I have two columns with extracted date values. I want to add those two values together and apply to the whole column. The data looks like this:

AM     AN          AO      AP          AQ 
date    time        year    day value   time value 
Oct 12  14:15:00    2020    #N/A        0.59375

I want to concatenate or join the values of AM and AO, pass to DATEVALUE, and apply to the whole column. Current the formula for AP is:

=DATEVALUE(concatenate(AM2,", ",AO2))

But I cannot apply this using ArrayFormula.

I’ve tried using CONCAT, JOIN, and & on the two values without success, e.g.

=ArrayFormula(DATEVALUE(AM2:AM & AO2:AO))

c – Does this alignment of structure objects apply only to structure objects being used as elements of an array?

In Computer Systems: a Programmer’s Perspective,

In addition, the compiler may need to add padding to the end of the
structure so that each element in an array of structures will satisfy
its alignment requirement. For example, consider the following
structure declaration:

struct S2 {
int i;
int j;
char c;
};

If we pack this structure into 9 bytes, we can still satisfy the
alignment requirements for fields i and j by making sure that the
starting address of the structure satisfies a 4-byte alignment
requirement.

Consider, however, the following declaration:

struct S2 d[4];

With the 9-byte allocation, it is not possible to satisfy the
alignment requirement for each element of d, because these elements
will have addresses x_d, x_d + 9,x_d + 18, and x_d + 27. Instead, the
compiler allocates 12 bytes for structure S2, with the final 3 bytes
being wasted space
. That way, the elements of d will have addresses
x_d, x_d + 12, x_d + 24, and x_d + 36. As long as x_d is a multiple of
4, all of the alignment restrictions will be satisfied.

What does “allocates 12 bytes for structure S2, with the final 3 bytes being wasted space” happen to:

  • only S2 structure objects which are used as elements of an array, or
  • any S2 structure object whether or not it is an element of an array?

Thanks.