1 Reply Latest reply on Mar 22, 2015 10:49 AM by bluefunelemental

    Where do custom query resources store the entered SWQL code? Inetpub or DB?

    bluefunelemental

      for source control

        • Re: Where do custom query resources store the entered SWQL code? Inetpub or DB?
          bluefunelemental

          Found them in the Select * FROM [dbname].dbo.ResourceProperties WHERE PropertyName = 'SWQL'

          and used this SQL to  collate them

           

          SELECT TOP 1000 r.[ResourceID]

                ,r.[ViewID]

                ,'/Orion/SummaryView.aspx?ViewID=' + CONVERT(varchar,r.viewID) AS [DetailsURL]

                ,r.[ViewColumn]

                ,r.[Position]

                ,r.[ResourceName]

                --,[ResourceFile]

                ,r.[ResourceTitle]

                ,r.[ResourceSubTitle]

                ,rp.PropertyName

                ,rp.PropertyValue

            FROM [Orion].[dbo].[Resources] r

            inner join [Orion].[dbo].[ResourceProperties] rp on r.ResourceID=rp.ResourceID

            where rp.PropertyName = 'SWQL'

            order by ViewID,ViewColumn,Position