Avoiding intitial select in a table

[Former Member]

Hi experts ,

This is regarding avoiding intitial select in a table

I have a table whose row is selected after a user clicks on any row in the table and submitted to another query .

I have avoided initial select using gaurd condition and a data store element( Gaurd condition-selectnumb>0, Datastore element- Selelctnumb=store@selectnumb+1) for submitting the row of table to query.

I have done the above setting as per the wiki at visual composer in SDN

But when i execute the report for first time by entering some input fields in the variable form of iview , it is working fine .But when i rerun the same the iview ...with different selection fields in the variable form of iview....the gaurd condition is not working and it is directly picking up the first row from the table.

I have found that the value for the first time in selectnumb is zero.But the value for selectnumb is 1 after first time running of report.this satisfies the gaurd condition and hence it is running the report with out selecting the row from table.( Here initial select is not avoided).

Can anyone please let me know how to clear the value of data store element selectnumb and make it zero everytime user submits the variable form.

Thanks

P.Navakanth

[Former Member · Accepted solution]

Hi Navakanth,

Connect a data store to the form and set the field to 0 when the select event executes.

Hope this helps.

Aaron