Running a process using a cell on query

tford

I have a room reservation system that is a fairly complicated VP of various queries. In the screen shot below, the columns below IMC East --> Tech Lab are 5 different queries. If you click on a green area of one of these query cells, it makes an appointment in that cell. If you click on a red cell, it asks if you would like to cancel the appointment for that cell. This is all accomplished by default processes.

For efficiency sake, I would love to have one query instead of 5 to accomplish this. To do that would require either a Custom Presentation (which I experimented with and found to be lacking) or to have the ability for AwareIM to know which cell on a query line was clicked when executing the default process.

Does anyone know a way to accomplish this that perhaps I have missed?

BLOMASKY

I "believe" the only way you can do that, is with a custom query and have an "a href...." on the cell.

Good Luck.

Bruce

johntalbott

With a little JS & jQuery, you can get it done. The below will NOT work exactly as is, but hopefully will get you close enough to work through it.

Find row index and column index for the clicked cell.
Find the data item associated with row to grab the attributes you need.
Call the AIM process

The code below (taken from http://jsfiddle.net/OnaBai/MuDX7/) demonstrates #1 and #2.

$(grid.tbody).on("click", "td", function (e) {
    var row = $(this).closest("tr");
    var rowIdx = $("tr", grid.tbody).index(row);
    var colIdx = $("td", row).index(this);
    var item = grid.dataItem(row);
    var id = item.Id;
    alert("row:" + rowIdx + " col:" + colIdx + " id:" + id + "\nitem:" + JSON.stringify(item, null, 4));
});

For #3, you would add something like AwareApp.startProcess WithInit(‘MyProcess’, ’main’,’MyObject’,’At tr1=Value1@Attr2=Valu e2@…” to the above function. See page 456 of user guide.

All of this would go in the Render Script of the query.

DeFactoSA

@[deleted]

Tom - I am trying to achieve something you already have - triggering a process from a cell in a query... have tried all sorts. Would you mind sharing how you achieved that?

Thanks!

tford

Helen,

I have not tackled this yet, but will be doing a Proof of Concept on John's post soon. When I do that proof of concept, I'll post it to Tips and Tips and cross post it here.