{"id":1670,"date":"2022-11-21T16:00:42","date_gmt":"2022-11-21T16:00:42","guid":{"rendered":"https:\/\/sipsnitya.com\/?p=1670"},"modified":"2022-11-21T16:00:53","modified_gmt":"2022-11-21T16:00:53","slug":"sipsnitya-programmatically-hide-inactive-students-from-master-database","status":"publish","type":"post","link":"https:\/\/sipsnitya.com\/index.php\/2022\/11\/21\/sipsnitya-programmatically-hide-inactive-students-from-master-database\/","title":{"rendered":"SIPSNITYA &#8211; Programmatically Hide Inactive Students from master database"},"content":{"rendered":"<p>This will be very useful for us when our database grows and we have many inactive data in the master list, we need not deal with that on a daily basis but we need those data, It may be only active student information or any way we define it. Understanding data structure basically fields etc is very much required, also little knowledge of SQL queries will be an added advantage.<\/p>\n<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/zy1Cgmj5iNM\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Let us see it in action now, login and check the existing student master, this master contains all the records now, there are passed out student information too are available, Navigate to the Platform-tools module, under master maintenance we have master display, please open the same, click on inline add to add a query, we can see all the supported masters here, let us choose student master now, I want to get only active student information so I am just writing this query.<br \/>\nLet us now go back to the master module and student master, see now only active student information only available, we can do multiple field queries let us see how to do that, for example, I want the display of all active male students let me add that part to my query I will add and gender is equal to male.<br \/>\nNow we can witness only active male students in the database. I can change it to active female students too simply altering the query.<br \/>\nWe can do many such filtering with all master data, just select the master and write your query.<br \/>\nIf you want the filters to be removed just delete it, and the master data will get resumed with all the information. Please try yourself and experience.<br \/>\nThank you for watching the tutorial. Please contact our support channel for any assistance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This will be very useful for us when our database grows and we have many inactive data in the master list, we need not deal with that on a daily basis but we need those data, It may be only active student information or any way we define it. Understanding data structure basically fields etc [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1671,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5,1,3],"tags":[],"class_list":["post-1670","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-events","category-uncategorized","category-why-to-consider-sipsnitya"],"jetpack_featured_media_url":"https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1.jpg","rttpg_featured_image_url":{"full":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1.jpg",1280,720,false],"landscape":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1.jpg",1280,720,false],"portraits":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1.jpg",1280,720,false],"thumbnail":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-150x150.jpg",150,150,true],"medium":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-300x169.jpg",300,169,true],"large":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-1024x576.jpg",771,434,true],"1536x1536":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1.jpg",1280,720,false],"2048x2048":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1.jpg",1280,720,false],"university-hub-thumb":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-400x225.jpg",400,225,true],"woocommerce_thumbnail":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-600x338.jpg",600,338,true],"woocommerce_gallery_thumbnail":["https:\/\/sipsnitya.com\/wp-content\/uploads\/2022\/11\/Slide1-1-100x100.jpg",100,100,true]},"rttpg_author":{"display_name":"sdapps","author_link":"https:\/\/sipsnitya.com\/index.php\/author\/sdapps\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/sipsnitya.com\/index.php\/category\/news-events\/\" rel=\"category tag\">NEWS &amp; EVENTS<\/a> <a href=\"https:\/\/sipsnitya.com\/index.php\/category\/uncategorized\/\" rel=\"category tag\">Uncategorized<\/a> <a href=\"https:\/\/sipsnitya.com\/index.php\/category\/why-to-consider-sipsnitya\/\" rel=\"category tag\">Why to consider SIPSNITYA?<\/a>","rttpg_excerpt":"This will be very useful for us when our database grows and we have many inactive data in the master list, we need not deal with that on a daily basis but we need those data, It may be only active student information or any way we define it. Understanding data structure basically fields etc&hellip;","_links":{"self":[{"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/posts\/1670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/comments?post=1670"}],"version-history":[{"count":1,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/posts\/1670\/revisions"}],"predecessor-version":[{"id":1672,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/posts\/1670\/revisions\/1672"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/media\/1671"}],"wp:attachment":[{"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/media?parent=1670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/categories?post=1670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sipsnitya.com\/index.php\/wp-json\/wp\/v2\/tags?post=1670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}