be able to help me figure out what is probably a simple thing - hard
to say.
I'm trying to find out what forms, reports, etc have been used in an
Axapta installation, using the SysLastValue table. I notice it
doesn't show up in the AOT. I've been using the SQL Query Analyzer.
I only want rows where a combination of two fields is unique - those
fields are recordtype and elementname. There can be many records with
the same recordtype and elementname but I only want to grab one
occurance - I guess the first. For example there could be dozens of
records with recordtype '11' and elementname 'SysQueryForm' - I only
want one in the results.
Below is the query I'm using to get all the records.
select recordtype, elementname, userid, company from syslastvalue
where company = 'mm' ORDER BY recordtype, recordtype;
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
