Aware IM User Forums

Just being lazy and not wanting to set up a test BO I'm trying to do something special when a list of items produces any result which is a multiple of 3 (3,6,9,12 etc), so lets say the number of items returned is 4, would MOD(4,3) give me 1 or 0.333 (it doesn't really matter as long as it's not 0. M...

Thanks guys - will research these tomorrow

Things may have changed but I could never get certbot to work automatically to generate a java keystore. I have however just found a site that offers 12 month certs for $3.99/year (single domain and you have to pay for 5 years to get that price - A little under $20 https://www.ssls.com creating the ...

Since ZeroSSL got bought out and ws no longer free I've been using shieldsigned but their site is no longer reachable. I think they were a Russian outfit and we have a bit of a situation going on here in Europe!!

Does anyone know of a free or cheap certificate issuing website. (Windows server)

It turned out to be a particular process (sending a bulk email with multiple attachments) that blew Max_Allowed_Packet (mysql) and everything was getting stuck. Deleted everything when the server was quiet - like a 4:00am alarm call - and increased Max_Allowed_Packet.

All good so far.

Using MySQL - the command line mysqlbackup which is set in windows task scheduler to trigger overnight.

Am going to increase Max_allowed_packet later to see if that helps.

Just been reading some posts from 2015 on Execution context but my problem is slightly different in that my overnight backups will occasionally fail when it encounters an unusually large Execution Context Blob that has got "stuck", (should be about 1.8Gb size but stops at 205Mb). So my question is -...

So, here's the output from AIM. As you can see the actual date records are encapsulated in a container called response { "response": [ { "DurationDays": 5, "PlacesAvailable": 0, "CourseDate": "2022-09-12", "PlacesOnCourse": 6, "CourseNumber": 8, "WebSubject": "Public Course (double)"} , { "Duration...

Ttttttttttttttsssssssssssssss - Boooom. Every one a winner - every egg a bird. Thanks @jaymer Now off to conquer the world (well ok - maybe tomorrow) <WebCourses> <DurationDays/> <PlacesAvailable/> <CourseDate>Mon, Aug 1, 2022</CourseDate> <PlacesOnCourse/> <CourseNumber>5</CourseNumber> <WebSubject...

OK, so I created a Service and succesfully received the request url and sent back a list of courses that still had some availability. All Good - in fact easy peasy. Sample return below (sorry to anyone wanting to learn to glide - courses are full) { "response": [ { "DurationDays": 5, "PlacesAvailabl...

Yeah, Jaymer. I was heading that way. It's just so frustrating that the following example has been in every manual from 8.1 through 8.6 but WEEKEND_DAY just doesn't seem to exist. It would have been three lines of code. "1. CREATE Transaction FOR EACH Account 2. CREATE Transaction FOR EACH DAY/WEEK/...

BLOMASKY wrote: ↑Mon Mar 28, 2022 4:40 pm why not just create the records for all (including weekend) days then remove the weekends with:

FIND BO WHERE DATE Between firstdate and last date and (DAY_OF_WEEK(datefield) = 1 or DAY_OF_WEEK(datefield) = 7)
DELETE BO


Bruce

Just trying not to waste too many ID resources

I am trying to do a CREATE FOR EACH process where the loop is WEEKEND_DAY between two dates input by the user but the thing I need to create must include the date itself. So something like CREATE Duties FOR EACH WEEKEND_DAY between UserInput.Start_Date and UserInput.End_Date WITH Duties.StartDate=[T...

Might be totally off the wall here because I’ve never allowed any kind of guest access, but can you not make the contents panel invisible in the access level settings for guest

Presumably this is a recovery exercise to fix rather than an ongoing measure, as you'd be better to manage this via business rules or field validation at BO creation Correct - and in fact I've done just that and found lots of errors including a .co. and some with carriage returns at the end. The ac...