Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Accept

Popular articles

SQList version history

Download a previous version of SQList

How do I install or upgrade AxioWorks SQList?

Configure authentication methods to SharePoint

Security Considerations for Installing SQList

More support options:

Use the search page;

Email us at support@axioworks.com;

Send us a message using the Contact Us page.

How SQList exports lookup-columns

SQList exports the SharePoint lists in a normalised form, which means that lookup columns contain the IDs of the lookup values.

Image Placeholder

To retrieve the lookup titles, you will need to join the various tables either in the SQL database itself o in teh reporting tool of preference.
We strongly recommend the first option as that would give you dramatically better performance.

Image Placeholder


Please see this video that explains that approach:

Should you have any questions about this article, contact out support team at support@axioworks.com