Aware IM User Forums

OK Vlad. sent you 3 of them, will send more screen shots as I run into them.

Bruce

I have a rest call that returns: {"rows returned":3}


I need the # and I am can not figure out how to access it. My last tries were PARSE_JSON(returnObj, '$[rows returned]') but I get a blank

Thanks
Bruce

Perhaps I am one of the few MAC users (Server is on windows, but I use a mac for my development). There are so many bugs with using the mac that have not been fixed, I am wondering if it is becuase there are so few users of OSX. Many dialog boxes don't fit on the screen and some buttons are hidden, ...

I do that by having a "selected" field in the BO. Then I have a rule called whenever the "selected" is changed to summarize the data and storing it in LoggedInRegularUser and have a VP with the LoggedInRegularUser data fields displayed (and updated) below the BO's query.

Does this make sense?

Bruce

Did you create the custom query for the combo box where you filter on the parent (job)?

Bruce

I would suggest that you export your current version whenever changes are made. Then it is easy to "import" if one of your changes breaks something. I have exports from almost every day that I work on a BSV. I name them with the MMDD at the end of the bsv name, to make it easy to find the right day ...

Just spit balling here.... But if I understand, each Job has 0-N Job areas. So when you create a new job, you will create new job areas that are owned by the job. if this is true, then you need to have 2 features: 1). a button that will create a new job area and have its parent the job 2). a combo b...

Repeat after me....

Stored Procedures are my friend.....
Stored Procedures are my friend.....
Stored Procedures are my friend.....
Stored Procedures are my friend.....
Stored Procedures are my friend.....
.....

I am pretty sure Jaymer has a solution to export. Reach out to him.

Bruce

When I am ready to restart the server, I always run the following sql script. "delete from Aware.dbo.EXECUTION_CONTEXTS"

Execution_Contexts always has 20-60 old thingies hanging around.

Bruce

Yes I do, and also export CSV. (If my bad memory is correct, when exporting PDF it only exports CURRENT page. Exporting CSV exports the entire view). Ideally would have a default name pop up that could be changed.

Mark, generally I need a commit transaction BEFORE (not after) I call a stored procedure. That way any data that is either entered (or computed by a rule) in Aware are saved to the database. Since I do that before calling the SP, any aware processing afterwards will (re)read the appropriate records ...

Can you get a sequence in the SQL table? (Can easily be done by a stored procedure). Then, you can have a filter like:
FIND BO WHERE BO.seq <= SessionVars.noRecs


Bruce

I am having some issues with it. I am connecting to Supabase, a web based version of postgres and anytime I have to create a database it seems to fail. If the DB exists (I created one for Aware and AwareTest) then it seems happier, but when trying to create a new business space it errors out on crea...

I use a lot of stored procedures and use COMMIT TRANSACTION a lot. It seems to work fine for me. You do know, after you commit, and then call a stored procedure, you have to RE-READ the record to get any changes.

Bruce