CALCULATION in Query's Custom Data Template

Rennur

I have simple "Orders" query. I'd like to show the total number of orders using CSS to look like one of the Windows 8 tiles. This tile will appear on the VP.
The reason I'm using a query to display this in the VP and not Static HTML is because of the auto refresh feature on queries.

HTML Code in Query's Summary:

HTML Code in Query's Custom Data Template:

HTML Code in a Presentation:

I cannot find where or how to insert HTML code into the presentation.

Is it possible to have the custom data template improved so it allows functions?

Cheers

ACDC

This is a long shot, have you tried placing some code in the Advanced Button on the query. This would really be a good dashboard feature.

pbrad

Hi,

I could be wrong but if your code is <<BO.Attribute>>, you could try <<BO.Attribute>>

Cheers,
Pete

tford

Since forms also have an auto-refresh feature, could you use a form to display this info? You will have complete control through an HTML cell and can also easily control label and button visibility.

RLJB

Use the custom query, put the count somewhere else (on BO or other place) and display it as an attribute?

Rennur

Thank you for all the replies and suggestions.

This is a long shot, have you tried placing some code in the Advanced Button on the query.

Placing code in the advanced button to hide the grid would be ideal. Maybe support can suggest if it is possible.

I could be wrong but if your code is <<BO.Attribute>>, you could try <<BO.Attribute>>

The code does not include an attribute. It is only the BO <<COUNT Object>>. Using < & > didn't work.

Since forms also have an auto-refresh feature, could you use a form to display this info? You will have complete control through an HTML cell and can also easily control label and button visibility.

I tried using a form in the query with a HTML cell in the Order object. The number of orders does not show at all. <<COUNT Orders>> is blank.

Use the custom query, put the count somewhere else (on BO or other place) and display it as an attribute?

Not sure how to attempt this. How the number is refreshed. Do I needs process.?

Cheers

tford

Rennur,

I wasn't focused on the COUNT aspect of your original post. If you use a form, you'll have to add an attribute to the RegularUser BO (or other SystemUser group member) and store the result of the COUNT action there, then use a VIEW process to display the form in a VP panel above the query.

Rennur

If you use a form, you'll have to add an attribute to the RegularUser BO (or other SystemUser group member) and store the result of the COUNT action there, then use a VIEW process to display the form in a VP panel above the query.

Thanks for the suggestion, I got it working via SystemSettings attribute, rule and a VIEW process like you sugested. I still prefer to use the query on its own.

Support, is there a way to display just the query Summary without the grid using he Advanced Button?

hpl123

Rennur,
Did you manage to get this working so you have a "statuspane" (e.g. orders) that updates automatically "live" (without reload or the VP/tab/pane) when a new BO instance is created? (is it the auto-fresh in the form that updates the actual number?).

On a related note, have you managed to get this same auto-refresh functionality working for e.g. a footer or header? (e.g. auto-refresh footer statusbar). I know you have (me too) worked on this before?

hpl123

Rennur, forgot to ask. Would you mind sharing the actual html code for the W8 status pane. Looks great!

Thanks in advance

Rennur

Did you manage to get this working so you have a "statuspane" (e.g. orders) that updates automatically "live" (without reload or the VP/tab/pane) when a new BO instance is created? (is it the auto-fresh in the form that updates the actual number?).

a) The Orders query (number) on the VP have did not auto-refresh when an order was created by another user on a different computer. I had to press the refresh button for the number to update.

b) The auto-refresh worked and the number updated when I created the Order myself.

On a related note, have you managed to get this same auto-refresh functionality working for e.g. a footer or header? (e.g. auto-refresh footer statusbar). I know you have (me too) worked on this before?

I cannot get the the banner or footer to auto-refresh, not with HTML anyway. I think ExtJS supports panel auto-refresh but that's beyond my skill set.
http://www.sencha.com/forum/showthread.php?177534-Panel-with-autoloader-and-autorefresh

I'd like to have the ability to have the data on the visual perspective auto-refreshed and displayed in realtime. I don't know to what extent or if is possible at all at the moment.

Rennur, forgot to ask. Would you mind sharing the actual html code for the W8 status pane. Looks great!

I'll send you a PM with the code.

Cheers

hpl123

Thanks Rennur,
Having auto-refresh functionality throughout an application (all panels etc.) would be ideal. Hopefully Awaresoft adds this functionality.

hpl123

Support (or anyone who knows),
Trying to understand the new "process to auto-refresh form/query". Can it be used to create updates like the one Rennur was trying to achieve in this post? If not, how is this new process to auto-refresh feature meant to be used?

Thanks

tford

Henrik,

re: If not, how is this new process to auto-refresh feature meant to be used?

I had some communication with support recently that if you are on page x (something other than page 1) of a query and apply a filter, the query's auto-refresh only refreshes that page, so it looks like there are no items in the newly filtered results.

So, support added the ability to not trigger a running of the query upon auto-refresh. This will force the query to re-display form page 1 & show all of the newly filtered results properly.

I have not tested the new functionality yet, but that was one of the intents.

hpl123

Aha, OK I understand. Thanks Tom.

Rennur

Projects query is set up to search for results by entering a project number via a BO form.
Form pops up for you to enter the Project number.

BO search form

Query to use this BO form

Undesired result

Cheers