Search found 197 matches
- Sat May 06, 2017 8:10 am
- Forum: General discussion and questions about Aware IM
- Topic: Passing Multiple References to an SQL Stored Procedure
- Replies: 4
- Views: 10195
Passing Multiple References to an SQL Stored Procedure
My objective is to enable users to define and save "queries". I've chosen not to use the built in User Defined Queries and I'm trying to use SQL Stored Procedures and the EXEC_SP function in Aware IM. I've stored the query parameters in Aware IM (StoredProcedure BO below) and query reference attribu...
- Thu May 04, 2017 3:34 am
- Forum: General discussion and questions about Aware IM
- Topic: Checking for Overlap of Dates
- Replies: 1
- Views: 3938
Checking for Overlap of Dates
Hi, I have a "Parent" object that has "Child" objects each with attributes DateStart and DateEnd (both of type Date). The Child object's dates must not overlap. I'm trying to create a rule to confirm this. Below does not work for me :-( if EXISTS Child WHERE (Child IN Child.ob_Parent.om_Child AND Ch...
- Sat Apr 22, 2017 1:05 am
- Forum: General discussion and questions about Aware IM
- Topic: LIST_TABLE in a form
- Replies: 8
- Views: 15242
Re: LIST_TABLE in a form
I finally worked out the solution to my requirement. As is so often the case in Aware IM the solution is incredibly simple (so simple one suspects everyone probably already know it!). All I wanted was a simple read only HTML list of a one to many reference element inside a form (ie rather than a "ta...
- Fri Apr 21, 2017 12:48 pm
- Forum: Tips and Tricks
- Topic: AutoComplete Form Field
- Replies: 1
- Views: 6501
AutoComplete Form Field
Attached BSV (Zipped) demonstrates Auto Completion of Australian addresses into an Aware IM plain text form field using the Mappify.io service. I highly recommend getting an account with https://mappify.io they provide excellent personal service and are constantly extending their product.
- Fri Apr 21, 2017 5:38 am
- Forum: Tips and Tricks
- Topic: Country Combo Box from geonames.org data service
- Replies: 3
- Views: 9895
Re: Country Combo Box from geonames.org data service
Note this BSV includes a fixed username of demo embedded in the Javascript. This username has a limit of 30,000 requests a day.....you can create your own username at geonames.org for free.
- Fri Apr 21, 2017 5:36 am
- Forum: Tips and Tricks
- Topic: Country Combo Box from geonames.org data service
- Replies: 3
- Views: 9895
Country Combo Box from geonames.org data service
Attached BSV (as ZIP file) demonstrates populating a Combo Box with list of country codes and names using data from geonames.org
- Fri Apr 21, 2017 5:31 am
- Forum: General discussion and questions about Aware IM
- Topic: Google Maps AutoComplete
- Replies: 5
- Views: 10815
Re: Google Maps AutoComplete
BSV attached as ZIP file.
- Fri Apr 21, 2017 4:41 am
- Forum: General discussion and questions about Aware IM
- Topic: Google Maps AutoComplete
- Replies: 5
- Views: 10815
Re: Google Maps AutoComplete
I finally got this working myself.
I've attached a BSV demonstrating Auto Completion of Australian addresses into an Aware IM plain text form field using the Mappify.io service.
I've attached a BSV demonstrating Auto Completion of Australian addresses into an Aware IM plain text form field using the Mappify.io service.
- Tue Apr 18, 2017 9:53 pm
- Forum: General discussion and questions about Aware IM
- Topic: Google Maps AutoComplete
- Replies: 5
- Views: 10815
Re: Google Maps AutoComplete
Hi PointsWell, Did you have any success with this? We're looking to get autocomplete operating in Aware IM (for Australian addresses) as it works at https://mappify.io/app/#/addresses_services We have selected http://Mappify.io because it provides reverse geocoding of Australian state and federal el...
- Fri Apr 07, 2017 8:06 pm
- Forum: General discussion and questions about Aware IM
- Topic: Formatting XML for a web service
- Replies: 7
- Views: 12537
Re: Formatting XML for a web service
Aware IM can expose BO instances as a REST service with XML output. I use distinct Non Persistent Business Objects as a way to define what attributes the XML will have. Not certain if you can format the XML beyond this ie you cannot change the XML beyond defining attributes of the BO and giving inst...
- Fri Apr 07, 2017 7:18 pm
- Forum: General discussion and questions about Aware IM
- Topic: Q - Alternative to LoggedInRegularUser
- Replies: 6
- Views: 11109
Re: Q - Alternative to LoggedInRegularUser
I notice when you expose an object in context via an Aware IM REST service it shows all related objects and their attributes (which can be rather huge). I suspect (but I'm only guessing) this could mean that offloading attributes from LoggedInRegularUser to a related BO would NOT speed processing up...
- Sat Apr 01, 2017 8:44 pm
- Forum: General discussion and questions about Aware IM
- Topic: Aware IM Pre V8 Huddle - Bring Your Own Lunch!
- Replies: 18
- Views: 62101
Re: Aware IM Pre V8 Huddle - Bring Your Own Lunch!
An honour to host such a great group. Incredible progress in my understanding of Aware and I was motivated by the demonstrations of substantial applications built with it. Vladimir's V8 configuration tool will be a quantum leap in productivity for users, look forward to beta testing. The day took me...
- Mon Mar 27, 2017 12:10 pm
- Forum: General discussion and questions about Aware IM
- Topic: Parsing the results of an EXECUTE PROGRAM
- Replies: 3
- Views: 6000
Re: Parsing the results of an EXECUTE PROGRAM
Python can move JSON data to CSV easily. After converting the data to CSV, save it to a temporary file and use an AwareIM IMPORT function to get the data into a BO. I've had success using AwareIM document templates to build temporary Python scripts that have variables for the particular REST URL req...
- Wed Mar 01, 2017 12:38 pm
- Forum: General discussion and questions about Aware IM
- Topic: LIST_TABLE in a form
- Replies: 8
- Views: 15242
Re: LIST_TABLE in a form
Do you mean you create the HTML list using a rule store the HTML list in an attribute then display that attribute?
- Wed Mar 01, 2017 9:47 am
- Forum: General discussion and questions about Aware IM
- Topic: LIST_TABLE in a form
- Replies: 8
- Views: 15242