Export data

derricksmitn · 2017-02-28T12:06:46.000Z

I have (2) departments which are Building & Grounds and Line Shop. How do I export out just the data pertaining to a separate department?

Thanks

Derrick

jrammalaere · 2017-02-28T12:30:30.000Z

You will likely need to provide more information in order to receive good advice. What application are you using? What kind of database is it? Do you have access to the database?

weirdfish · 2017-02-28T15:46:11.000Z

Please rephrase your question and provide pertinent details.

https://community.spiceworks.com/how_to/74547-how-to-ask-a-good-question-and-how-to-give-good-answers

Asking Better Questions Best Practices & General IT

Over the years of reading questions on SpiceWorks, I’ve come to the conclusion that there are a few simple ways that nearly all of us could get better answers, better advice, more information by changing how we ask questions. Here are some tips that I’ve learned (this is not about break/fix questions but about guidance questions…) Always give the business background. No IT choice is made outside of a business context, so provide us with the drives on the decision. Need product type X? Do you …

toodamax · 2017-03-05T13:25:15.000Z

If it is SQL or SQL based, use this - change dept to whatever the field is actually named and tablename to the actual table name LOL

Select * from tablename where dept = ‘Line Shop’

or

Select * from tablename where dept = ‘Building & Grounds’

Field names need to be precise

If not SQL, more info is needed

derricksmitn · 2017-03-10T19:13:12.000Z

I got it resolved. Thanks