sharepoint enterprise – Ability to query the content types of a document library

We noticed a problem in our SharePoint 2013 document libraries. When uploading documents to a set of documents in a document library, the available content types in the root document library are available in the document set , even if this same type of content is not available for the entire set of documents. This is particularly difficult because users do not see their documents in document sets because they have been incorrectly labeled as an incorrect type of content, as is the case when users place / drop items in sets. of documents.

I would try to edit the new pop-up document to eliminate these invalid content types. Is there a way to query the properties of the document set to search for valid content types?

Tks

SQL Show query result with existing values ​​and NULL values ​​if they do not exist

Good night to ask for your support when adapting a query in SQL in which I use the declaration "union" to join 2 queries in SQL but I need the result to display the 2 records, even if the one does not have the desired value.

the request I use:

SELECT pts_idparte, pts_desparte, pts_pcolista, ALM_EXISTEN
since par_almacen internal join par_parts on ALM_IDPARTE = PTS_IDPARTE and ALM_IDPARTE = & # 39; 4261102M50 & # 39; and ALM_IDALMA = & # 39; GEN & # 39;
union
SELECT pts_idparte, pts_desparte, pts_pcolista, ALM_EXISTEN
from par_almacen inner join par_partes on ALM_IDPARTE = PTS_IDPARTE and ALM_IDPARTE = & # 39; 4261102X & # 39; and ALM_IDALMA = & # 39; GEN & # 39;

The first selection shows a record where exists ALM_IDPARTE
however, in the selected selection, the result of the query does not display as the first record and it is necessary to specify the second as NULL if it does not exist.

current result:
pts_idparte pts_desparte pts_pcolista ALM_EXISTEN
4261102M50 DISC WHEEL 6608.05000 0.0000000

expected result:

pts_idparte pts_desparte pts_pcolista ALM_EXISTEN

4261102M50 DISC WHEEL 6608.05000 0.0000000

pts_idparte pts_desparte pts_pcolista ALM_EXISTEN

NULL NULL NULL NULL

Thank you very much for your support.

greetings

wp query – Upsell product category – Exclude categories

Greatings,

I've achieved what I had to do: replace the Upsell products by category instead of taking the time to add upward sales. I just passed the auto category. But I reached the end of the road. I need to exclude categories to show upstream sales now. But I do not know how to do that.

I will try to clarify everything.

that's the code I'm using in theme functions.php

