SharePoint Calculated field Failed to update value on all items on Large List

So this is the problem:

I have a list with around 1 million records

I added a Calculated Column, with a very simple formula:

"0" + [textfield] 

and return it as number

The request returned an update conflict error but when I browsed at the list I could see that the items were getting updated from the oldest to the newest over time with the new calculated field value. but some time later it stopped leaving more than half of the items without getting their value calculated returning them as -4XXXXXXX (I think this means is a null number)

I checked the logs and found out that for 3 hours every 20 seconds the ULS kept logging the following error:

A large block of literal text was sent to sql. This can result in blocking in sql and excessive memory use on the front end. Verify that no binary parameters are being passed as literals, and consider breaking up batches into smaller components. If this request is for a SharePoint list or list item, you may be able to resolve this by reducing the number of fields.

And then Finally a request timeout error log having the same Correlation ID as the previous error

Is there a safe way to add that calculated field?

do I need to increase a timeout variable to give the calculated field enough time to calculate all the items?

how can I recalculate the remaining fields without affecting the modified by and modified date of the items ?

Thank you!

Update Yes/No field if Date is today

I am trying to create an automated SLA field

I have a “Date Requested” Field and an “Outside of SLA” field.

Date Requested is formatted as a Date, Outside of SLA is formatted as a Yes/NO / True/False field.

I am trying to automatically update the “Outside of SLA” field if the “Date Requested” is later than “Today”

I understand it will have something to do with the IsToday() field but im not sure if the logic i am trying to apply will work within PowerApps/Sharepoint.

Is this at all possible? I feel like i am treating this too much like Excel but am pretty new to this. Apologies

Thanks for any advice

Field Modified shows date, but no time

In a view of a document library I have the field “Modified” and this is showing only dates but no time. I would like to display the time aswell.

From my understanding it is ill advised to alter this field OOTB, but rather to create a calculated field and format it the way I want.

I have checked the column properties for this Modified-field, and it is set to “Date and time”, which is why I find it curious that it only displays the date. In any case I have created another (calculated) field which I am attempting to format the way I want, but with not luck.

Under the Formula section of this new calculated field I am attempting to format “Modified” like this:

=TEXT([Modified],"dd.MM.yyyy hh:mm") 

I want the result to appear like this 14.10.2014 15:59. However, when trying to save the above formula I get the “Sorry, something went wrong” page and the mention that the syntax is probably wrong. I am unable to see any obvious errors with the syntax and have tried a multitude of approaches – like removing the “”, removing [] from modified and so forth.

I need the field to display time aswell and I am not sure if this is the best approach either. Anyone got any tips to how I could do this? Perhaps the calculated field approach isn’t the best either?

How can I get the Description textarea field to use the Visual Editor for Attachment Posts

I saw this post involving tags. But I can’t figure out which

/**  * Display advanced TinyMCE editor in taxonomy page  */ function wpse_7156_enqueue_category() { global $  pagenow, $  current_screen;  if( $  pagenow == 'edit-tags.php' ) {     require_once(ABSPATH . 'wp-admin/includes/post.php');     require_once(ABSPATH . 'wp-admin/includes/template.php');      wp_tiny_mce( false, array( 'editor_selector' => 'description', 'elements' => 'description', 'mode' => 'exact' ));    }  }  add_action( 'init', 'wpse_7156_enqueue_category' ); 

This seems to have been rendered redundant in newer versions of WordPress. But I wonder if it could be used for attachments? I just need to know the include for that attachment editing page?

How to add custom checkout field in user details mail template

I need to add custom field from my checkout page to email templates. I already added custom input at checkout page and it shows up in mails but it shows up after products table and I would like it to show up in customer details. I can’t find right hook to place it there. Code for my custom field:

// Hook in add_filter('woocommerce_checkout_fields', 'custom_override_checkout_fields');  // Our hooked in function - $  fields is passed via the filter! function custom_override_checkout_fields($  fields) {    //New input   $  fields['billing']['OIB'] = array(     'label'     => __('OIB', 'woocommerce'),     'placeholder'   => _x('OIB', 'placeholder', 'woocommerce'),     'required'  => true,     'class'     => array('form-row-wide'),     'clear'     => true   );    return $  fields; }  /**  * Update the order meta with field value  */ add_action('woocommerce_checkout_update_order_meta', 'my_custom_checkout_field_update_order_meta');  function my_custom_checkout_field_update_order_meta($  order_id) {   if (!empty($  _POST['OIB'])) {     update_post_meta($  order_id, 'OIB', sanitize_text_field($  _POST['OIB']));   } }   /**  * Display field value on the order edit page  */ add_action('woocommerce_admin_order_data_after_billing_address', 'my_custom_checkout_field_display_admin_order_meta', 10, 1);  function my_custom_checkout_field_display_admin_order_meta($  order) {   echo '<p><strong>' . __('OIB') . ':</strong> ' . get_post_meta($  order->id, 'OIB', true) . '</p>'; }   /* To use:  1. Add this snippet to your theme's functions.php file 2. Change the meta key names in the snippet 3. Create a custom field in the order post - e.g. key = "OIB" value = 134852145798 4. When next updating the status, or during any other event which emails the user, they will see this field in their email */ add_filter('woocommerce_email_order_meta_keys', 'my_custom_order_meta_keys');  function my_custom_order_meta_keys($  keys) {   $  keys[] = 'OIB'; // This will look for a custom field called 'OIB' and add it to emails   return $  keys; }  //Micanje Checkout polja add_filter('woocommerce_billing_fields', 'bbloomer_move_checkout_email_field', 10, 1);  function bbloomer_move_checkout_email_field($  address_fields) {   $  address_fields['billing_email']['priority'] = 25;   $  address_fields['OIB']['priority'] = 26;   $  address_fields['billing_phone']['priority'] = 27;   $  address_fields['billing_country']['priority'] = 28;   return $  address_fields; }  // Custom validacija za OIB add_action('woocommerce_checkout_process', 'custom_validate_OIB'); function custom_validate_OIB() {   $  is_correct = preg_match('/^[0-9]{11}$  /', $  _POST['OIB']);   if ($  _POST['OIB'] && !$  is_correct) {     wc_add_notice(__('OIB se sastoji od <strong>11 brojki</strong>.'), 'error');   } } 

