Query to a relation

Classic Servoy
1

Hi,

Is it possible to query a relation like querying a table?

Is there some constructs in servoy like view in Oracle?

Thanks
Som

2

If you have views in your database, you can use them in Servoy just like tables. The only disadvantage is that the database doesn’t tell Servoy what SQL is used to create the view, so Servoy can’t recreate the view after a new import, you have to recreate them in your db yourself.

Relations can’t be queried like tables, but you can do a lot of operations on a relation. If you select a relation under one of your forms, you’ll get a list of all that functions.
Can you be more precise in what you want to do? Because we can probably point you in the right direction.

3

Thanks Joas,

I am doing lot of joins inside my code. I thought if I can query a relation then job will be easier. There are multiple table and multiple queries. Based on output of first query second query builds up, based on output of second query third query builds up etc. I am not showing the output in text boxes from relations or tables;rather building the output and displaying as HTML. I know the views look like tables , I was thinking if I can create something like view in servoy rather in database.

Som