Extending Member Service to find Members by Created Date
Hello,
I'm looking for a way to get a list of members who have been created after a certain period of time. Sadly I cant use the GetAll method and then filter as the db has well over 30,000 members, other options included using the GetMembersByPropertyValue but the created date is not a property value I believe I can filter on.
Wondering if you might be better doing a database query for this on the cmsMember table, join on umbracoNode and you can query by the createDate field, then if you do need full members get the Ids from the database and pass to GetllMembers().
Doh did not know that. I guess you could create your own indexer and use the sql query idea andy posted and index that way, more work but it will be lightening quick but if sql is speed wise adequate then stick with what works.
Extending Member Service to find Members by Created Date
Hello,
I'm looking for a way to get a list of members who have been created after a certain period of time. Sadly I cant use the GetAll method and then filter as the db has well over 30,000 members, other options included using the GetMembersByPropertyValue but the created date is not a property value I believe I can filter on.
Does anyone know a way that I can extend upon the methods available in the MemberService to build this query https://github.com/umbraco/Umbraco-CMS/blob/b35397b4642f6a715335fad508c7072fdd37dc5e/src/Umbraco.Core/Services/MemberService.cs
Any help would be much appreciated
John
Wondering if you might be better doing a database query for this on the cmsMember table, join on umbracoNode and you can query by the createDate field, then if you do need full members get the Ids from the database and pass to GetllMembers().
Ah OK, cheers Andy will give that a go using the db context then pass that array of members ids to the GetAllMembers.
That did the job thanks Andy
Guys,
Examine cough cough
Regards
Ismail
Ha, if only Ismail http://issues.umbraco.org/issue/U4-5425
Doh did not know that. I guess you could create your own indexer and use the sql query idea andy posted and index that way, more work but it will be lightening quick but if sql is speed wise adequate then stick with what works.
Regards
Ismail
No speed wise it's fine for a one off process, thanks though mate.
Im on a problem as this can I aske how you did this ? :D
is working on a reply...