Any Sql Modeler: I need: infor.IncludeDeleted('arsd')

Nathalie Abel · 2024-11-12T19:11:12+00:00

There was an error rendering this rich post.

Nathalie Abel

In any sql modeler: How can I use

infor.IncludeDeleted. I have not find a way yet. It returns everything except deleted.

Find more posts tagged with

Accepted answers

Prabodha Amarapema

I don't think we can use query hints in the AnySQL modeler. I had a similar requirement and I ended up using compass queries.

All comments

Prabodha Amarapema

I don't think we can use query hints in the AnySQL modeler. I had a similar requirement and I ended up using compass queries.

Nathalie Abel

ok thks

Danil Klemeshov

Hi,

In ION's roadmap, we have a requirement to use Compas views in Data Lake flows. I cannot provide exact dates but it is planned for 2025.
You will be able to create queries in Compass with the "IncludeDeleted", save them as a view, and use the view in a Data Lake flow.

Prabodha Amarapema

https://community.developer.infor.com/discussion/comment/675#Comment_675

Thanks for sharing, we would love to have this feature.

Bojan Rafajloski

In the April 2025 release, ION Data Lake Flows will support use of Data Lake Views in the Query step when extracting data using Compass. You could include the Infor Functions in the View, for example to query deleted records.

Prabodha Amarapema

Thanks, this is a much needed feature