# Retrieve all informations from a given Servoy relation

**URL:** <https://forum.servoy.com/t/retrieve-all-informations-from-a-given-servoy-relation/7581>\
**Category:** Classic Servoy\
**Created:** [May 29, 2007, 4:24pm UTC](https://forum.servoy.com/t/retrieve-all-informations-from-a-given-servoy-relation/7581 "2007-05-29T16:24:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [May 29, 2007, 4:24pm UTC](https://forum.servoy.com/t/retrieve-all-informations-from-a-given-servoy-relation/7581/1 "2007-05-29T16:24:39Z")

</div>

Hi,

Patrick and I, would like the following feature :

Being able to ask servoy all the relevant information of a given servoy relation, so I’d be able to rewrite it in SQL.

I reproduce patrick’s wording of the feature needed :

> Vince wants to know from a relation
> 
> 1. the two tables involved
> 2. the field matching used
> 
> As far as I see that, only question 1 can be answered with Servoy 3.5. In 3.5 you should be able to do
> 
> some\_relation.getServerName()  
> some\_relation.getTableName()
> 
> So you can figure out the right side of the relation. But what is missing is something like
> 
> some\_relation.getFieldMapping()
> 
> that could return something like
> 
> [leftField][operator][rightField]
> 
> I can imagine useful application for this kind of thing.

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [May 29, 2007, 4:40pm UTC](https://forum.servoy.com/t/retrieve-all-informations-from-a-given-servoy-relation/7581/2 "2007-05-29T16:40:52Z")

</div>

I suggest you also post this in the [bugbase](http://crm.servoy.com/servoy-webclient/solutions/solution/servoy_support) so it’s logged.  
(yes also feature requests are logged in the bugbase ![;)]( "Wink") )

---

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [May 29, 2007, 4:50pm UTC](https://forum.servoy.com/t/retrieve-all-informations-from-a-given-servoy-relation/7581/3 "2007-05-29T16:50:45Z")

</div>

Ok logged
