Search found 47 matches

by JoshK131
Sun Mar 31, 2024 11:58 pm
Forum: General discussion and questions about Aware IM
Topic: UDD Export speed
Replies: 0
Views: 1740

UDD Export speed

I have set up the application user to be able to add UDD word docs and export them, as word or pdf. If its a word doc, I use DISPLAY DOCUMENT UDDParameter.ps_UserDefDoc.UDD_Name If its a pdf export, I use EXPORT DOCUMENT UDDParameter.ps_UserDefDoc.UDD_Name TO FILE UDDParameter.DocumentPath EXECUTE P...
by JoshK131
Tue Mar 26, 2024 4:23 am
Forum: Wish List
Topic: Naming in New Tab
Replies: 2
Views: 8636

Naming in New Tab

I have a query that opens a form in a new tab. The tab title is set to a custom value. i.e. p-<<Prospect.FullName>> javaw_czbdxnAEAz.png If I have 10 different places the form is opened, I need to edit 10 different new tab settings to get the tab name. If I want to change the tab title naming conven...
by JoshK131
Thu Mar 07, 2024 7:25 am
Forum: Problem reports
Topic: Sub query with reference attributes not working V9
Replies: 6
Views: 2099

Re: Sub query with reference attributes not working V9

Upgrading mySQL to version 8 solved the problem.
................
by JoshK131
Wed Mar 06, 2024 10:11 pm
Forum: Problem reports
Topic: Sub query with reference attributes not working V9
Replies: 6
Views: 2099

Re: Sub query with reference attributes not working V9

Error message:

/* SQL Error (1054): Unknown column 'Invoice.ps_Region_RID' in 'on clause' */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
by JoshK131
Wed Mar 06, 2024 12:03 pm
Forum: Problem reports
Topic: Sub query with reference attributes not working V9
Replies: 6
Views: 2099

Re: Sub query with reference attributes not working V9

Thanks Jaymer. Using MYSQL Server 64x V5.7.26 Aware IM Query FIND Invoice WHERE EXISTS RegionAccess WHERE (Invoice.ps_Region.RegionChain=RegionAccess.ps_Region.RegionChain) ORDER BY Invoice.ModifiedTimestamp DESC SQL Query SELECT Invoice.* FROM INVOICE AS Invoice WHERE (((SELECT COUNT(*) FROM REGION...
by JoshK131
Wed Mar 06, 2024 6:00 am
Forum: Problem reports
Topic: Sub query with reference attributes not working V9
Replies: 6
Views: 2099

Sub query with reference attributes not working V9

Hello. The query below is not longer working in V9. FIND Invoice WHERE EXISTS RegionAccess WHERE (Invoice.ps_Region.RegionChain = RegionAccess.ps_Region.RegionChain ) There is no error in the cofigurator. When i try to view it in testing mode in a brower, i get this error. Internal error. Error read...
by JoshK131
Sat Mar 02, 2024 1:21 am
Forum: General discussion and questions about Aware IM
Topic: Connection for this site is not secure
Replies: 2
Views: 1788

Re: Connection for this site is not secure

What was the configuration problem?

I had this problem when i installed the new version.
Reinstalled in new directory and problem stopped, but the problem started again today.
by JoshK131
Fri Mar 01, 2024 12:14 am
Forum: Problem reports
Topic: Presentation Rules Missing for Combo Box
Replies: 2
Views: 4758

Re: Presentation Rules Missing for Combo Box

+1 for this
by JoshK131
Fri Mar 01, 2024 12:12 am
Forum: Wish List
Topic: Presentation of the attribute is overridden in form
Replies: 0
Views: 4382

Presentation of the attribute is overridden in form

When I create a form with 2 columns, I move some attributes to the 2nd column and merge cells for table attributes. The attributes I move and the attributes in the merged cells cannot be edited in the Object Presentation attributes anymore. I will get the warning Presentation of the attribute is ove...
by JoshK131
Tue Feb 27, 2024 10:23 pm
Forum: Wish List
Topic: Peer Multiple reference object
Replies: 3
Views: 1882

Re: Peer Multiple reference object

I dont have a question. Just a wish list post. If there are many tiers of managers for example, then many different people should have access to an Account. Instead of having ps_Manager, ps_Owner, ps_Supervisor, having 1 pm_Owner makes it easier to manage access permissions. But now in the PM, i don...
by JoshK131
Tue Feb 27, 2024 10:45 am
Forum: Wish List
Topic: Peer Multiple reference object
Replies: 3
Views: 1882

Peer Multiple reference object

I have an Account BO and a RegularUser BO. If an Account can have many owners, this needs a 2 way peer multiple reference attribute. If i want to say what kind of owner it is, then ill need to make a new AccountOwner BO with a single RegularUser and single Account with some other attributes detailin...
by JoshK131
Tue May 09, 2023 11:28 pm
Forum: General discussion and questions about Aware IM
Topic: Aware mail setting
Replies: 8
Views: 5823

Re: Aware mail setting

Is there a solution to getting outlook smtp working on Aware IM applications?

I've had to move most of my clients to gmail for sending emails.
by JoshK131
Mon Nov 07, 2022 4:55 am
Forum: Problem reports
Topic: Outlook POP3/IMAP basic Auth depreciated
Replies: 0
Views: 17706

Outlook POP3/IMAP basic Auth depreciated

Hello, Outlook has recently been updated so POP3/IMAP connected to the incoming email account is not working at the moment. https://learn.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online The new documentation says we need to use O...
by JoshK131
Thu Oct 06, 2022 7:29 am
Forum: Problem reports
Topic: Handling small decimal numbers
Replies: 6
Views: 20378

Re: Handling small decimal numbers

The database also stores 1.234

The bug happens with 6 digits after the decimal.
by JoshK131
Mon Oct 03, 2022 9:58 pm
Forum: Problem reports
Topic: Handling small decimal numbers
Replies: 6
Views: 20378

Re: Handling small decimal numbers

The SQL type for the number is currently set to "DECIMAL (40,20)"
That does not work.

"Real" type does not work either.