Report Fields disappearing after mapping parameter

More
1 year 9 months ago #24606 by Peter.Jonson
I have made some further modifications and I hope the this time we have fixed the problem. 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24647 by prashant
The bug is back 4.61 release
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24649 by admin
We will double check it

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24653 by Peter.Jonson
I have spent half a day today trying to reproduce the problem and I was not able to do so.

It works absolutely fine here

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24657 by prashant
Maybe try a query with two parameters or slightly more complex parameters

I can confirm bug in below . I have passed relevant parameters by using variables. 

See LOOM video of disappearing 
www.loom.com/share/dcc03702e460439fa919c...e9-9b8e-db568fb37b01



SELECT
  edt_eomaterial.Image,
  edt_eomaterial.Po_No,
  edt_eomaterial.Description,
  edt_eomaterial.Supplier,
  edt_eomaterial.pivot_header,
  edt_eomaterial.fabcolor,
  edt_eomaterial.unit,
  edt_eomaterial.Qty_Reqd,
  edt_eomaterial.POStatus_F,
  edt_eomaterial.Position,
  edt_eomaterial.VG,
  edt_eomaterial.po_qty,
  edt_eomaterial.balqty,
  edt_eomaterial.consumption,
  edt_eomaterial.podelvdate,
  edt_eomaterial.ename,
  edt_eomaterial.xr_in,
  edt_eomaterial.xr_out,                                                          
  edt_eomaterial.location,
  edt_eomaterial.merchandiser,      
  edt_eomaterial.Recd_Qty                                                     
FROM
  edt_eomaterial
WHERE                                                                                      
  (:sqlparameter != '' AND edt_eomaterial.ename = :sqlparameter)
  OR (:locationParam != '' AND edt_eomaterial.location = :locationParam)
       
ORDER BY
  edt_eomaterial.VG ASC,
  edt_eomaterial.Position ASC;
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24659 by admin
I 've tried and it is still working absolutely fine.

After approximately 1 sec the fields are refreshed.


Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save