COUNT Account WHERE (Account.State='Open')

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Sergej
Posts: 218
Joined: Tue Aug 30, 2011 2:24 pm
Location: Russian Federation

COUNT Account WHERE (Account.State='Open')

Post by Sergej »

Hi

I had a lot of rules like
COUNT Account WHERE (Account.State='Open')
in ver. 5.1 and they worked

As I understand in 6 it doesnt work now.
So how to achieve this result?
AwareIM 5.1a build 1454, Debian 64bit , MySQL
BenHayat
Posts: 2749
Joined: Thu Dec 23, 2010 5:48 am
Location: Fla, USA
Contact:

Re: COUNT Account WHERE (Account.State='Open')

Post by BenHayat »

Sergej wrote:Hi

I had a lot of rules like
COUNT Account WHERE (Account.State='Open')
in ver. 5.1 and they worked

As I understand in 6 it doesnt work now.
So how to achieve this result?
I have used COUNT and WHERE clause in V6 and works.

Code: Select all

COUNT TrainingSession WHERE (TrainingSession IN TrainingCourse.TrainingSessions AND TrainingSession.SessionCompleted='Yes') 
customaware
Posts: 2418
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: COUNT Account WHERE (Account.State='Open')

Post by customaware »

Just a curious question Sergej.

It sounds like you are converting an app from V5 to V6.
Why don't you just convert directly to V7?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
BenHayat
Posts: 2749
Joined: Thu Dec 23, 2010 5:48 am
Location: Fla, USA
Contact:

Re: COUNT Account WHERE (Account.State='Open')

Post by BenHayat »

eagles9999 wrote:Just a curious question Sergej.

It sounds like you are converting an app from V5 to V6.
Why don't you just convert directly to V7?
Excellent point!
Powerm
Posts: 476
Joined: Mon Feb 01, 2010 9:44 pm

Re: COUNT Account WHERE (Account.State='Open')

Post by Powerm »

"It sounds like you are converting an app from V5 to V6.
Why don't you just convert directly to V7?"

Maybe because V7 it's still beta and they would be a licence upgrade fee from V5/V6 to V7 ? :idea:
Independent Developer
customaware
Posts: 2418
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: COUNT Account WHERE (Account.State='Open')

Post by customaware »

Am I missing something?

Annual Maintenance fee provides upgrade to V7
I thought.

Also, V7 beta is definitely complete enough to start and
upgrade. Will save you converting twice.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
BLOMASKY
Posts: 1480
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: COUNT Account WHERE (Account.State='Open')

Post by BLOMASKY »

Why not be a real leader and convert your app to V8. I am sure it must be in pre-pre-alpha somewhere? (but maybe only in Vlad's head.)

Talking about Vlad's head. It would be nice to have some sort of roadmap where V7.1 and 7.2 and 7.999 will be headed. What additional features are around the corner. That is, after Vlad (and the rest of the team) have released V7 and squashed any of the remaining pesky bugs.

Bruce
Post Reply