I have a data source that consists of two files joined by the same field name. In the data source, I use the fully qualified name to select/join the two tables (filename.fieldname). I also have the field renamed using AS.
The data source and widgets work fine. However, my app is using a chart widget to filter my grid widget. I'm getting the error:
I've tried changing the field name to something else and updating my widgets... I still get the same thing.
The filter widget shows the fieldname as it appears in the file (so there are two MFG_ID fields listed)... Like it is ignoring the "AS".
I've not encountered this previously
Code:
SELECT order_id, rtmhdrwh.mfg_id AS mfgid, com_name, cust_id, reptim_id, bill_name, bill_adr1, bill_adr2, bill_city, bill_st, bill_zip, ast_date, ast_time, rrn(RTMHDRWH) AS rrn1, rrn(RTMCNFIG) AS rrn2 FROM rtmhdrwh LEFT JOIN rtmcnfig ON rtmcnfig.mfg_id = rtmhdrwh.mfg_id WHERE ((ast_com = '') or ast_date = current_date)
Code:
VV00007 - SQL statement prep failure (SQLSTT=42702) - SQL0203 - Name MFG_ID is ambiguous. Help Text The value of the statement is: SELECT order_id , rtmhdrwh.mfg_id AS mfgid, com_name , cust_id , reptim_id , bill_name , bill_adr1 , bill_adr2 , bill_city , bill_st , bill_zip , ast_date , ast_time , rrn(RTMHDRWH) AS rrn1, rrn(RTMCNFIG) AS rrn2 FROM rtmhdrwh LEFT JOIN rtmcnfig ON rtmcnfig.mfg_id = rtmhdrwh.mfg_id WHERE ((ast_com = '') or ast_date = current_date) AND ((MFG_ID='M31993'))
The filter widget shows the fieldname as it appears in the file (so there are two MFG_ID fields listed)... Like it is ignoring the "AS".
I've not encountered this previously
Comment