Query an External Database

(0) Share

Report

Posted on by EazyDynamics

Hello, I have established a connection with an external SQL database and setup a table and a page to read from the table located in the said database. I am successfully receiving all the record but I want to filter them based on a field. I can filter them once I have received all the records but is there any way that it only fetches the records that I want on the first time around.

Table:

Page:

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DAnny3211 11,397 on at

Like (1)

Report

Hi

This way you cannot retrieve the records you need, but you can apply code filters on the page, in the onopenpage for example:

rec.setfilter(Yourfield,'XXXX');

DANiele

Was this reply helpful? Yes No
EazyDynamics 33 on at

Like (0)

Report

Thank you so much, I appreciate your response

Was this reply helpful? Yes No