Search found 85 matches

by rob_h7
Tue Mar 28, 2017 4:18 am
Forum: General discussion and questions about Aware IM
Topic: SQL and StoredProcedure Webinar - Thurs March 30th 1PM EST
Replies: 5
Views: 9421

Re: SQL and StoredProcedure Webinar - Thurs March 30th 1PM E

Would be keen to watch but that's like 2-3am Sydney time. If you could record it, that'd be great.
by rob_h7
Mon Mar 27, 2017 3:45 am
Forum: General discussion and questions about Aware IM
Topic: Retrieving the filename from a Document attribute
Replies: 1
Views: 3768

Re: Retrieving the filename from a Document attribute

BONAME.FileName=FILE_NAME(BONAME.File)

That'll give you the name, if you want the extension also...ie, pdf, xls, csv, then use

BONAME.FileName=FILE_NAME(BONAME.File)+'.'+FILE_EXTENSION(BONAME.File)
by rob_h7
Fri Mar 24, 2017 3:19 am
Forum: General discussion and questions about Aware IM
Topic: How to Change the Tab Name in Browser
Replies: 3
Views: 6343

Re: How to Change the Tab Name in Browser

On the Visual Perspective used to login, head to the content panels, click a panel to edit, click 'Other Properties' tab down the bottom of the 'Properties of selected content panel' on the right hand window, click 'Advanced' & put this in the Render Script. document.title="YourName"; It'll change t...
by rob_h7
Fri Feb 24, 2017 7:29 am
Forum: General discussion and questions about Aware IM
Topic: Updating Fields based on each other value
Replies: 13
Views: 22635

Re: Updating Fields based on each other value

Same build - linux - mysql 5.5.50

Browser?
by rob_h7
Fri Feb 24, 2017 4:53 am
Forum: General discussion and questions about Aware IM
Topic: Updating Fields based on each other value
Replies: 13
Views: 22635

Re: Updating Fields based on each other value

You should use DATE_ADD when adding days to a Date type field, rather than a Date+33

IF (Invoices.InvoiceDate WAS CHANGED OR Invoices.DaysDue WAS CHANGED)
THEN
Invoices.DateDue=DATE_ADD(Invoices.InvoiceDate,Invoice.DaysDue)
by rob_h7
Tue Feb 07, 2017 1:01 am
Forum: General discussion and questions about Aware IM
Topic: V8 Is Coming....
Replies: 16
Views: 24828

Re: V8 Is Coming....

:shock:
*heavy breathing*
by rob_h7
Tue Dec 06, 2016 3:57 am
Forum: General discussion and questions about Aware IM
Topic: Google map of a group of addresses
Replies: 19
Views: 29099

Re: Google map of a group of addresses

Yep, there's an option in the controls of the presentation to determine what happens when they click a marker, options like Edit Object, Start process etc
by rob_h7
Tue Oct 25, 2016 11:04 pm
Forum: General discussion and questions about Aware IM
Topic: Google map of a group of addresses
Replies: 19
Views: 29099

Re: Google map of a group of addresses

Yup. Quick solution = 1. Your business object with an address attribute - lets call it BOMAP 2. Create a Presentation on BOMAP - add in the Google Map element, fill out the options. I think the placement of it in the presentation is important, we have ours in Summary & it works, I think if you have ...
by rob_h7
Fri Oct 14, 2016 6:43 am
Forum: General discussion and questions about Aware IM
Topic: Limit Document upload sizes Version 7 / 7.1
Replies: 3
Views: 7294

Re: Limit Document upload sizes Version 7 / 7.1

We did, but I think that checks once the file has finished uploading. We had a user attempt a 140MB MP4 file, which killed the server before the rule had a chance to do anything.
by rob_h7
Fri Oct 14, 2016 2:39 am
Forum: General discussion and questions about Aware IM
Topic: Limit Document upload sizes Version 7 / 7.1
Replies: 3
Views: 7294

Limit Document upload sizes Version 7 / 7.1

On version 6, we used to have Business Object rules in order to stop people uploading large documents which would crash the system. However, as per Support, with version 7 - 7.1, these no longer work. At some point in a future build, we'll be able to limit file size uploads in the config, however fo...
by rob_h7
Wed Oct 12, 2016 4:07 am
Forum: General discussion and questions about Aware IM
Topic: The list of PublicHolidays
Replies: 7
Views: 9357

Re: The list of PublicHolidays

Not sure about that one, support will need to jump in & answer that.
by rob_h7
Tue Oct 11, 2016 1:53 pm
Forum: General discussion and questions about Aware IM
Topic: The list of PublicHolidays
Replies: 7
Views: 9357

Re: The list of PublicHolidays

found this in the UserGuide - pg 446 - 447 The following table lists and explains the property settings of the BASServer.props file that are used to initialize the Aware IM Server: PublicHolidays - A collection of days identifying public holidays in the country or state of operation. This informatio...
by rob_h7
Tue Oct 11, 2016 5:04 am
Forum: General discussion and questions about Aware IM
Topic: Pull 2nd word out of a text attribute
Replies: 2
Views: 4750

Re: Pull 2nd word out of a text attribute

We use this in MYSQL & works fine. IF WORD_NUMBER(Candidate.CandidateName)=2 THEN Candidate.FirstName=WORDS_FROM_LEFT(Candidate.CandidateName,1) Candidate.LastName=WORDS_FROM_RIGHT(Candidate.CandidateName,1) We never saw the 'only works in Derby' so threw it in, I guess if you don't read it, the dis...