Hello to all,
Is it possible to configure a where clause in a migration task for Excel Add-in on IFS Cloud?
The goal is not to retrieve all records by clicking on the "Load Data" button on Excel.
Thanks in advance!
Best answer by mmol
View originalHello to all,
Is it possible to configure a where clause in a migration task for Excel Add-in on IFS Cloud?
The goal is not to retrieve all records by clicking on the "Load Data" button on Excel.
Thanks in advance!
Best answer by mmol
View originalHi
When creating the Excel migration job you have a rule named FETCHCONDITION. This is where you can join other tables but also add where clause conditions to fetch less data.
This is what the documentation says about this:
If you want to add additional filtering you can add it here as well. (e.g. SUPPLIER_INFO.COUNTRY_DB = ‘LK’)
Hope this helps.
Kind regards,
Michael
Hi
Thank you for your answer, it's exactly what I needed!
However, I tried to fill in a condition:
But Excel does not take into account the WHERE clause, it shows me all the customers.
Did I forget something? Something to refresh or to validate?
Thanks in advance!
Hi
Yesterday I was trying the same thing and found out that it seems not to be working in the IFS Cloud. A colleague of me pointed out the following community post about this:
It seems like a bug that it is missing as the documentation states it's one of the migration rules that should work. Howerver it was reported as a bug but not solved so far I know as I tested it yesterday in 22R1.
Kind regards,
Michael
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.