We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Refresh table content when no data found from service connection

Received Response
7
Views
3
Comments
edited Oct 1, 2020 1:55AM in Visual Builder 3 comments

Content

I have made a service connection through OIC that connected a DB to run a SQL to get result.

And made some parameters to filter the data.

In VBCS, I created inputText accosiated with the parameters to get the result like [select * from table where columnA = parameterA]....

When I input some parameters that result had sevral lines returned from OIC, there is no problem.

But, when I input some wrong value into the parameter and no data had found from OIC, last query result remained in the table.

When I set the default value to the inputText(with the default value, no data can be retrived from OIC), [No data to Display.] can be shown in the table.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!