AARumyantseva Posted July 17, 2020 Share Posted July 17, 2020 Good day.When trying to build a report, it gives an error:"Report design not valid : 1. Field not found : start_time 2. Field not found : created_time 3. Field not found : callee_login_id 4. Field not found : fcr 5. Field not found : nps 6. Field not found : in_service_level 7. Field not found : service_name 8. Field not found : disposition 9. Field not found : comment_url" <![CDATA[select a.global_interaction_id, b.start_time, a.created_time,b.callee_login_id,b.from_phone, a.fcr, a.nps,a.cs, b.in_service_level, b.original_destination_phone,b.service_name, b.disposition,a.comment_url from tsum_hostedcc_ru.surveys a inner join tsum_hostedcc_ru.call_detail b on a.global_interaction_id = b.global_interaction_id where b.media_type ='CHAT' and b.start_time >= $P{start_time} and b.start_time < < $P{end_time} group by b.service_name]]> </queryString> <field name="a.global_interaction_id" class="java.lang.Integer"/> <field name="b.start_time" class="java.sql.Timestamp"/> <field name="a.created_time" class="java.sql.Timestamp"/> <field name="b.callee_login_id" class="java.lang.String"/> <field name="from_phone" class="java.math.BigDecimal"/> <field name="a.fcr" class="java.lang.Integer"/> <field name="a.nps" class="java.lang.Integer"/> <field name="a.cs" class="java.lang.Integer"/> <field name="b.in_service_level" class="java.lang.Long"/> <field name="b.original_destination_phone" class="java.lang.String"/> <field name="b.service_name" class="java.lang.String"/> <field name="b.disposition" class="java.lang.String"/> <field name="a.comment_url" class="java.lang.Long"/> </subDataset>[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now