portal record loading using sql

Classic Servoy
1

Is there way to load records in a portal using a SQL?

It would be nice to have a property called SQL for portals.

Thanks!

2

Why can't you use form in tabpanel?

3

Or you could play with the datagrid bean...

4

I can use a tab panel. But I am a bit reluctant to create a number of forms.

I can try using datagrid bean. Where can I get it?

OR

How can I create a relation to use with the portal which would do the same as the following SQL:

SELECT a.contact_code, a.name FROM contact a, result b
WHERE a.contact_code = b.contact_code
AND a.contact_code = 100 AND (b.result = 'PS' OR b.result = 'DT' OR b.result = 'CR')

5

The datagrid bean is part of Servoy 3. You can "drop" any dataset on it. It is just currently a bit "beta"...

6

I could not find the "datagrid" bean in the bean list.

Is that named differently? If yes can you please tell me what's it?

Is there documentation for it?

Thanks a lot.

7

It seems that Servoy does not deliver this yet. But you can get it here:

http://forum.servoy.com/viewtopic.php?t=6434

8

thanks. I will try that out.

9

Actually I need to use the portal fields in find mode. So I could not use the the datagrid bean (also I do not like the look and feel of it).

Is there a way to use 'OR' condition in relations so that I could use the related portal fields in the find mode or is there a work around?

I remember Filemaker allows 'OR' conditions by return separating the values in the key field.

Thanks