Retrieve date that sequence value was used?

I have an OOB system that has hundreds of tables. Each table has a ROWSTAMP column (integer) that gets populated by a trigger — each time a record is created or updated. All the tables/triggers use the same db sequence. Each time a record is updated anywhere in the db, that one sequence is used to get the next available integer. (I suppose I could consider the sequence to be a sort of global sequence).

IBM: Usage of ROWSTAMP column in Maximo tables

It’s unfortunate that those ROWSTAMP columns are integers, and not dates. What I really need in the tables are CHANGEDATE columns. Dates would be useful for data entry troubleshooting, reporting, and analysis in general. But I can’t really justify customizing hundreds of tables and adding hundreds of triggers in the OOB system. The customized tables wouldn’t be supported by IBM and it wouldn’t be worth the effort/added complexity.

I feel like those ROWSTAMP columns are so close to being useful to me. I can’t help but wonder:

Is there a way to retrieve the date that those ROWSTAMP sequence values were generated?

For example, and I doubt this is possible, could I add a DATE column to the sequence, and then join from my table to the sequence to get the date? Or could I use some sort of logging mechanism on the sequence to put rows (with dates) in a table whenever the next sequence value is used?

trying to hide a “0” value from a HTML display

enter image description hereIs there any way to hide an HTML field based on the displayed value of "0" I have an ecomm site that displays Quantity available with a numeric value. I only want to display the number if it is above "0" The values are populated from data base upload to the site. The "0" value is NOT an input field. so most codes I see have the solution with some sort of input condition code.

My site displays this: Call for Availability.0 If item has QTY above "0" it displays this: Qty On Hand: 1708 I need to remove the "0" and only display Call for Availability.

I have researched similar request on this forum and found all have answers using an input field. The problem is the "0" is not an input. It is an code generated inventory amount.

I have tried CSS to hide the value, but that hides ALL the values including above "0".

I can insert any form of code needed. Java, PHP, json, etc…

Here is a sample of actual code I have:

<div id="availabilityInfo" class="availabilityInfo">  <span class="availability-header">[product_Header-availability]</span> <span id="availability" class="product_availability availability-item">[availability]</span>  <span style="display: inline;" id="product_inventory">[stock] <span class="freeshipping availability-item"><!--[freeshipping]--></span>  </span></div> 

The [STOCK] tag is what brings in the qty value of "0"

copy fields value to another field

When user registering on my site, they have to entry their phone number for auth (firebase).I have create the phone number field using buddypress’s xprofile plugin, the field named "phone". For some reason, I need to sync the Phone field to user_url field, I tried some plugin like SyncField ,BuddyPress to WordPress Full Sync to help, but the field cannot be sync without modify the content. Any idea to make it work?

Get price field value from gravity forms to use in php code?

I’m trying to integrate Paysera (payment platform) with Gravity Forms. I have Gravity Forms with product price field, I need to retrieve the price field value to use in Paysera API code. I have paysera API code in seperate php file. So basically this is what I need:

On gravity form load -> retrieve pricing field value -> on button press redirect to /paysera.php and pass $ pricing_field_value.

Is this possible? Thanks for any ideas.

How to parse XHTML node value with TSQL?

I have the following XHTML and would like to be able to parse out My Node Value. Is there a way to easily do this with TSQL?

<SPAN style="WHITE-SPACE: normal; WORD-SPACING: 0px; TEXT-TRANSFORM: none; FLOAT: none; COLOR: rgb(0,0,0); TEXT-ALIGN: left; FONT: 10px verdana; DISPLAY: inline !important; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-text-stroke-width: 0px">My Node Value</SPAN> 

How to solve the problem with a particular “Boundary value condition”?

When I try to solve the boudary condition problem with the following code

Clear["Global`*"] u = 0.1; v = 0.1; c1 = u (1 - 3 v)/(1 - 2 v); c2 =   u (1 - v)/(1 - 2 v); c3 = u (2 v)/(1 - 2 v); A = 0.6; B = 1.; eqs = r''[R] + (c1/(c2*R) - R/(2 r[R]^2)) r'[R]^3 - 1/(2 R) r'[R] == 0; bcs = {r'[A] == -A (c2/(c1*A^2 + c3*r[B]^2))^(1/2),     r'[B] == -B (c2/(c1*B^2 + c3*r[A]^2))^(1/2)}; NDSolve[Flatten@Join[{eqs, bcs}], r, {R, A, B}] 

it appears the warnings of "Power::infy". Anyone can help explain this warning or solve this boudary condition problem?

Numerical value of Derivative of Dirichlet L function at some particular points

