PSA Support

1. Community
2. Tips & Tricks
3. Excel Integration - Dynamic Combo / List Box

Hey Joe, The list boxes are driven off a hidden worksheet named "boaListData". It's not possible to have DSP generate an Excel file with dependent drop down lists but it is possible to do that in E...

• View comment
• PSA Support
• April 03, 2024 13:21
• 1 vote

1. Community
2. Data Questions & Discussion
3. Filter data on current user

Hi Donatas,  If you add boaUserID to the Horizontal view for the page, the application will automatically filter for that user. If you have added the ChangedBy field on your table, you can add it y...

• View comment
• PSA Support
• September 08, 2023 13:29
• 1 vote

1. Community
2. Data Questions & Discussion
3. Collect Extraction Performance Optimization Techniques

Also, when working with large tables like this, you may want to look at using Syniti Data Replicator (previously called DBMoto). It's a change data capture tool so you would have one (long) initial...

• View comment
• PSA Support
• September 03, 2021 11:57
• 0 votes

1. Community
2. Data Questions & Discussion
3. Collect - Transparent Table - DB Connection - Build Package successful and Extraction Error

I can confirm - you will only see tables in ALL_TABLES if you have access to them. If you don't have access to a table, you won't see it in ALL_TABLES in Oracle. 

• View comment
• PSA Support
• March 03, 2021 14:29
• 0 votes