Aware IM User Forums

numberz wrote: ↑Fri Feb 10, 2023 11:54 pm
Thanks Pointswell... but how do I pull from Contractor?

For which bit?

Negated participation in a list is a known issue. The solution is FIND Contractor WHERE COUNT Contractor WHERE( Contractor IN Job.pm_Contractor ) = 0 So, imagine that I have a BO called Job. I also have a BO called Contractor. In Job I created a ps_Contractors. Suppose I add 3 of the 10 Contractors...

karelh wrote: ↑Thu Feb 09, 2023 6:56 am HI support,

Do you still need a sample BSV or should we just wait for version 3125?

https://www.awareim.com/dokuwiki/doku.p ... g/8.8/3125

If you have a query that interrogates BOG and the Member BOs of those BOGs have shortcuts and relationships and then you run the SQL log you'll see the query individually load all of those relationships. When you do your load testing, you'll find that all of those BOs then create a MASSIVE overhead ...

I know you want to keep the SQL all in your Aware app, but let me suggest that is a mistake. 1st, you mention that if fields change your SQL might break, but if fields change your aware program will compile fine but break when the user trys to run the SP. Yeah, I've been down the route of breaking ...

Background I have a Query which runs on a BOG. Each of the BOs in the BOG have shortcuts on them. This makes the query run like a dog. The reason for this is that AIM brings every item into context and checks every path for every shortcut. Solution Create an SQL view to generate only the data that ...

Jaymer wrote: ↑Sat Feb 04, 2023 2:09 amWhy?

To get the features you mentioned as being missing on Linux.

Jaymer wrote: ↑Fri Feb 03, 2023 7:25 pm
I’ve used Unix for Years and years, but the server and tomcat windows were not available to view in the control panel under UNIX, like they are on windows.

Run a UI on top of Linux.

While I have not tried this. I would assume the install folder would be different for each aware server (one points to Aware and AwareTest, other points to Aware2 and Aware2Test) and, assuming that the BSV that they share have an external database (data and datatest) there should be no problems wit...

ok, to fix that, they are technically NOT 100% clones. Each server has to point to a diff. "install" database on the server - each would have its own License. But yes, BSV's would be the same. There's a section in the help about load balancing but it doesn't give much detail. Maybe there is a speci...

As the server pulls the Config from the db both servers would be running the same version of the BSV.

The server also stores its licence data in the db though. Not sure how the sever licensing would work.

No problem. Have a think about what the conditions are for the query on the left and the query on the right. Your initial post said: The Left Query shows all the items of a certain TimeSlot_ID and the right Query shows a header record (no grouping or anything fancy), which there is one record for ea...

From here A record can be dragged from one grid represented by a standard query to another grid represented by some other standard query. Note that this will only work if both queries query on the same business object. I have no knowledge of your model but I am assuming that you have two objects Fr...

You haven't brought a second Freight BO into context, which you won't be able to do if the two Freight BOs are in different queries. Drag and drop re-ordering only works within the same query.

Until there are two instances of Freight BO you won't be able to make assignments.

Just as an aside, there are better alternatives to drag drop, if you've got two grids visible. Running a process on clicking on the line items requires less dexterity and will be faster. Grid One - Deliveries available for reschedule Grid two - Delivery slots that are open. Place grid one on the lef...