# How to setup a db view

**URL:** <http://discourse.egroupware.org/t/how-to-setup-a-db-view/38713>\
**Category:** eGW-developers\
**Created:** [May 17, 2010, 9:39pm UTC](http://discourse.egroupware.org/t/how-to-setup-a-db-view/38713 "2010-05-17T21:39:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nick1234s](http://discourse.egroupware.org/letter_avatar_proxy/v4/letter/n/dec6dc/32.png) [@nick1234s](http://discourse.egroupware.org/u/nick1234s)\
**Post date:** [May 17, 2010, 9:39pm UTC](http://discourse.egroupware.org/t/how-to-setup-a-db-view/38713/1 "2010-05-17T21:39:50Z")

</div>

Hello,

does anybody know a way to setup a database view in an egw application?

I know how to create or update a table and how to execute queries, but not how to create a view.

Any suggestions or ideas?

thanks

Nicholas

---

<div class="post-metadata">

**Author:** ![Ralf\_Becker\_Stylite](http://discourse.egroupware.org/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@Ralf\_Becker\_Stylite](http://discourse.egroupware.org/u/Ralf_Becker_Stylite)\
**Post date:** [May 18, 2010, 7:27am UTC](http://discourse.egroupware.org/t/how-to-setup-a-db-view/38713/2 "2010-05-18T07:27:39Z")

</div>

Hi Nicholas,

this is NOT yet covered by EGroupware’s database abstraction.

Once you created it, you can add it to tables\_current, like a table, and  
it should be usable.

Ralf

> Hello,
> 
> does anybody know a way to setup a database view in an egw application?
> 
> I know how to create or update a table and how to execute queries, but not  
> how to create a view.
> 
> Any suggestions or ideas?
> 
> thanks
> 
> Nicholas

–  
Ralf Becker  
Director Software Development

Stylite GmbH  
[open style of IT]

Morschheimer Strasse 15  
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0  
fax +49 (0) 6352 70629-30  
mailto: [rb@stylite.de](mailto:rb@stylite.de)

[www.stylite.de](http://www.stylite.de)  
[www.egroupware.org](http://www.egroupware.org)

* * *

Geschäftsführer Andre Keller,  
Gudrun Müller, Ralf Becker  
Registergericht Kaiserslautern HRB 30575  
Umsatzsteuer-Id / VAT-Id: DE214280951

* * *

* * *

eGroupWare-developers mailing list  
[eGroupWare-developers@lists.sourceforge.net](mailto:eGroupWare-developers@lists.sourceforge.net)  
[https://lists.sourceforge.net/lists/listinfo/egroupware-developers](https://lists.sourceforge.net/lists/listinfo/egroupware-developers)