Aware IM User Forums

lueu wrote: ↑Thu Oct 12, 2023 9:30 am I first used a text field with dynamic choises from a query.

Reuse the query on the filter for the peer attribute.

Look for Filter on the bottom right pane in config tool.

Don’t have an answer but I’m intrigued as to how MSSQL allowed columns with reserved words as their name.

It is hard to tell from what you've posted.

Check the space allocated to the whole query, it looks too small to show the whole query and the space allocated to the query results is too small to show the query results.

So, I think I figured out the shortcut path, but I am wondering if I am thinking in the right direction about how to display the correct value in the form based on the ID chosen by the user.. Am I right thinkin I would need a query that fetches the belonging name for the ID chosen? And if so, any t...

The protection is not permanently held against a record. It is evaluated for every object being loaded. AKA it is a massive speed inhibitor as the rule has to be read n times for every query (where n is the number of instances being returned) before deciding whether or not to show the record in the...

Do you mean that you have used a text field with choices based on a query? What you probably want is to use a peer relationship instead. You will have full access to all of the attributes of the related BO and can use the field to either show multiple attributes of the referenced BO in the one field...

Search “instance prefix”

I have mused over this one before and committed myself to use IF SEARCH_COUNT as the stage gate to my sub processes. I then forget every time. I worked it out because I found processes running and not generating records because when tracked back the search didn't return anything. Yes AIM continues w...

ACDC wrote: ↑Sun Sep 10, 2023 6:16 pm should it not default to a Combo Box ?

I agree, makes no sense to default to grid for one record.

The ideal set up is 3 tier. Webserver -----> AIM -----> DB Server Ports 80, 443 8080 3306 IP Public Private Private Address Webserver can only receive via 80 and 443, webserver can only communicate via 8080 and only to AIM server AIM server only receives on 8080 and can only communicate on 8080 to w...

I don't see the point in running a dedicated DB server within the context of an AwareIM app. It's just another thing that can go wrong, and I've always considered it less secure. Hard disagree on this. Database should always be segregated from App server and even more so if you are running AIM with...

If that is the case then check the text encoding of the database and the csv file (and if it was extracted from a database then the encoding of the source database)

What does the CSV file look like when opened in a text editor? Excel hides many sins.

You can build up the API call using objects that are in context.

Eg
There’s a tutorial on REST on YouTube using the Weather.com app I built a few years ago.