Load the table based on field selection

[jeevays7]

Hi All,

1.     I have a field("TABLE")  which contains all the table name from Database.

Now i am selecting a table name from the field("TABLE") , and reload the the document using button click.

so i need to fetch all the data for the selected Table name only from ("TABLE") field.

How can we achieve this?

2.     Can we update one table and not others while reload the document ?

[shiveshsingh]

1.Make a variable and store the value of that Field in that variable(on selection)

then use it in your reload script like ..load * from $(Variable)

2. You can use partial reload for this.

[jeevays7]

Thanks for your reply Shivesh,

I tried the first one. but it is not working. can you share sample file?

[shiveshsingh]

on your button, set below action

1.Set variable_name = getfieldselections(FieldName)

2.Reload

What error are you getting? can you share your app?

[jeevays7]

Hi Shivesh,

When i am using the variable(variable_name) in where clause, it is showing the variable value

as "getfieldselections(FieldName)". so it is not working.

[stabben23]

Create a dropdown list With like this, then use '$(vFilter)' in where clause

[stabben23]

You could also create a variable vreloadAll which helps you to load all tables again if needed.

So if vreloadAll is Yes all tables will be loaded again and you could Select another table to load.

if '$(vreloadAll)' ='Yes' then
Select *
FROM
Database
;
else
Select *
FROM
Database
where TABLE= '$(vFilter)'
;