Well, it had to be done. So jump on in and lets keep Support busy! If you can, please make the name of your post "your wish list item" instead of "RE: The *OFFICIAL* yada yada". Will be easier for the Summary page.

1) ADD Alignment on Query Column Setup 2) Memory Variables

Since I posted this on the WishList 17 months ago... and I talked to Roger this week and he wanted almost the exact same thing, I'm reposting this from March 20, 2018: https://www.awareim.com/forum/d/10236 Default it to Left for Strings, Right for Numeric and I won't have to spend time beautifying my numeric columns by having to drill in and set the Header Styles. There are more properties, but you could still get to them by clicking the row, edit, header styles. Maybe a Ctrl-Click on the Alignment pulldown could popup the header Styles dialog directly (which saves you 1 click). [upl-image-preview uuid=0c7c33ce-2435-4e58-9f36-0c3229d3271b url=https://www.awareim.com/forum/assets/files/phpbb_migrated/885_26f1c4eea093029c69966235ae39523c alt=Screen Shot 2018-04-20 at 4.31.46 PM.png]

Should this not be in the wish list forum - it is now impossible to find anything in this board because it is a bundle of wishes, feature requests, tips and ideas and problem reports which have their own areas for posting.

I kinda like it here. I’m not moving it, but if a forum admin thinks it need to get less visibility over there and he/she can move it.

[quote="Jaymer"]I kinda like it here. I’m not moving it, but if a forum admin thinks it need to get less visibility over there and he/she can move it.[/quote] Well kinda contributes to the ever decreasing utility of the forum.

Would it really be that tough to have ONE MORE object in memory all the time? I'll concede that it will take up server memory on a per-user basis - so it might not be the best place to have several 50,000k JSON string fields, but adding 1-5k more per session could be planned for. In addition to LIRU & SystemSettings, which are always available, couldn't support easily add LoggedInSession and thats just 1 more BO that we can define like any other BO, and yet its always available for the duration of a login session. Don't we all constantly need to save some temporary value somewhere - we do this by adding fields to LIRU, which just kinda bloats that object. I'm fine with having to pre-declare any variables that I need (as opposed to making something up on the fly like a "true" memory variable would be), What say support?

[quote="Jaymer"]Would it really be that tough to have ONE MORE object in memory all the time? I'll concede that it will take up server memory on a per-user basis - so it might not be the best place to have several 50,000k JSON string fields, but adding 1-5k more per session could be planned for. In addition to LIRU & SystemSettings, which are always available, couldn't support easily add LoggedInSession and thats just 1 more BO that we can define like any other BO, and yet its always available for the duration of a login session. Don't we all constantly need to save some temporary value somewhere - we do this by adding fields to LIRU, which just kinda bloats that object. I'm fine with having to pre-declare any variables that I need (as opposed to making something up on the fly like a "true" memory variable would be), What say support?[/quote] Unfortunately this doesn't solve the issue of the extra round trip to the server which imo is a significant downside of using LIRU to manage state. Additionally, a basic tenet of web development is to be "stateless". In other words it's generally bad practice to store temporary values on the server to be used for subsequent server calls. However, that's already being broken by using LIRU at all. :)

well since you asked... :D [b]1. Badge on Left Menu:[/b] [list]On the Left Hand menu the ability to add a badge Works similar to badges in toolbars and form tabs So can be used for “News” counts, new lead Counts etc [/list] [b]2. Charts on forms:[/b] [list]Charts currently require a query Doesn’t work in all situations, eg we want to place a small, simple chart on a form Can do a Reference Attribute and records, but this is quite “heavy” when you just want a simple chart Currently we are using JavaScript charts to do this, it’s ok, but would prefer to keep all charts in Aware Idea is to have an Aware chart that isn’t a query, it just gets generated based on attributes on the BO For example, you can add say five attributes for the data points and the chart uses these for the data set Alternatively maybe you can have one plaintext field that holds an array of data used in the chart, and we have to define it in a certain way with a rule eg [dogs:3;cats:1;fish:4] This would be similar to how you add a Google Map to a form[/list] [b]3. Uploading and publishing new versions: (two new process rules)[/b] This was briefly discussed at Conference, publishing is such a big thing: - It needs to be done late at night when no users are online (or else you kick users out and get errors such as can’t publish due to active processes), this means someone has to stay up late at night - The risk of error is MASSIVE. Publishing the wrong bsv over the top of another is a catastrophIc error, we have done it by accident (more than once), and isn’t helped that it is 1am when we do it (tired etc) and you are doing 15 each night. - Its a manual “one at a time” process. We can publish 15 BSVs a night, so it takes a long time. Login to dev server, download BSV. Login to PROD server, upload and publish. How could this be improved? I think with two PROCESS RULES we could build a solution that would please everyone. We can develop a few processes/functions to automate this process. What we would need: An Aware process rule (function) to download the bsv and put it in a directory on the DEV server. Putting it on the dev server is really important, not on the machine where the remote config tool is. So a process like: EXPORT TEST BSV to ‘/directory/‘ and EXPORT CURRENT BSV to ‘/directory/‘ would be great. It would be good to be able to use tags here like EXPORT TEST BSV to ‘' We could then build a seperate Aware bsv (lets call it PublishManager) that grabs these .bsv files and does manager approval rules and then move the bsv file to a special directory on the right PROD server (we could do an EXECUTE PROGRAM to move it with a bash script and SFTP, it would be great to have an Aware process rule to SFTP a file but I have no idea if that is possible - nice to have only ) From there we can create an Aware process on the PROD server that we can schedule to look in the directory and if there is a BSV in the directory then publish it. Basically an Aware rule like PUBLISH ‘/dir/filename.bsv’. it would be good to be able to use tags here too like PUBLISH ‘‘ (could also it from a Document attribute if that is easier) This process would log the results in some table with a status or error message. Eg Publish failed, success etc. That way we could monitor it and build rules to SMS us if a publish failed. The ability to schedule the PUBLISH rule is really important. With servers in different timezones it needs to happen in the middle of the night. Also we can set it to be done right after our scheduled backup. And make it happen in a staggered way so 5 bsvs on the same server are not being published at the same time. These two rules would be very helpful, it removes human error and in our case would save probably 3-5 hours a week. We just queue them up, approve them during the day and it happens at night while we sleep.

[quote]1. Badge on Left Menu:[/quote] I am sure this was the original intention but ended up being very limited :( x 100 [quote]3. Uploading and publishing new versions: (two new process rules)[/quote] yes, please, this is critical x 1000

HTML canvas editor https://www.drawerjs.com/ Adding an extra editor with functionality to be able to draw diagrams, and highlight image sections would be a very nice and powerful feature. This would allow picture annotation, diagrams, layouts serving insurance claim applications, crime scene diagram, medical assessment discovery diagrams, etc etc . This application/feature has endless opportunities within in an AwareIM developer environment.

The OFFICIAL Fall 2019 WISH LIST is here !!!!!!!

ACDC

We would use this in 8.3... in 2019, uploading of videos and large docs is just becoming more and more common

if this does make it into a future release, having an option to store documents in an encrypted state using a predefined encryption passphrase would really be good

Jaymer

Discussed in a forum post here.

Jaymer

One thing I really try to avoid is making a lot of "redundant" grids ... where only a few things have changed.
Mostly because of the obvious... when 1 thing needs to be changed I have to do it in multiple grids which are basically the same. I hate doing redundant work.

I find that I might want to have a grid of Current Orders for a Dept. Manager. (only orders in that Dept.)
And a "Admin" in the company needs to see ALL Current Orders.
And a Sales Rep only see his Order. Open & Closed.

All the columns are basically the same (and Aware conditions on columns could hide a few if needed).

But what changes is the Query CRITERIA
(NOTE: Before you say it, YES, I realize I can create one hell of a convoluted Query string with "conditions" in it to do this - but thats extremely messy and not as cool as the solution below.)

Seems like it would be convenient if I had a Rules table with multiple conditions for selecting Criteria & ORDER BY
After all, this only needs to be evaluated ONCE when the Grid is displayed at runtime before getting data from the DB - and then the Query gets assembled and sent to the backend.

CRITERIA (ie. WHERE): (note: LISU = LoggedInSystemUser, but could be other things or functions, but LISU for version 1)
CND = LISU.AccessLevel='Manager' --> Criteria= 'where Dept=Manager`sDept and Status=Open'
CND = LISU.AccessLevel='Admin' --> Criteria= 'where Status=Open'
CND = LISU.AccessLevel='Sales' --> Criteria= 'where Status=Open or Closed'

SORTING:
CND = LISU.tmpFlag='A' --> ORDER='Dept, Model'
CND = LISU.tmpFlag='B' --> ORDER='Rep, OrderDate'

Just make it easy and use the first matching condition in each section

AND, while I'm making this up, it would be nice to specify a GROUP BY which would activate the Kendo Grouping.
GROUPING:
CND = LISU.AccessLevel='manager' --> GROUP='Rep'
CND = LISU.AccessLevel='user' --> null this is not even needed for "user"

I have a Grid now, when used by an EndUser, the Grouping makes no sense - its only his/her records.
But when a Manager is looking at data, the Grouping COULD be used.
But there's no Dynamic way to turn on/off Grouping.

ACDC

One thing I really try to avoid is making a lot of "redundant" grids ... where only a few things have changed.
Mostly because of the obvious... when 1 thing needs to be changed I have to do it in multiple grids which are basically the same. I hate doing redundant work.

I re-use a lot of queries by having a Range Object or Parameter Object in place before the query is run. Every time the query process is run a new Range object is created prompting the user for the parameters via a pop-up. The query (parameter grid) is then set to take on the values from the Range object which is in context. Also, you can list query parameters in a text section in the top panel menu section of the query result from the Range object that is in context, which is useful

This works very well, periodically I clean out the redundant Range objects.

If i am reading you right, this may be a solution ?

UnionSystems

Ticking the "Don't check referred" Rule Property is regularly done by AwareIM developers to improve the speed of their App.

Could we :

Include this as a column in the list of all Rules for an Object (so that it can be reviewed quickly without having to open each rule)
Have this default to Yes (ticked) when a Rule is created

ACDC

Code: Select all
P.S. What is the list of new features in next version & when it will be released?

The focus of the version will be predominately a list of little things that make the difference. Among relatively big features will be native support for Postgre SQL, Preview of a report in the Report Designer, support for barcodes and QR codes in the Report Designer. At this stage we are planning to release the version in late October.

just wondering if this release is on target for late October?

rbross

karelh wrote
1. The ability to automatically size query grid column widths OR to set a percentage instead of an actual column size value.

Official support for MySQL 8 including MySQL 8 cluster environments.

Thanks 🙂

We can do this on forms with multiple columns so it would be great if we could do this on a grid!
It would definitely improve the responsiveness of the grid when the browser is resized.

RLJB

UnionSystems wrote
Ticking the "Don't check referred" Rule Property is regularly done by AwareIM developers to improve the speed of their App.

Could we :

Include this as a column in the list of all Rules for an Object (so that it can be reviewed quickly without having to open each rule)

Have this default to Yes (ticked) when a Rule is created

Absolutely, have asked for this. You must know the importance of this tiny tick box if you want to scale a system, and it should be default to Yes (ticked) when a Rule is created.

himanshu

Jaymer wrote
Can we get rid of (ie. Fix) the annoying "Incorrect Header Check" msg that fills the Server Output window everytime an Email is sent?

Sending unsent email...
java.util.zip.DataFormatException: incorrect header check
at java.util.zip.Inflater.inflateBytes(Native Method)
at java.util.zip.Inflater.inflate(Inflater.java:259)
at java.util.zip.Inflater.inflate(Inflater.java:280)
at org.openadaptor.util.compression.ZipUncompress.uncompress(ZipUncompress.java:73)
at com.bas.shared.data.BinaryResource.unzipResources(BinaryResource.java:267)
at com.bas.shared.docengines.HtmlEngineClient.readHtmlData(HtmlEngineClient.java:149)
at com.bas.basserver.iopipes.EmailSink.A(Unknown Source)
at com.bas.basserver.iopipes.EmailSink.A(Unknown Source)
at com.bas.basserver.iopipes.EmailSink.A(Unknown Source)
at com.bas.basserver.iopipes.EmailSink.C(Unknown Source)
at com.bas.basserver.iopipes.EmailSink.A(Unknown Source)
at com.bas.basserver.iopipes.EmailSink$_E.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)

Bump+

PointsWell

RLJB wrote
UnionSystems wrote
Ticking the "Don't check referred" Rule Property is regularly done by AwareIM developers to improve the speed of their App.

Could we :

Include this as a column in the list of all Rules for an Object (so that it can be reviewed quickly without having to open each rule)

Have this default to Yes (ticked) when a Rule is created

Absolutely, have asked for this. You must know the importance of this tiny tick box if you want to scale a system, and it should be default to Yes (ticked) when a Rule is created.

I'm kinda torn by this, scaling is an "advanced" user (though really a matter of good design and planning) and I agree with Vlad that new users have basic expectations.

An alternative would be something similar to Styles but for processes where you could set default Rule properties

« Previous Page