Search found 1476 matches

by PointsWell
Fri Nov 15, 2024 12:36 am
Forum: General discussion and questions about Aware IM
Topic: Document vs Picture
Replies: 4
Views: 1596

Re: Document vs Picture

But if I'm not going to use that, is there any reason to not just have a Document field and store EVERYTHING in there? All images are documents but not all documents are images. Does specifying Picture limit what can be stored more easily than the Document attribute? Haven't used so don't know the ...
by PointsWell
Tue Nov 12, 2024 4:24 am
Forum: Tips and Tricks
Topic: Scheduler available start/end dates
Replies: 3
Views: 2413

Re: Scheduler available start/end dates

Cool, can that be modified to use a BO attribute so you can vary the date easily?
by PointsWell
Mon Oct 28, 2024 10:57 pm
Forum: General discussion and questions about Aware IM
Topic: FINDing BO in Reference of Same Object
Replies: 3
Views: 1960

Re: FINDing BO in Reference of Same Object

To add to Jaymer’s comment, AIM is already creating the third intermediate table so you might as well go the extra mile and make the additional table functionally available. Your queries become a lot simpler too.
by PointsWell
Mon Oct 07, 2024 11:11 pm
Forum: General discussion and questions about Aware IM
Topic: Process to change YES/NO attribute
Replies: 5
Views: 5557

Re: Process to change YES/NO attribute

One thing to be mindful of when using Y/N fields is that ere are technically three options for the field: Y, N & NULL When writing processes involving Y/N I use a positive and an inverse state check on the state that is relevant, so if I want the process to run when the attribute is No, then I check...
by PointsWell
Thu Sep 19, 2024 4:04 am
Forum: Tips and Tricks
Topic: What not to do - Case Sensitive Business Spaces
Replies: 7
Views: 10887

Re: What not to do - Case Sensitive Business Spaces

Have you changed versions of MySQL? Version 8 is case sensitive whereas prior version were not.
by PointsWell
Tue Jul 30, 2024 12:10 am
Forum: Tips and Tricks
Topic: Calendar Recurrence Rules
Replies: 0
Views: 9995

Calendar Recurrence Rules

If you are using Appointment BOs via a procedure and need to generate recurring appointments then you need to be able to set the RecRule attribute and it isn't always straightforward.

Here is a RecRule generator to define what the rule should be https://icalendar.org/rrule-tool.html
by PointsWell
Tue Jul 23, 2024 7:58 am
Forum: General discussion and questions about Aware IM
Topic: Callback function in Aware IM?
Replies: 24
Views: 45630

Re: Callback function in Aware IM?

I have had a similar problem before where rules need to be controlled in their execution and I used an attribute with a number. IF BO.Check was changed to 10 then xyz BO.Check=20 IF BO.Check was changed to 20 then abc BO.Check=30 Then your process can be called or stopped if BO.Check doesn't get to ...
by PointsWell
Wed Jul 03, 2024 10:32 pm
Forum: General discussion and questions about Aware IM
Topic: [Implemented] QueryLayout Object
Replies: 7
Views: 46472

Re: [Implemented] QueryLayout Object

Implemented as DISPLAY BO WHERE X,Y,Z USING QueryName What exactly is implemented? I can't remember the initial FR and now when reading it through, I don't fully understand what is implemented and how it works. Is this new functionality documented and possibly with an example somewhere? DISPLAY whe...
by PointsWell
Wed Jul 03, 2024 11:54 am
Forum: General discussion and questions about Aware IM
Topic: [Implemented] QueryLayout Object
Replies: 7
Views: 46472

Re: [Implemented] QueryLayout Object

Implemented as DISPLAY BO WHERE X,Y,Z USING QueryName
by PointsWell
Wed Jul 03, 2024 3:06 am
Forum: General discussion and questions about Aware IM
Topic: Data Export Problem
Replies: 10
Views: 26568

Re: Data Export Problem

No technical solutions but the Jakarta-poi Jar is 1.5.1 and was shipped in 2002.

In all likelihood there are probably a number of improvements between then and now that could be leveraged.
by PointsWell
Wed Jun 26, 2024 2:03 am
Forum: Wish List
Topic: CROSS JOIN
Replies: 0
Views: 10576

CROSS JOIN

The ability to take n BO and cross join these to one table without manually finding each and creating individual rows. I have multiple instances where the user creates 3 business objects which may have between 1 and n instances and then needs to be able to interrogate the combination at a later date...
by PointsWell
Mon Jun 03, 2024 1:52 am
Forum: General discussion and questions about Aware IM
Topic: Variable TAKE BEST
Replies: 9
Views: 22264

Re: Variable TAKE BEST

Looks like a TAKE BEST does not put 3 records in context, but puts all records in context?? TAKE BEST isn’t working because your first process This is my example process: FIND ALL AnObject //this BO contains 6 records AnObject.TryNr=0 //set everything to zero Has brought every AnObject into context...
by PointsWell
Wed May 15, 2024 9:17 am
Forum: Problem reports
Topic: HTML textbox for merge templates > in tags
Replies: 5
Views: 14668

Re: HTML textbox for merge templates > in tags

What happens if you change the EmailTemplate.Message to just be plain text. If the OutgoingEmail.Message is HTML should it not just pickup the formatted text?