Reference to a Tab

Hi people!

Thanks for your interest.

I mean at Site Tabs. I need to launch a SAIL that it go to DDBB and update/insert/delete a row/s, when I push a Site Tab. This is the functionality. It doesn't help me to put a button on the other layout, or something like this. I need the "action" start when push the Site Tab. if this is not possible, it would be to look for a different approach.

Greetings.

Hi people!

Thanks for your interest.

I mean at Site Tabs. I need to launch a SAIL that it go to DDBB and update/insert/delete a row/s, when I push a Site Tab. This is the functionality. It doesn't help me to put a button on the other layout, or something like this. I need the "action" start when push the Site Tab. if this is not possible, it would be to look for a different approach.

Greetings.

As far as I know, this is not possible without some further user interaction.  Clicking into a site tab would be limited to loading a Report SAIL form or a process start SAIL form, but these will never do any database updates or other operations without at least a button click or certain other user actions.

As Mike said, you wouldn't be able to perform an action just by pushing a site tab. However, if you just want to capture somewhere which tabs have been selected, every navigation to any site tab is logged in the sites_usage log (including which user and which tab).

I'm also curious if there might be another way to meet your requirements without explicitly logging data. Can you explain what user behavior you are looking for? Are you expecting to remember some data from the previous tab to display on your new tab?

So...it IS possible BUT there are some significant caveats/cautions. You could set up something like the following:

• Every Tab would need to display a SAIL interface (i.e. ALL tabs would need to be implemented using a Report object (which contains a SAIL interface).
• Each SAIL interface would need to call a Stored Procedure upon loading, passing it the data you want stored
• The SP catches the data you send to it and writes it to the database

(This 'works' - I know, I've tried it out!)...BUT HERE IS THE CAUTION:

https://docs.appian.com/suite/help/19.4/Expressions.html#functions-and-side-effects

Essentially this says unless you use an Appian Smart Service it cannot be guaranteed that you'll get a true transactional (ACID test) outcome. Using the executestoredprocedure() function falls into this non-guaranteed category.