custom

latihan mencoba custom

INSERT INTO ad_userquery (ad_userquery_id,ad_client_id,ad_org_id,isactive,created,createdby,updated,updatedby,"name",description,ad_user_id,ad_table_id,code,ad_tab_id,ad_userquery_uu,ad_window_id,ad_role_id) VALUES
(1000000,0,0,'Y','2020-01-23 10:22:59.171',0,'2020-01-23 10:25:53.865',0,'Windowku',NULL,afei,105,'AD_Window_ID<^>>=<^>1000000<^><^><^><^>',105,'4b3c0fb1-5063-457e-a9f8-2a87a513c82c',102,NULL)
,(1000001,0,0,'Y','2020-01-23 11:15:08.949',0,'2020-01-23 11:15:08.949',0,'Tableku',NULL,afei,100,'AD_Table_ID<^>>=<^>1000000<^><^><^><^>',100,'756e0ba6-8787-40d4-ae14-2907b8bcce23',100,NULL)
,(1000002,0,0,'Y','2020-05-09 16:36:19.441',0,'2020-05-09 16:36:19.441',0,'Win Trx Active',NULL,afei,105,'WindowType<^>=<^>T<^><^><^><^><~>IsBetaFunctionality<^>=<^>N<^><^>AND<^><^><~>AD_Window_ID<^><<^>1000000<^><^>AND<^><^><~>IsActive<^>=<^>Y<^><^>AND<^><^>',105,'9aa905be-a3d2-4b01-858b-d12da64d6071',102,NULL)
;

 INSERT INTO ad_tab_customization (ad_client_id,ad_org_id,ad_tab_customization_id,ad_tab_id,ad_user_id,created,createdby,custom,isactive,updated,updatedby,ad_tab_customization_uu,isdisplayedgrid) VALUES
(0,0,100014,105,afei,'2020-05-09 16:16:41.715',0,'114,115,116,268,10569,267,5379,202516,4942,4943,5124,8194,10397,10396;141px,209px,300px,43px,47px,92px,82px,107px,160px,160px,160px,48px,120px,120px','Y','2020-05-09 16:17:12.008',0,'daefecec-13dc-4d76-aede-6c83e9768138',NULL)
,(0,0,100000,100,afei,'2020-01-09 09:40:51.445',0,'149,143,144,145,246,4874,249,6554,7530,147,7531,253,3207,5125,58844,202252;140px,183px,79px,97px,43px,34px,160px,128px,101px,160px,160px,110px,79px,160px,125px,121px','Y','2020-01-09 09:40:51.445',0,'5ce31d37-bf5e-45d5-b3e6-d338e5dd4623',NULL)
,(0,0,100008,246,afei,'2020-01-28 11:09:40.539',0,'2537,2546,2541,2542,205338,2543,5817,4576,2547,3110,5818,2539,2540,2907,2901,200097,2903,2904,2544,2902,4398,2906,2905,56333,56334,204372,205339;160px,144px,76px,100px,79px,43px,96px,125px,63px,128px,160px,160px,160px,160px,160px,66px,120px,68px,44px,208px,208px,160px,160px,300px,300px,136px,300px','Y','2020-01-28 11:09:40.539',0,'c4a42766-3ea2-4ed1-a28f-3404fba27185',NULL)
,(0,0,100009,101,afei,'2020-01-31 13:09:26.817',0,'157,156,152,170,171,172,160,825,205342,250,2370,155,158,310,56279,11264,1345,56374,50188,4941,166,2526,200648,2574,2573,161,10128,162,168,159,4940,204220,167,5121,56317,62467,202518,202519,5122,200288,202257,205668,59619;100px,124px,127px,87px,101px,160px,97px,60px,85px,43px,65px,57px,53px,88px,87px,90px,104px,94px,108px,101px,68px,58px,69px,66px,77px,75px,110px,114px,58px,71px,108px,122px,67px,77px,90px,72px,112px,109px,161px,168px,94px,40px,160px','Y','2020-04-23 07:37:24.731',0,'76cb5b38-d41c-4c5d-866b-d39a646f6c49',NULL)
,(0,0,100004,106,afei,'2020-01-23 10:19:42.744',0,'119,120,271,131,123,5326,1550,1549,11265,11266,124,929,11998,2575,927,5709,1546,57266,5707,11997,312,928,5708,1548,4956,201811,202515,5131,206373,5824,121,122;85px,106px,43px,160px,34px,37px,79px,83px,73px,56px,71px,66px,58px,68px,50px,66px,107px,59px,63px,46px,57px,91px,61px,81px,51px,81px,62px,122px,120px,72px,81px,98px','Y','2020-04-23 07:56:32.524',0,'400ce2ef-f7f3-48aa-81d8-f128cbd2cd07',NULL)
,(0,0,100001,107,afei,'2020-01-09 09:46:44.111',0,'126,127,130,274,4259,132,200276,924,133,13425,54402,54401,13424,136,142,137,200274,139,202362,138,8343,140,141,202341,5808,205345,62468,200771,53280,200837,200350,200348,200838,200834,200349,200835,200836,204213,203500,204214,128,129,1551;61px,141px,160px,43px,47px,64px,81px,66px,91px,61px,35px,37px,37px,93px,66px,35px,43px,67px,96px,95px,56px,82px,65px,86px,49px,83px,64px,74px,69px,51px,37px,50px,41px,73px,102px,76px,74px,68px,57px,48px,73px,103px,62px','Y','2020-04-23 08:05:35.548',0,'0856affb-b4f5-4d63-88a2-c4aa621b40d3',NULL)
,(0,0,100012,50006,afei,'2020-04-28 11:19:57.523',0,'50091,50095,50096,50097,50103,50111,50182,50104,50105,50098,50099,50100,50101,50102,50106,50107,50108,50109,50110,50112,50113,50114,50115,50183,50187,50116,50117,53284,57418,205861;93px,51px,160px,75px,72px,75px,121px,56px,108px,65px,129px,102px,134px,140px,114px,121px,42px,54px,64px,72px,160px,87px,89px,59px,78px,70px,52px,72px,105px,160px','Y','2020-04-28 11:24:11.903',0,'7f8900bb-e879-482b-93d8-ca4c491d7e7f',NULL)
;