How to display a user by SQL Queries

[hyzx86]

I was create a user extension module .
Use sql query and liquid to display custom property on page.

SQL Query（with out "return document" option）

select Content FROM Document d
inner join   UserIndex u on d.Id=u.DocumentId 
where d.Type='OrchardCore.Users.Models.User, OrchardCore.Users.Core'

Liquid

{% assign users = Queries.AllUsers | query %}
<ul>
{% for item in users %}
 <li>{{  item.Content   }}</li>
{% endfor %}
 </ul>

Page response:

{"Id":61,"UserName":"admin","NormalizedUserName":"ADMIN","Email":"[email protected]","NormalizedEmail":"[email protected]","PasswordHash":"xxxx==","SecurityStamp":"xxxx","EmailConfirmed":false,"ResetToken":null,"RoleNames":["Administrator"],"LoginInfos":[],"Properties":{"JZUserInfo":{"RealName":"张三"}}}

How to only display RealName field.

Thanks.

[sebastienros]

{{ item.Content.Properties.JZUserInfo.RealName }}

[hyzx86]

Thanks ，but there is nothing to display..

[sebastienros]

It might be that the Properties parameter is not allowed in liquid. I will test that.

[hyzx86]

@sebastienros
Thanks,
Here is the source soce of the custom module
https://github.com/hyzx86/OrchardCore/blob/142f9bc986b3bc19f837e9e822272f74ebab4e9c/UserExtInfoSrc/JZUserExtensions.OrchardCore/Service/JZUserInfoService.cs#L75