Search found 1460 matches

by PointsWell
Tue Sep 18, 2018 10:21 pm
Forum: General discussion and questions about Aware IM
Topic: Custom dashboard static html inject BO object data
Replies: 5
Views: 8111

Re: Custom dashboard static html inject BO object data

Amit, a tip is to think about where/if you really need to use functions like count as these can be resource expensive (and if you have it on dashboards etc. etc., they are executed each time the dashboard is displayed). I often use plain tags for things like this (i.e just tag attribute value and t...
by PointsWell
Tue Sep 11, 2018 11:04 pm
Forum: General discussion and questions about Aware IM
Topic: How to find a BO and put it in context
Replies: 8
Views: 11234

Re: How to find a BO and put it in context

eagles9999 wrote:I have found that Display Under is very convenient for locating Sub Processes "Under" Parent Processes.
It helps a lot.
When using the Configurator that does work - the benefit of using naming and numbering is that when you are looking through logs you can tell where in the process you are.
by PointsWell
Tue Sep 11, 2018 11:03 pm
Forum: General discussion and questions about Aware IM
Topic: [Solved-ish] Deletion of Owned By BO Errors
Replies: 3
Views: 4507

[solution] Intermediary VP to hide processing

I have the same thing happening on some of my delete processes, Its annoying - users now ignore the message and know its a result of a Delete. I gave up trying to find a solution Could it have something to do with the Form refresh settings? So... I think I may have found a (really crappy) way to ge...
by PointsWell
Tue Sep 11, 2018 11:11 am
Forum: General discussion and questions about Aware IM
Topic: How to find a BO and put it in context
Replies: 8
Views: 11234

Re: How to find a BO and put it in context

Agree it can become a bit harder to follow.

I use numbering to keep my processes and sub-processes together.

ProcessName_000
ProcessName_010 (subprocess of 000)
ProcessName_100 the next step after 000

If it’s a really involved process I use four digits
by PointsWell
Tue Sep 11, 2018 10:53 am
Forum: General discussion and questions about Aware IM
Topic: How to find a BO and put it in context
Replies: 8
Views: 11234

Re: How to find a BO and put it in context

If your find will produce more than one record then you need to use a sub process to carry out whatever actions you want to do. Create a process use aBO as an input. It will then process one record at a time. That will create a loop while you have unprocessed records. So FIND aBO where [condition] T...
by PointsWell
Tue Sep 11, 2018 10:01 am
Forum: General discussion and questions about Aware IM
Topic: How to find a BO and put it in context
Replies: 8
Views: 11234

Re: How to find a BO and put it in context

IF EXISTS just tests for existence.

To bring into context use

FIND BO WHERE BO.Attribute = AttributeValue

You can combine:

IF EXISTS BO WHERE BO.Attribute=Value THEN
FIND BO WHERE...

Alternatively

FIND BO WHERE ...
Then immediately in next rule
IF SEARCH_COUNT>0 THEN
Do stuff
by PointsWell
Tue Sep 11, 2018 6:23 am
Forum: General discussion and questions about Aware IM
Topic: Is this image from User Guide pg 187 from a Sample App?
Replies: 2
Views: 3866

Re: Is this image from User Guide pg 187 from a Sample App?

It appears to have been a previous sample app. The sample data is in

../awareim/samples/Ordering/

There is a PDF to go with it but there is no BSV.
by PointsWell
Tue Sep 11, 2018 1:37 am
Forum: General discussion and questions about Aware IM
Topic: [Solved-ish] Deletion of Owned By BO Errors
Replies: 3
Views: 4507

Re: Deletion of Owned By BO

So I thought I would be clever on finding that Parent.os_Child=UNDEFINED is different from Child.ob_Parent=UNDEFINED The first is the same as a delete, the second creates an orphaned record. So I set about to deliberately orphan the Child and then set a rule if parent set to undefined then delete. S...
by PointsWell
Tue Sep 11, 2018 12:32 am
Forum: General discussion and questions about Aware IM
Topic: As If We Didn't Already Know This..... ;-)
Replies: 5
Views: 7896

Re: As If We Didn't Already Know This..... ;-)

Simply put, the man in charge, would go with the least expensive one, since the less he paid, the bigger his bonus was, and didn't care what the real solution was. So, the PHP guys, decided to re-do the UI with the new fancy JS libraries out there and keep the backend the same. Aware had no chance ...
by PointsWell
Tue Sep 11, 2018 12:29 am
Forum: General discussion and questions about Aware IM
Topic: [Solved-ish] Deletion of Owned By BO Errors
Replies: 3
Views: 4507

[Solved-ish] Deletion of Owned By BO Errors

I am going round the twist with this one. I have a series of BO that are generated to create a complex record. I generate a Header record to then attach a series of OB and PS/PM BOs to. The creation process is done in a special VP that essentially shows the forms and the progress of the creation pro...
by PointsWell
Mon Sep 10, 2018 4:28 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] Complex Filter Using a m-n Table
Replies: 11
Views: 15303

Re: [SOLVED] Complex Filter Using a m-n Table

This is my working (at the moment) solution

Code: Select all

FIND Support WHERE NOT(EXISTS Relationships WHERE (Client IN Relationships.ob_Client AND Support=Relationships.ps_TeamMember))
So not as complicated as I seemed to be making it for myself over the weekend.
by PointsWell
Mon Sep 10, 2018 4:27 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] Complex Filter Using a m-n Table
Replies: 11
Views: 15303

Re: [SOLVED] Complex Filter Using a m-n Table

tford wrote:Not your scenario, but does this help at all?

https://www.awareim.com/forum/viewtopic.php?f=4&t=5274
Thanks Tom - as I was saying to Mark - this was what I was trying to remember / work out over the weekend!
by PointsWell
Mon Sep 10, 2018 4:25 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] Complex Filter Using a m-n Table
Replies: 11
Views: 15303

Re: [SOLVED] Complex Filter Using a m-n Table

I am not 100% sure this is what you are after but I suspect it is... You can see the filter queries on the Client and Support Form of Relationship. Let me know if that helps ComplexFilter.zip This was what I was trying to do all weekend but the fug was upon me. Mario's suggestion got me out of the ...
by PointsWell
Mon Sep 10, 2018 1:24 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] Complex Filter Using a m-n Table
Replies: 11
Views: 15303

Re: Complex Filter Using a m-n Table

Maybe try using EXISTS in the query: FIND Support WHERE NOT(EXISTS Relationship WHERE (Client IN Relationship.Clients AND EXISTS Support WHERE (Support IN Relationship.TeamMember))) Thanks Mario - it's not the correct answer but it has unblocked my mind. Totally forgot about EXISTS. If I go to firs...
by PointsWell
Sun Sep 09, 2018 6:41 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] Complex Filter Using a m-n Table
Replies: 11
Views: 15303

Re: Complex Filter Using a m-n Table

Sorry I didn’t explain clearly enough I want to filter Support not in Relationships. So on my Clients BO the pm_Support when I create a new Client Support Relationship I want to exclude anyone already on the Relationship table. Ie Find Support where Support not in Relationship where Client equals th...