Syncing on a veiw? RRS feed

  • Question

  • Is it possible to set your select commands when syncing to be performed against a view.  I have some custom filtering based on joins that im not sure i can replicate with command parameters  that restrict data based on a users Active Directory Group.  If this is not possible what would be my solution.

    Here is an example of a view.

    SELECT     sfd.shock_file_id, sfd.field, sfd.value, sfd.shock_file_data_id, sfd.[order]
                          dbo.SHOCK_FILE AS sf ON sf.shock_file_id = sfd.shock_file_id LEFT OUTER JOIN
                          dbo.SHOCK AS ss ON sf.shock_id = ss.shock_id LEFT OUTER JOIN
                          dbo.TEAM AS t ON ss.team_id = t.team_id LEFT OUTER JOIN
                          dbo.SERIES AS s ON t.series_id = s.series_id
    WHERE     (IS_MEMBER('DOMAIN\SERIES_' + s.name) = 1)

    Friday, July 30, 2010 2:55 PM

All replies

  • which provider are you using? afaik, sync on views is not supported. But as you stated above, you can tweak the SQL commands.
    Friday, July 30, 2010 3:12 PM
  • What providers can I use to do this?


    Friday, July 30, 2010 3:27 PM
  • it's easier to do on the offline providers. what's the client db?

    Friday, July 30, 2010 10:52 PM