Hi everyone, I want to search for all Feature Classes in our SDE and list out only the ones that have a field name 'SDE_UPDATE' (date field) with a criteria that queries the ones that have been updated in past 10 days. Any example workbench to sha
Best answer by carmijo
Hi @akala , This is certainly possible. I would start with a sql excutor to read all tables from SDE, then feed the results into a feature reader, set to only read the schema from each table. Then you can find those that have the field you're looking for, read them in and test the max sde_update value to see if it meets your 10 day requirement.
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. 
--
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
+11- Supporter
Hi @akala , This is certainly possible. I would start with a sql excutor to read all tables from SDE, then feed the results into a feature reader, set to only read the schema from each table. Then you can find those that have the field you're looking for, read them in and test the max sde_update value to see if it meets your 10 day requirement.
+11- Supporter
- Best Answer
Hi @akala , This is certainly possible. I would start with a sql excutor to read all tables from SDE, then feed the results into a feature reader, set to only read the schema from each table. Then you can find those that have the field you're looking for, read them in and test the max sde_update value to see if it meets your 10 day requirement.
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. --
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. --
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
Awesome - Thanks a ton Carmijo for your time and for this well documented and precise example.
+11- Supporter
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. --
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
happy to help. fun problem to solve
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. --
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
Thanks again - I posted another problem in community platform that deals with pagination and token refreshing using API. Let me know if you have any inputs/experience with such a problem.
+11- Supporter
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. --
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
i'm afraid i can't help with that one. Good luck though!
Here's a good start. you'll have to modify the all_tables query to make sure you only get what you want. i've highlighted the other important items. --
If i've provided something helpful, please upvote the comment. If i've provided a solution, please mark it as 'Best Answer'. This helps the community find solutions when your question is referenced.
If I didn't provide a solution, please let me know if I can help further. Thanks! 🙂
No worries - Thanks for all your time and efforts!
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.