Datanory Production » Datanory - PRIMAASIA

exec sp_rpt_transaction_photo_report
@branch=N'DF3EC71F101F4681A5B69F4C3DBDD3C7,1751B31A745D474AADE6A9A390325F36,C5EF97675ECD4794BBEE8BA10F7D90DA,0347B8747E494B49947F0A850D092B24,E7A3A6D679794762B34E5F28802F09F0,D57583C150C24FA7A1877DF885234A8B,A3458E2A9D154EE39076A4C826BC8246,C250FC79285F472493E4AC39C1C8127C,DAF6B31AD0A546D68AB2BDE3DD48D245,D77F1BAE354D4F86BBFA08CE652D23C3,4DAA02EFF4444B448E323334D5373AF0,AF9E1D5E16F04568A43600A5D6FB7A6B,08C3A1B6A3824A9AB2A90C8262EE7BAD,D5E3F05BD86D4C0EA23C725E865A2834,5709D5A921AE45189BF91C6268A07AD4,61F3F6A00AAE4764A7E457385184725C,8C5EBD54F6C34599876E1CB6FB149E10,8CE17E9D89C84FF7BA125893A45F8C09,AF158E86D3494025806DAF8C69808DB7,01C56F8514934E60813CE7DA8675E4FC,4D749148-876D-4CC3-ACC0-D6C8E8F5404C,DAF5C1619B24410A82B1B7FB76FADAEB,184044126801407EAF2F680890B4FD65,CB11877EF1834CBDB1D96ABFA590A378,7D9722B4D02A46108BD4F2E4A06D37B5,7F25D6A83EEC42168BDFFE2D6817AD55,769E09B9F25D475DB76285AD0A3EE1D8,E225A093662F4BCDA920DD9ACFB71E9C,58EC207AF61142A0BCC707421386A968,B0370658BC574139B233C488BE7BFFF3,7DBF27A78EEF4826AF306FB11FF24540,A07FB75A7821460C82DE97C84B8A0B05,EA0149988A184701AEAA771805F934D7,0D0EF1E933A545C1A9D8931C314E0AA2,F4B56B8C55B747D5AAB7E36F0CC801F4,43E577A0E0D9461E8DE1616FADE69512,3AC3B165FE864C04AF4EF56CA7318FA2,696E23760FA04148BF17736838100D88,2632F90FC0F942959440DD29D7D11A6D,AD55FD5D65C04BF09AF839C1D8233AA3,E5B5B73091C34F399A9B0D3E1AAF42F8,213A248902DD490582B131F1C614D810,2B3EE5C36C10469E8C0EAFE4293F3E78,13CF8B0C493541A8B311DFFF86BFBB79,289A52586D1D4D05A38A1CB1AE806977,7966B2115C68428E91A7D8727324834A,96F18440BE424E09B39BBD794503B1C1,BC0A8AA4739D408D9FEBEDAAF688B088,DE881AA18EBA48B2A24AA64ED63A59D5,C58BEEECD3D449A2AF7446AA0F970B09,0CB08313EAD1438BA07A69F0F17462D3,AA7597EE0B2841FA9FEBC3A1282D75AC,F27AFE1CE9E54C6981298BE80612E715,57EBF71A394D4B1093168FD545884990,250CD27BBFA94A2DBAD2C0270C084BB4,A5896BAD923243989DD9A14F464E1C37,CB416E35BECE45FBAE2157D40D99B5CE,BFB389812DB241A89DE63274677222D6,1F0019DAF46B402F83B4AEF0F3542625',
@transaction_start_date='2024-04-16',
@area=N'3A04938EADFB4AA592263B7CE3F3E21E,EEEB6961E5B146E3825D9D91CF6F01E0,8619C81DBFE9494B8FB5D1BA2A57EE06,6D0F57778F53455695204BB7836F404A,013BE1EAE8C2471F841E3E80A8FE4FD6,CC12439527E2484CA713CD3C9F23E40C,9DC77741CAF94B67814521E5DB8D1578,8A1BA8E944C247AA90C86A07A8E5B896,EDE64D6FE77C4BDCA196044DA3D4FCCC,6363EB6874A24D4BA4BF2916710BED89,0BF29B82DA9A464AB54C668C0697AC8A,45F895F573AA4C9BB5337B7BD6294B8F,BE89AB5F8DC1438CB0FD99EA6331457B,D7F85346FE1742F9AF5CA1DD0CA48532,3FC3B3AF0C9C4CB69CCC461C9000146D,C3DF7DB0AA734DB284B2BBDB27C991BC,B54D49C6CEDD4AA4A2377C2533B828A7,D649AA6D3D204ABE9B0F32063FCFF13C,4D1B62A034DA4382A916F464D4019F17,FDA945423D184C0BAE73E866D5C95714,D5087C17A532406F8F63072036433D8B,D7B76F4ED0DE4DCAACCBEA07F5A0514D,1E52E57DB5204FCFB134EB387AD7FA38,CDC7A86DD2D647279E5435C084A7A66C,5A8DAA33-9E4C-46A6-A937-29F436CA92CF,FB867F481F934513BEEF665A791F5FA1,932B4FAB8C1F47ADB49514C00876B4F2,244C900648CB4FA6817790733036DF7B,2CDFB8E23DD94026BF564513BC8A404D,E3951E1304774742A798A130462AE4AB,F0150078495F422AB693EC3A026571A8,836E2477BC1A4980A8C042D5245B3F5D,DF0994D57520433C9254E777FED17D49,FF617D942A8A453F8F16FD0EC526B972,2641E6911CAB4EEF966A7F691376C34C,45AC2771365C4409AC26FF7308BE5E22,28D047526039430FA26C97F0F0623DD9,A2EE3D55E09C40939926D3D1B60CB909,1A356CAB6E44433D994D4C16785A3FA2,C6E9CB8192C142E1B5F80E3B6C54FA40,3D4C97F65F4D45538D80DCA9B451D2C1,7C493DC353F146B0BC6289D2B08BFCDA,434001F49E154D72853F81F3852DC72C,500D34FF65604DB0B81C7144845DEDA2,470C404F86FE456CB7ADD44BB402D299,61A6D75FB473461CA9455B29A7AEA147,E2AAA8CA9C1B4AC5838BB80E644EDAC2,EBB4CAC97A964F89AED99993A47D117D,0D64AD90E89C4BEB9ECA8AF1E56473B1,DB27DF8FDFF145E2B4670590BB3498A7,50B22219E11C419591356C9F84804412,F53D951BE83447F98C21AEB376148CBC',
@transaction_end_date='2024-04-16',
@salesman=N'feb7cf75658143c19b67bdf0c52803c3',
@tenant_id=N'PRIMAASIA'

as I check in SQL profiler there is no data in it.Already requested user to upload database for further checking on this

hi @~Kaffar Ashiq , could you kindly let us know which outlet the user uploaded the photo from for the purpose of further checking? Thank you

Hi Arif,

I find out that the transaction photo report did show any data. I have tried user 3 month data and select all parameter yet show blank report.

I have check on these 2 table :
select * from txn_sales_order_photo where org_id ='primaasia'
select * from txn_mobile_photo_header where org_id ='primaasia'

the txn_mobile_photo_header does contain transactions from user. Please help to further check as even i profiler, i not sure how to read the logic of the SP.