I'm wondering if there is a list of all the different "FieldName"s for creating Custom Reports and/or adding additional filters to existing reports?
Specifically, we're looking for a list of Item attributes to filter by.
For example, HQ does not have a filter in any of it's report for whether an item is a Web Item or not so I added:
Begin Column
FieldName = "Item.WebItem"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Web Item"
VBDataType = vbBoolean
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1000
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
to one of our reports
Sometimes, it takes a lot of trial and error to come up with the right naming (item.WebItem) and I'm thinking a lot of you guys would just have a list including the different options
We've got the customization guide and it's been a great resource to learn the thought behind this stuff but it's incomplete.
Thanks,
Devon
*This post is locked for comments
i agree that Customization guide is just an intial stage for us to proceed with customziation. by the time we start we learn more!! as suggested you can use "select * from tabl" or you can also use sp_help "tablename' this help you to get the information.
But how do we know which field link to what, one way I use is sql profiler tool this is helpfull when I do transaction I monitor what is happening and by profiler I get the correct field name. Again it require some technical skills. You can always ask question related to your queires and we are here to help you solve your issue. Best of luck.
Hi Devon,
If you run a Query in either HQ or Store Operation Administrator on item you will see the column headers and these are the names you are looking for. (Select * from item) will produce everything in the items table. The column Headers are the right Naming - Microsoft's WYSIWYG (What You Yee Is What You Get)
Hope this helps you
Shawn
Hi Devon -
Another option to find out tables and views in your database,
sp_tables
Or to look at columns in a table, including data about the data like data types, ie in the item table
sp_columns item
Thank you. Is this a new program I have to get or can be ran within RMS? I am new to SQL, so my knowledge is very limited. Thank you for your respose!
Run SQL Queries. I prefer using SQL Management Studio
1. Show all tables for a database
use databasename
select *
from sys.tables;
2. Show all column/rows for a table
use databasename
select *
from tablename;
Did you ever find an answer? I am looking for the same. Thanks!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156