MongoDB input - how to put Sorting into criteria

[Sebastian_Chaieb2]

Hi,

I am using MongoDB input to extract AS_Result table from AlteryxService data base. 

The issue here is that there is too many data to extract and push to parser (ResultData (blob)) and I need to put into the  criteria a  AS_Queue__ID sorted in descending order.

The aim is to extract top 1000 records order by AS_Queue__ID desc

Any idea?

Thanks,

Sebastian 

[AndrewSu]

@Sebastian_Chaieb2 , try changing the Mode to "Manual" then select Scan and only return the columns/fields you want.   see screenshot below. 

If this helps resolve your issue, please mark this reply as the solution so that others in the community can benefit from our collaboration!

Thanks.