Search found 85 matches
- 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: 9439
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.
- 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: 3782
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)
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)
- 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: 6362
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...
- 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: 22706
Re: Updating Fields based on each other value
Same build - linux - mysql 5.5.50
Browser?
Browser?
- Fri Feb 24, 2017 7:22 am
- Forum: General discussion and questions about Aware IM
- Topic: Updating Fields based on each other value
- Replies: 13
- Views: 22706
- Fri Feb 24, 2017 6:36 am
- Forum: General discussion and questions about Aware IM
- Topic: Updating Fields based on each other value
- Replies: 13
- Views: 22706
Re: Updating Fields based on each other value
The attached bsv works
- 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: 22706
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)
IF (Invoices.InvoiceDate WAS CHANGED OR Invoices.DaysDue WAS CHANGED)
THEN
Invoices.DateDue=DATE_ADD(Invoices.InvoiceDate,Invoice.DaysDue)
- Tue Feb 07, 2017 1:01 am
- Forum: General discussion and questions about Aware IM
- Topic: V8 Is Coming....
- Replies: 16
- Views: 24875
Re: V8 Is Coming....
*heavy breathing*
- 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: 29308
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
- 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: 29308
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 ...
- 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: 7335
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.
- 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: 7335
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...
- Wed Oct 12, 2016 4:07 am
- Forum: General discussion and questions about Aware IM
- Topic: The list of PublicHolidays
- Replies: 7
- Views: 9380
Re: The list of PublicHolidays
Not sure about that one, support will need to jump in & answer that.
- Tue Oct 11, 2016 1:53 pm
- Forum: General discussion and questions about Aware IM
- Topic: The list of PublicHolidays
- Replies: 7
- Views: 9380
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...
- 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: 4769
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...