tag:blogger.com,1999:blog-5285970135510371565.post2510761422280833473..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: Changing SQL Server views for SmartList Builder smartlistsMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5285970135510371565.post-48777270471062259642011-09-30T13:47:54.337-04:002011-09-30T13:47:54.337-04:00Mariano
I was wondering if there was any way to t...Mariano<br /><br />I was wondering if there was any way to tell what tables are feeding the smartlists in GP. We do not have builder becuase I work for really cheap people. So what they do is create a smartlist then want me to reverse engineer it and build a view. So i was hoping to find out what tables are avalable in to smartlist-invnetory-item quantitys.<br /><br />thanks<br />Vic<br /><br />Thanks<br />VicVegasvic 21https://www.blogger.com/profile/01264290656395072160noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-6346496464117045922011-08-26T08:22:00.161-04:002011-08-26T08:22:00.161-04:00@BSmith,
If I understand correctly, your view incl...@BSmith,<br />If I understand correctly, your view includes the DEX_ROW_TS column and SmartList is not doing the correct conversion on the date.<br /><br />Try this in your view:<br />CONVERT(datetime, CONVERT(varchar(20), DEX_ROW_TS, 101)) AS DEX_ROW_TSMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-39866429062603364512011-08-23T15:40:52.516-04:002011-08-23T15:40:52.516-04:00Mariano,
I have created a Smartlist in SB which u...Mariano,<br /><br />I have created a Smartlist in SB which uses a SQL Table (which I learned how to do from another post of yours in KB, thank you very much!) but now have encountered a problem. My Smartlist works just fine until I attempt to "Search" in Smartlist using parameters restricting a specific column from the SQL table. The data in the column happens to be Date/Time information. (For example: DEX_ROW_TS is equal to 7/29/2011.)Of course, SQL is returning the number of days from 1/1/1900 and simply displaying that number as a date. When users actually enter a date in the Search parameters, there are no records returned since there parameters would exclude that string of numerals. Any thoughts on how to convert the SQL data from that column into a Smartlist searchable Date? Your help is often used and much appreciated!BSmithnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-41550804723756608192009-02-24T15:10:00.000-05:002009-02-24T15:10:00.000-05:00Mariano,A big thank you for showing me the way for...Mariano,<BR/><BR/>A big thank you for showing me the way for building complex Smartlist. I never had to dig into SL based on SQL views and your post has been very helpfull.<BR/><BR/>JulienAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-69027312337963443302009-01-23T12:17:00.000-05:002009-01-23T12:17:00.000-05:00You are welcome Victoria! The purpose of the artic...You are welcome Victoria! The purpose of the article is to ensure these little "mistery" pieces of functionality are captured somewhere and that the community can benefit from it.<BR/><BR/>Thanks for the input! :-)<BR/><BR/>MG.-<BR/>Mariano Gomez, MVP.Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-87569411429681537602009-01-23T08:18:00.000-05:002009-01-23T08:18:00.000-05:00Mariano,Thank you so much for documenting this - v...Mariano,<BR/>Thank you so much for documenting this - very useful to have this as a reference.<BR/>-VictoriaAnonymousnoreply@blogger.com