baddogi
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by baddogi
-
-
In Creator, I am trying to pull data from a view in SQL. It works in SQL but not in PowerGadgets? I'm just wondering if this is supported?
Thanks,
Does Creator Allow Queries From SQL Views?
in PowerGadgets Support
Posted
Here is some sample code, it's pulling from a view. When I run it in SQL it returns the correct results but in powergadgets it returns 5000 and some results?
SELECT
[Ticket Number]
,[status]
,[Company Name]
,[site]
,[summary]
,[detail]
FROM [companyname].[dbo].[v_table1]
where [status]='assigned'