Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Special character in field name ( pick list )
#6
SELECT vtiger_cobropago.cyp_no, vtiger_cobropago.parent_id, vtiger_crmentity.smownerid, vtiger_cobropago.paymentmode, vtiger_cobropagocf.cf_871, vtiger_cobropagocf.cf_977, vtiger_cobropago.amount, vtiger_cobropago.cobropagoid FROM vtiger_cobropago INNER JOIN vtiger_crmentity ON vtiger_cobropago.cobropagoid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vtiger_cobropagocf ON vtiger_cobropago.cobropagoid = vtiger_cobropagocf.cobropagoid WHERE vtiger_crmentity.deleted=0 AND ( (( vtiger_cobropago.paid <> '1') )) AND vtiger_cobropago.cobropagoid > 0

Strange ... exactly a test for "Nota Promissória" is omitted in sql command ...
Ranieri
eCRM Web
Reply


Messages In This Thread
RE: Special character in field name ( pick list ) - rslemer - 01-28-2019, 01:34 AM

Forum Jump:


Users browsing this thread: 5 Guest(s)