I need to know if there is any way to keep a table selection for multiple report/Plugin calls and after a fecthTableData. Users need to validate table input based on a text field. Table use a report with this text as an input and then select the correct row, but There is a need to do it several times While creating the catalog request.
Unfortunately, after text field change, table is updated but selection is lost.
Is there another way to do what is described?
Here some screenshots...
Here is where selection is lost after AddUserId Field change...
Thanks for your suggestions.
Good Morning John.
An option could be to create 'hidden=true' and 'disabled=true' fields on the form.
Which get populated with the content of the selected row.
And then used to -repopulate the fields when needed.
Thanks and kind regards, Louis van Amelsfort.
You can have a second table and on every selection on the first table you use ca_fdGetSelectedTableRows and then add it to the second table with ca_fdAddTableRow
Do you know how I refer to the data in the original table to send them to the second table?
Is there any format to access the value of a column?
Look in the form designer API.
You will need a function that gathers the selected rows in the first table then write them to the second table.
You should call this function just before refreshing the data when the user change the search criteria in your textbox
So onChange of AddUserID, you should call a function that does :
get selected rows of table 1
add these rows to table 2
fetch data for table 1 based on AddUserID