I want to find the numerical value for the derivative of Dirichlet L function to compare with an another formula. However I am not able to obtain any numerical values. I tried to use

f[s_]= DirichletL[5,2,s] f'[3] 

But this simply returns DirichletL^(0,0,1)[5,2,3]. If I use N[f'[3]] this gives: DirichletL:: Positive integer expected at position 1 in DirichletL[5.,2.,2.].

Can someone please help me out with this? Any help is highly appreciated.

Is the default value of FORCE_SSL_ADMIN documented?

I got stuck for a while trying to understand how comes the site I’m managing performs HTTP to HTTPS redirection since:

  • I enabled SSL connection
  • I didn’t put a .htaccessfile
  • I didn’t set the FORCE_SSL_ADMIN constant in wp-config.php

Once I figured out the redirection was performed by WordPress and not the HTTP server, I ended up triying to do a massive grep -r 'FORCE_SSL_ADMIN' ./www, and I found this on default-constant.php (WordPress 5.7.2, line 328):

function wp_ssl_constants() {     /**      * @since 2.6.0      */     if ( ! defined( 'FORCE_SSL_ADMIN' ) ) {         if ( 'https' === parse_url( get_option( 'siteurl' ), PHP_URL_SCHEME ) ) {             define( 'FORCE_SSL_ADMIN', true );         } else {             define( 'FORCE_SSL_ADMIN', false );         }     }     /* [...] */ 

If I understand correctly, if the constant isn’t set and the siteurl entry (apparently the URL site value set in Setting page of the dashboard) begins is of scheme HTTPS://, then FORCE_SSL_ADMIN is set to true.

I may have wrongly searched, but what I found led me to think siteurl has to be set in order to let the redirection works, which is not the case.

Is this default behavior (redirection according to the site URL scheme) explained somewhere in the official documentation?

Assign wordpress featured images via external URL based on numeric value in custom fields

I have several posts (150) with a custom field ‘floorplan-image-id’ which has a unique value (number) that feeds from XML. The featured image for each post should be automatically assigned via external URL based on the above custom field value.

Example: if floorplan-image-id = 12345 then the Featured image will be : //someurl.com/images/floorplan-1.png

else if floorplan-image-id = 34567 then the Featured image will be : //someurl.com/images/floorplan-2.png

====================

function custom_floorplan-image($ html, $ post_id, $ meta_field) {

$ meta_field = get_post_meta($ post->ID, ‘floorplan-image-id’, true);

if ($  meta_field === '12345') {     $  html = "<img src='"//mysite.com/images/Floorplan_A1.png"'>"; }else if ($  meta_field === '34567') {     $  html = "<img src='"//mysite.com/images/Floorplan_A2.png"'>"; }  return $  html; 

}

add_filter(‘post_thumbnail_html’, ‘custom_floorplan-image’, 10, 3);

What is best practice for referencing data rows within stored procedures – via PK, code column or data value?

Suppose you have a table for colours with columns:

  • id = automatically incrementing integer, primary key
  • code = short code reference for the colour, unique
  • colour = human-readable name of colour, unique

Example values might be:

  • 1, BL, Blue
  • 2, GR, Green

Now imagine you have a stored procedure that, at some point, needs to reference this table. Let’s say the business logic says to obtain the colour "Green". To achieve this, you could have any of the following three WHERE clauses:

  • WHERE id = 2
  • WHERE code = GR
  • WHERE colour = Green

Now, if the system is designed such that it is agreed that a code value, once created, never changes, then, in my view, that is the best column to reference because:

  • It is an alternate key
  • It is human-readable for people who maintain the code
  • It will not be impacted when the business decides to change the colour value to ‘Sea Green’

However, if a legacy table lacks such code values, what, in your opinion, is best practice? To reference the id column, or the colour column?

If you reference the id column, the code is not readable unless you then also add comments – you shouldn’t have to comment simple things like this. It sucks figuring out what statements like WHERE id not in (1, 7, 17, 24, 56) mean.

I’m not sure how often, in reality, the id value might change – but consider if you run a script during development to insert new colours but then delete those and insert some more. If your stored procedure references the id values from that last set of colours inserted but when you create your new colours in your next environment you skip the step that inserted the colours which ended up deleted, then the id values won’t match in that next environment. Bad practice, but it can happen – a developer develops their script on a dev instance not thinking that the id values will conflict with production (which, for example, may have had additional colours created manually by the business before your colour creation script runs).

If you reference the colour column, you run the risk that if the business does ask to update the description from ‘Green’ to ‘Sea Green’, that your procedure will begin to fail.

I suppose a further solution is to implement the code column when you need it, if it isn’t there already – probably the best solution?