I use NP Quote Request plugin which has it’s own email templates. I think that one of these hooks at the bottom of email template php file controls customer details.

do_action('woocommerce_email_after_order_table', $  order, $  sent_to_admin, $  plain_text);  do_action('woocommerce_email_order_meta', $  order, $  sent_to_admin, $  plain_text);  do_action('woocommerce_email_confirmation_messages', $  order, $  sent_to_admin, $  plain_text);  do_action('woocommerce_email_customer_details', $  order, $  sent_to_admin, $  plain_text, $  email);   try {     do_action('woocommerce_email_footer'); } catch (Exception $  ex) { } 

Any help on which hook I should target or what I should do would be great. Thanks.

Filtrar field en el administrador Django

Hola estoy trabajando con el framewor Django y se me presenta la siguiente situación.

Quisiera poder filtrar las opciones que se despliegan en el field factura del administrador de AbonoFactura, solo con las facturas marcadas con credito=True. Ya que por defecto Django me despliega todos los objetos relacionados.

Modelo AbonoFactura

class AbonoFactura(Auditoria):     factura = models.ForeignKey(Factura, null=False, blank=False, verbose_name=_('factura'), on_delete=models.PROTECT,                                 related_name='abono_factura_factura')     fecha_abono = models.DateTimeField(null=False, blank=False, verbose_name=_('fecha del abono'))     valor_abono = models.IntegerField(null=True, blank=True, verbose_name=_('valor del abono')) 

Modelo Factura

class Factura(Auditoria):     fecha_compra = models.DateTimeField(null=False, blank=False, verbose_name=_('fecha de compra'))     cliente = models.ForeignKey(Cliente, null=False, blank=False, verbose_name=_('cliente'), on_delete=models.PROTECT)     contado = models.BooleanField(default=False, verbose_name=_('contado'))     credito = models.BooleanField(default=False, verbose_name=_('credito'))     fecha_pago = models.DateField(null=True, blank=True, verbose_name=_('fecha de pago'),                                   help_text=_('Uselo solo si selecciono crédito como método de pago.')) 

Agradezco la ayuda que me puedan brindar.

Does Antimagic Field suppress all layers of True Polymorph simultaneously?

Imagine that you have cast True Polymorph to turn a medium object into a Helmed Horror with Spell Immunity to Antimagic Field. If you were to then True Polymorph that Helmed Horror into something else, it would lose its Spell Immunity, as its entire statblock is changed. However, what exactly would happen if the newly True Polymorphed creature walked into an Antimagic Field?

I see two plausible outcomes:

  1. Both layers of True Polymorph are suppressed simultaneously and the creature is immediately turned back into a medium object.
  2. The most recent layer of True Polymorph is suppressed, at which point the Helmed Horror’s Spell Immunity kicks in and prevents the next layer from being suppressed.

I think each of these interpretations has a decent argument:

  1. This is how Dispel Magic works. If the Helmed Horror also had Spell Immunity to Dispel Magic, the underlying layer of True Polymorph could still be dispelled, because Dispel Magic reads (emphasis mine):

For each spell of 4th level or higher on the target, make an ability check using your spellcasting ability. The DC equals 10 + the spell’s level. On a successful check, the spell ends.

Both layers of True Polymorph are on the target, and so both can be dispelled, and there is no reason to suspect they aren’t dispelled simultaneously (before the Spell Immunity could ever kick in).

  1. Antimagic Field reads (emphasis mine):

Any active spell or other magical effect on a creature or an object in the sphere is suppressed while the creature or object is in it.

And while there are two layers of True Polymorph on the creature, it seems reasonable to assume that only the most recent is “active”, due to the rules for Combining Magical Effects:

The effects of the same spell cast multiple times don’t combine, however. Instead, the most potent effect–such as the highest bonus–from those castings applies while their durations overlap, or the most recent effect applies if the castings are equally potent and their durations overlap.

This (plausibly, I think) could be interpreted to mean that the most recent layer of True Polymorph is suppressed first, at which point Antimagic Field would suppress the next layer if not for the Spell Immunity.

Is one of these two interpretations unambiguously supported by Rules as Written?

Content query webpart using a calculated page field value in a filter failing

I’m having trouble getting a calculated page field (DocIdDelimited) to work as a filter value in a content query webpart. DocIdDelimited should resolve to text. I’m querying if the calculated field text is contained in another text field(RelatedDocId).

I’ve seen people use calculated filter values with dates, so why is this calculated field with text not working?

If I create the filter with a text page field with the same content, the filter works.

enter image description here