Epicor 9.04 Progress DB - how to browse table data?

Yahoo Archive
1

I will email you a snippet off list.





On Thu, Mar 24, 2016 at 10:59 AM, clive.gillett@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>I need to analyze our job changes to see what kind of changes are happening and by who.<div><br></div><p></p>

<p></p></div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>



--

Sarah Vareschi ▪ Systems ManagerÂ

Â

NyproMold, Inc.

144 Pleasant St, Clinton, MA 01510 ▪ www.nypromold.com Â

D 978.368.4718Â â–ª F 978.365.4548

Â

Â

Â

This e-mail may contain information which is
confidential or privileged. The information is intended to be for the use of
the individual or entity named above. If you are not the intended
recipient, be aware that any disclosure, copying, distribution or use of the
contents of this e-mail is prohibited. In the event of any error in
transmission, unauthorized recipients are requested to contact the sender
immediately and not to disclose or make use of this information. No
employee or agent is authorized to conclude any binding agreement on behalf of
NyproMold with another party by email without express written confirmation by
NyproMold Offices.

P Please consider the environmental impact of
printing this e-mail.

2
I am looking for a way to view a small subset of data in a Progress database table.
Being used to SQL I could just return the top 50 records so I can see a sampling of the data that resides in that table. I am not sure how to accomplish this in Progress.
Does anyone have some suggestions?

Thanks

3

If using BAQs, You will have to look at the index and select a small sampling yourself with a filter added to the BAQ such as just show todays labor from labor transactions.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 22, 2016 09:35
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.04 Progress DB - how to browse table data?

 

 

I am looking for a way to view a small subset of data in a Progress database table.

Being used to SQL I could just return the top 50 records so I can see a sampling of the data that resides in that table. I am not sure how to accomplish this in Progress.

Does anyone have some suggestions?

 

Thanks

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.   ­­  
4
Thanks Patrick.

I am trying to analyze the amount of changes that occur using the ChgLog table and I am not familiar with what data is getting stored in the columns.
You did however give me an idea to use the DateStamp field as a filter with just yesterdays date but the query is not responding. I am not even sure how the date is stored in that field.
5
You could look at the data dictionary viewer as a starting point. I have a BAQ on the EmpBasic table linked to chglog table.Â

ChangeLog has a filter "TableName" = EmpBasic constant

The join is company to company and EmpBasic.EmpID -> ChgLog Key1Â (depending on the change log table more keys would be in use)

For our purposes on this BAQ we only return from the ChgLog DateStamp and LogText.






On Tue, Mar 22, 2016 at 12:00 PM, clive.gillett@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Thanks Patrick.<div><br></div><div>I am trying to analyze the amount of changes that occur using the ChgLog table and I am not familiar with what data is getting stored in the columns.</div><div>You did however give me an idea to use the DateStamp field as a filter with just yesterdays date but the query is not responding. I am not even sure how the date is stored in that field.</div><p></p>

</div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>



--

Sarah Vareschi ▪ Systems ManagerÂ

Â

NyproMold, Inc.

144 Pleasant St, Clinton, MA 01510 ▪ www.nypromold.com Â

D 978.368.4718Â â–ª F 978.365.4548

Â

Â

Â

This e-mail may contain information which is
confidential or privileged. The information is intended to be for the use of
the individual or entity named above. If you are not the intended
recipient, be aware that any disclosure, copying, distribution or use of the
contents of this e-mail is prohibited. In the event of any error in
transmission, unauthorized recipients are requested to contact the sender
immediately and not to disclose or make use of this information. No
employee or agent is authorized to conclude any binding agreement on behalf of
NyproMold with another party by email without express written confirmation by
NyproMold Offices.

P Please consider the environmental impact of
printing this e-mail.


6
Thanks Sarah I did look at the Data Dictionary I just do not know what data is in the keys fields to indicate the table info I need to look for. Man I wish I was on MS SQL. :)

7
if you have ODBC set-up you can also link to it via MS Access and do a SQL query there. Is there a specific change table you are looking for the keys on I could look for you :)


8
I need to analyze our job changes to see what kind of changes are happening and by who.