Skip to main content

Dear Expert,

 

I have to read the data from SmartObject on the form initilaization.

 

I am able to load when I am passing Primary Key in Input, but I want to load the data rather than Primary Key.

 

For example I have employee infromation table called emp_details where emp_id is the primary key .

 

But in this table there are other columns called national_id and nationality.

 

I want to load data by passing both national_id and nationality as  input..

 

like:  select * from emp_details where national_id='4645645' and nationality='UK'

 

Is it possible with smart object load method ?

 

Please help me to achieve this functionality.

 

Regards

Shah

Hi,

 

I believe you are using Smartbox smartobject and you don't have the list method which allows you to pass multiple parameters or filter.

 

I would suggest to use advanced smartobject or create stored procedure.

this is not possible using the load method.

 

 


Reply