Question: Does anyone know of any tutorials for coding autolayout in Swift? Usually I'd try using an Objective-C one but there is code that doesn't seem to be convertible to Swift. Basically I want a banner which slides in to the view from the bottom of the navigation bar, shrinking down a UITextView which is usually in place. It's astonishing that Apple offers no example of how to integrate an iAD banner correctly in Swift. I've been messing about for two days now and I'm getting nowhere.

EDIT: I am attaching a screen shot because I'm not sure I've explained clearly enough what it is I am trying to do. Notice that when the banner is displayed the UITextView is covered by the iAd banner view. I have absolutely no idea using AutoLayout how to remove the constraint binding the UITextView to the bottom of the Navigation Bar and instead apply a constraint to bind it to the bottom of the iAdBannerView. 

![enter image description here](https://i.stack.imgur.com/SHCaD.png)

Answer: 
You could jump on the edge and then you have in/out with Identity and User reference and then make the projection like this

```
select  out.emailAddress, out.firstName, out.lastName from (SELECT expand(inE()) from Identity where email="abcd@temp.com")

```
As an alternative, this select statement lets you select properties from both User and Identity.

* FROM clause, points to the edge (sitting between User and Identity)
* SELECT outV('User').property, points to start-node User, going out to edge
* SELECT inV('Identity').property, points ending node Identity, coming in from edge

In the SELECT clause you can fetch any property by prefixing it with **outV('User').** property and/or **inV('Identity')**.property.

In the WHERE clause you can search on any property by prefixing it with **outV('User').** property and/or **inV('Identity')**.property.

```
SELECT 
outV('User').firstName as name,
inV('Identity').email as email, 
somePropertyFromEdgeName as prop
FROM EdgeName //name of the edge between User and Identity
WHERE outV('User').firstName = 'John'
or inV(Identity').email = '...' 
// etc....
ORDER BY email asc, prop desc

```