Hi,

Trying to get a template to only show records relating to logged in user.

Have a column in the table called userid.

here is my template that is not retruning anything despite there being a couple of records in the table.

<ListDataSource CommandText="SELECT [id], [Name], [Category], [SubCategory], [Supplier], [PurchaseDate], [Image1] FROM tablev5 where [UserID] = UserID">
<Parameter name="UserID" value='[[User:ID]]'/>
</ListDataSource>

Thanks in advance