Jump to content
We've recently updated our Privacy Statement, available here ×

Report design not valid : 1. Field not found :


AARumyantseva

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...