Search found 4210 matches

by tford
Fri Apr 08, 2022 3:41 pm
Forum: General discussion and questions about Aware IM
Topic: Threaded conversation / ticketing system
Replies: 0
Views: 861

Threaded conversation / ticketing system

Has anyone built an application with threaded conversations?

For example a ticketing system where once you have a ticket, you can easily see all the convo that has happened on the tickets with time & date stamps.

Thanks!
by tford
Mon Apr 04, 2022 12:48 pm
Forum: General discussion and questions about Aware IM
Topic: Updating BSV on remote server - issue with views
Replies: 3
Views: 927

Re: Updating BSV on remote server - issue with views

I have a similar question. I've been considering using Aware IM in some scenarios in my new gig. Aware would be connecting to an "Existing External" Postgres DB. We have both a staging (or test) server and a production server. I'm trying to envision how we would easily transition a BSV from accessin...
by tford
Wed Mar 23, 2022 9:26 pm
Forum: Tips and Tricks
Topic: COUNT UNIQUE VALUES
Replies: 14
Views: 46966

Re: COUNT UNIQUE VALUES

Thank you!
by tford
Tue Mar 08, 2022 3:37 am
Forum: General discussion and questions about Aware IM
Topic: Poor calendar in Aware. Why?
Replies: 17
Views: 4714

Re: Poor calendar in Aware. Why?

Code: Select all

If you are running 8.7 there is a way to prevent protection rules from being evaluated when running a query.
Is that by a setting in the query?
by tford
Mon Mar 07, 2022 2:57 am
Forum: General discussion and questions about Aware IM
Topic: Experience with heavy data processing nightly?
Replies: 4
Views: 3431

Re: Experience with heavy data processing nightly?

Always a good idea to follow Pete's advice. He taught me SO much early on during my Aware journey. In addition to his log suggestion, I've also fired off an email to system admin (myself) at the end of regularly scheduled update processing. I include key totals & time/date stamps (beginning and endi...
by tford
Sat Feb 19, 2022 1:24 am
Forum: General discussion and questions about Aware IM
Topic: Accessing MS Access Tables
Replies: 3
Views: 2095

Re: Accessing MS Access Tables

Yes, via ODBC as Roger mentioned. Back when I started using Aware in 2007, our company had an Access DB that I needed to expose to the web for our customer to see. Aware worked well. Sorry I can't begin to give you specifics as that's been a LONG time ago.
by tford
Sat Feb 12, 2022 4:00 pm
Forum: Tips and Tricks
Topic: COUNT UNIQUE VALUES
Replies: 14
Views: 46966

Re: COUNT UNIQUE VALUES

@Ddumas USE EXEC_SP, or the EXEC_SPF() function to return the value. I call stored procedures throughout my application, especially for queries. Also to set flags or calculated columns that are best left to SQL code Know them, love them ,use them Could you provide a couple examples of your use cases...
by tford
Fri Feb 04, 2022 3:55 am
Forum: General discussion and questions about Aware IM
Topic: Version 8.7 beta
Replies: 14
Views: 2584

Re: Version 8.7 beta

Rules Debugger, Performance Profiler, and interaction with Preview are huge improvements!

What is CREATE BUCKET.

I've been our of Aware development mode for over a year and not familiar with "bucket".
by tford
Thu Jan 27, 2022 1:32 am
Forum: General discussion and questions about Aware IM
Topic: Using Aware rule engine
Replies: 2
Views: 750

Re: Using Aware rule engine

Thanks Henrik
by tford
Thu Jan 13, 2022 2:13 am
Forum: General discussion and questions about Aware IM
Topic: Using Aware rule engine
Replies: 2
Views: 750

Using Aware rule engine

Is there anyone using AwareIM rules engine to make external database updates when Aware is called from another program?

Considering this as a use case where we have existing front end UI's and might leverage the simplicity of the Aware rules engine.
by tford
Thu Jan 28, 2021 6:15 pm
Forum: General discussion and questions about Aware IM
Topic: custom query template examples
Replies: 6
Views: 5531

Re: custom query template examples

Nice share, Jaymer!!
by tford
Mon Jan 18, 2021 7:51 pm
Forum: Wish List
Topic: FR - phpBB improvements
Replies: 6
Views: 8790

Re: FR - phpBB improvements

I would consider posting more tricks if I knew that they did in fact come in handy for other users. I've posted a lot of tips over my years in Aware IM land. While some posts didn't get much comment traction early on, over time comments were made either on the forums or by PM that confirmed people ...
by tford
Tue Jan 05, 2021 3:19 pm
Forum: General discussion and questions about Aware IM
Topic: Displaying Updated totals after inline editing
Replies: 10
Views: 4359

Re: Displaying Updated totals after inline editing

The solution here is to use COUNT instead to establish if OrderLines exist
One other option is to add an OrderLines_Count attribute to OrderHeader and use a rule to keep the new attribute current.
by tford
Thu Dec 10, 2020 2:11 am
Forum: Tips and Tricks
Topic: MySQL profiler tools
Replies: 2
Views: 5224

Re: MySQL profiler tools

Would you mind sharing some examples of how you would use these?