Search found 197 matches

by UnionSystems
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: 10173

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...
by UnionSystems
Thu May 04, 2017 3:34 am
Forum: General discussion and questions about Aware IM
Topic: Checking for Overlap of Dates
Replies: 1
Views: 3935

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...
by UnionSystems
Sat Apr 22, 2017 1:05 am
Forum: General discussion and questions about Aware IM
Topic: LIST_TABLE in a form
Replies: 8
Views: 15218

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...
by UnionSystems
Fri Apr 21, 2017 12:48 pm
Forum: Tips and Tricks
Topic: AutoComplete Form Field
Replies: 1
Views: 6481

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.
by UnionSystems
Fri Apr 21, 2017 5:38 am
Forum: Tips and Tricks
Topic: Country Combo Box from geonames.org data service
Replies: 3
Views: 9876

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.
by UnionSystems
Fri Apr 21, 2017 5:36 am
Forum: Tips and Tricks
Topic: Country Combo Box from geonames.org data service
Replies: 3
Views: 9876

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
by UnionSystems
Fri Apr 21, 2017 5:31 am
Forum: General discussion and questions about Aware IM
Topic: Google Maps AutoComplete
Replies: 5
Views: 10799

Re: Google Maps AutoComplete

BSV attached as ZIP file.
by UnionSystems
Fri Apr 21, 2017 4:41 am
Forum: General discussion and questions about Aware IM
Topic: Google Maps AutoComplete
Replies: 5
Views: 10799

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.
by UnionSystems
Tue Apr 18, 2017 9:53 pm
Forum: General discussion and questions about Aware IM
Topic: Google Maps AutoComplete
Replies: 5
Views: 10799

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...
by UnionSystems
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: 12510

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...
by UnionSystems
Fri Apr 07, 2017 7:18 pm
Forum: General discussion and questions about Aware IM
Topic: Q - Alternative to LoggedInRegularUser
Replies: 6
Views: 11094

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...
by UnionSystems
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: 59229

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...
by UnionSystems
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: 5984

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...
by UnionSystems
Wed Mar 01, 2017 12:38 pm
Forum: General discussion and questions about Aware IM
Topic: LIST_TABLE in a form
Replies: 8
Views: 15218

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?