Products

Solutions

Learn More

Partners

Community

Blog

About

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsModulesModulesDAL 2 Query HelpDAL 2 Query Help
Previous
 
Next
New Post
5/14/2014 5:16 PM
 

I have created a custom events module that has tags for events and the ability to filter by tags. I have the code for that working just fine. What I am getting hung up on is filtering by multiple tags. See my code below:

public IEnumerable<Event> ListEventsByMultipleTags(string tags)

    {

        IEnumerable<Event> t;

        using (IDataContext ctx = DataContext.Instance())

        {

            EventListController elc = new EventListController();

            t = ctx.ExecuteQuery<Event>(CommandType.Text, "WHERE PortalID = @0 AND EventId IN (SELECT EventId FROM [Events_EventTag] WHERE TagId IN (@1)) AND EndDate >= @2", 0, issue, DateTime.Today).ToList();

        }

        return t;

    }

The string tags is a comma delimited string of tag ids, which is the basis for the filter WHERE TagId IN (@1) . I haven't seen any good examples to follow for this type of selection. It's probably easy, and I'm just missing it. Essentially the sql should be like WHERE TagID in(1,2,3)


Risdall Marketing Group
erik hinds
risdall marketing group
#1 Web Design Agency in the World
 
New Post
5/14/2014 6:20 PM
 
petapoco (the underlying engine for dal2) has some issues with syntax that contains @ - there are a few common workarounds, see http://stackoverflow.com/questions/69... for examples

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
5/15/2014 9:47 AM
 
Thanks for the pointer, Cathal. Is there a way to show the SQL that is generated by petapoco for debugging purposes?

Risdall Marketing Group
erik hinds
risdall marketing group
#1 Web Design Agency in the World
 
New Post
5/19/2014 7:18 AM
 
I would have sworn there was a way, but I just had a quick look and can't see any method to echo the sql back from a buffer, or any logging. You could add this as a suggestion to community voice and see if others feel it would be worth the platform team adding some support for this (personally I could see this integrating nicely with DNN Glimpse)

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
5/19/2014 7:32 AM
 
note: I'm sure you know this but you can of course just use sql profiler and see what sql is being executed.

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsModulesModulesDAL 2 Query HelpDAL 2 Query Help


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW