I have the basic functionality enabled to only allow the user who created the row to see/edit the row.
I would like to extend this to include a Profile Property in the "WHERE" clause.
For instance: WHERE 'FieldValue'=$NameOfCurrentUser or 'FieldValue'=$AccountNumber or $IsAdministrator
Here's my working code:
<xsl:variable name="NameOfCurrentUser" select="udt:Context/udt:UserName" />
<xsl:variable name="IsAdministrator" select="udt:Context/udt:IsAdministratorRole='true'" />
<xsl:variable name="currentData" select="udt:Data[*['FieldValue']=$NameOfCurrentUser or $IsAdministrator]" />
What I am looking for:
<xsl:variable name="NameOfCurrentUser" select="udt:Context/udt:UserName" />
<xsl:variable name="AccountNumber" select="udt:Context/udt:[Profile:AccountNumber]" />
<xsl:variable name="IsAdministrator" select="udt:Context/udt:IsAdministratorRole='true'" />
<xsl:variable name="currentData" select="udt:Data[*['FieldValue']=$NameOfCurrentUser or $IsAdministrator]" />
Reason: I need more than one DNN Account to be able to create rows, but allow all accounts with the same Custom AccountNumber to see rows for that AccountNumber.
Thanks!