add_filter (& # 39; woocommerce_product_get_upsell_ids & # 39 ;, & quot; custom_upsell_ids & # 39 ;, 20,2);

function custom_upsell_ids ($ upsell_ids, $ product) {
// HERE define your product categories slug in the table
$ product_categories = array (& # 39; priedai-prie-geliu & # 39;); // <===== <===== <===== <===== <=====

// return the custom query
return wc_get_products (array (
& # 39; status & # 39; => & Nbsp; publish, published products
& # 39; limit & # 39; => 20, // 4 products
& # 39; category & # 39; => $ product_categories, // product categories
& # 39; orderby & # 39; => Rand, // Random order
& # 39; Exclude & # 39; => array ($ product-> get_id ()), // Exclude the current product
& # 39; return & # 39; => & # 39; ids, // Query only returns identifiers

));

}

This code allows me to shop in a specific category. But I have categories where I do not want to show upstream sales – how can I achieve that ???

database – Fix slow query wp_term_relationships in get_posts

I've used the Query Monitor plugin to search for a slow query on my WordPress site. The mentioned below WP_Query-> get_posts () takes about 0.3446 query time on the total database query time of 0.3976.

SELECT wp_posts.ID
DE wp_posts
JOIN LEFT wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
O 1 = 1
AND wp_posts.ID NOT IN (203598)
AND (wp_term_relationships.term_taxonomy_id IN (17)
OR wp_term_relationships.term_taxonomy_id IN (11652,20693,21952,23971,24907,24908,25928))
AND wp_posts.post_type = & post;
AND ((wp_posts.post_status = publish & # 39;))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 6

I guess it has something to do with the 20,000 or more tags used in the posts on my site. Is it true? If so, how do you suggest solving this slow query? Or how do I remove tags that are not used in more than 5 posts from all posts on the site?

Please help.

Query list optimized by Xon | NulledTeam UnderGround

This addon is meant for a great forum with tens of thousands to hundreds of thousands or more threads in a single forum.Small forums do not take much advantage of this add-on.

List of members online:

This add-on introduces a faster list of "online members" designed to accommodate thousands of online users. However, this will not show users who are not staff or who are not tracked in the list.

This loss of functionality can be undesirable and can therefore be configured in the performance options …

Is there a way to transfer the results of an adb query to a file?

Try the following:

The ./adb shell settings get a secure Bluetooth address> results.txt; ./adb get-serialno >> results.txt; ./adb push results.txt / path / to / save / file

Explanation: The results of the first 2 commands are saved in a file on your PC, then the file is transferred to your device.

SQL Server – How to improve a simple update statement that causes blocking issues, unnecessary index analysis in the query plan

Please, consider me – I'm on the development side but I was tasked with finding the cause of several blocking issues after upgrading from SQL Server 2008 to 2016. Blocking is intermittent everything goes well for a few weeks, then maybe once. or twice a month, the application becomes unusable. Here is one of the recurrent queries incriminated when this happens:

UPDATE campaign_log
SET date_modified = No 2019-06-18 14:28:19 & # 39;
, mail_disposition_status = & # 39; 1 & # 39;
, status_date = N / 06 / 17/2019 & # 39;
, activity_date = N / 05 / 22/2019 & # 39;
O id = N 03938240-0112-437C-AF97-ECCF2EF78E77 & # 39;

It seems that this https://www.brentozar.com/pastetheplan/?id=H1YyzoqJS query plan tells me that the index scan [SUGARCRM].[dbo].[campaign_log].[idx_mail_disposition_status] is really inefficient.

I do not know why the column Mail_disposition_status is indexed or why this index is chosen to execute this query. Looks like he should maybe use an index on id? There are 2,622,020 rows in the campaign_log table.

Can any one indicate in the right direction what I should look for to solve this problem? Honestly, I'm pretty lost on what I'm looking for.

Query in Accounting – UK LTD Business

Hi guys, I decided to formalize my small accommodation and I ran into a vinegar. Before hiring an accountant, maybe a staff member can give you useful tips:

  • I have a limited liability company in the UK, with a sterling bank account. All I pay is from this account, in GBP.
  • I bought my accommodation from a Dutch company that bills me in EUR.
  • I use WHMCS to bill my clients, who pay me in EUR. I've bought Edge-Hosting Addon to sync with Xero.
  • I use Stripe for processing payments, those who accept payments in EUR, convert to GBP and pay my account in GBP (processing fee in GBP).
  • I buy my domains from OpenProvider, which bills me in EUR.
  • I use Xero for accounting as it supports my bank flows and several currencies.
  • I am registered and already late on my VAT VAT returns …

I'm trying to reconcile all this multi-currency mess, but I have problems: Edge-Hosting has paid off its WHMCS plugin as there is no apparent way to reconcile the generated euro bills by WHMCS with the GBP transactions I receive from Stripe.

Is there a way around the madness I created? A tip for other hosts who work in multiple currencies?

Thank you!

plugins – Is it possible to define a custom query for a WordPress REST API response?

I have a custom message type that I search through the WordPress REST API, at the present time the response returns all messages. I would like to put the tax_query argument based on the user sending the request. Is it possible? Or do I have to create a specific endpoint for this?

I thought something like pre_get_posts filter, but I do not know how to do that for the REST API.

url – What does the query parameter "sub_confirmation = 1" do on a YouTube link?

What this does is to automatically subscribe the link follower to the YouTube channel that posted the video.

This is not completely silent, a confirmation dialog box appears:

enter the description of the image here

so that the user can choose what to do.

This is not a very good thing to do though.

Source