44
Views
11
Comments
Accessing data in the database
Question

In an application can we access the entire data in the database using an attribute in the database other than the primary key.

mvp_badge
MVP
Rank: #129

Hi,

Yes, you can apply a filter using Aggregate/Advanced SQL on the column which identified the row uniquely(If you need a unique row), otherwise, it will return all the records matched with filter value.

Thanks.

Rank: #388

Hi, friend!

What de you mean with 'entire data'?

Are you using aggregate or advanced SQL widget?


Rank: #90

Its depend on you which attribute you want on filter but mainly use primary key to find data because it return single data and if you use other attribute you can get more than one row.

If you want all data than dont use filter and if you want data with similar name than use filter by this attribute

like i have customer table where attribute is - ID,NAME,Address,Mobile

and if you want data of all Cutomer whose name is like Jhon

than use condition in filter

Customer.NAME like "%Jhon%" or Customer.NAME="Jhon"


Regards

Rahul Sahu

Rank: #388

Ok. 

The aggregate is optimized to fetch all attributes from the table. There are many ways to filter the data, not only the Id.

If you need to use only one or two attributes, the best way is the advanced SQL.

Rank: #388

Hi, friend!

Was that helpful? If the issue is solved, please mark the answer as solution!


Best regards

Hi,

I would like to add this information: Using SQL to access data

Cheers