Up next in 10
Advanced Liquid concepts in Web Templates - Microsoft Business Application: Ep.27
0 views
Aug 6, 2025
Join this live session with Mahender Pal and Venkata Subbarao for the next episode of Microsoft Business Application Live Show on February 21 at 10:00 PM (IST). In this session, we will be giving a walkthrough on Advanced Liquid concepts in Web Templates. • Access Dataverse Data • Data Security and Liquid • Display list of accounts • Add table permissions • Demo 📺 CSharp TV - Dev Streaming Destination http://csharp.tv 🌎 C# Corner - Community of Software and Data Developers https://www.c-sharpcorner.com #CSharpTV #csharpcorner #WebTemplates
View Video Transcript
0:01
[Music]
0:14
[Music]
0:36
greetings
0:37
greetings
0:37
greetings everyone welcome again to the business
0:40
everyone welcome again to the business
0:40
everyone welcome again to the business MVP show so where we talk about uh
0:43
MVP show so where we talk about uh
0:43
MVP show so where we talk about uh business application as well as Power
0:45
business application as well as Power
0:45
business application as well as Power Platform applications so from couple of
0:49
Platform applications so from couple of
0:49
Platform applications so from couple of sessions we have been discussing about
0:50
sessions we have been discussing about
0:50
sessions we have been discussing about the power pages and uh we are continuing
0:53
the power pages and uh we are continuing
0:53
the power pages and uh we are continuing on that and today also we will be
0:55
on that and today also we will be
0:55
on that and today also we will be discussing about that liquid you know
0:59
discussing about that liquid you know
0:59
discussing about that liquid you know how we use Liquid to get the data from
1:01
how we use Liquid to get the data from
1:01
how we use Liquid to get the data from the data ver tables okay so uh that's
1:04
the data ver tables okay so uh that's
1:04
the data ver tables okay so uh that's the high level agenda for today so we'll
1:08
the high level agenda for today so we'll
1:08
the high level agenda for today so we'll start with the basic introduction that
1:10
start with the basic introduction that
1:10
start with the basic introduction that uh you know we like I will give you a
1:13
uh you know we like I will give you a
1:13
uh you know we like I will give you a basic idea on the liquid this this slide
1:15
basic idea on the liquid this this slide
1:15
basic idea on the liquid this this slide is basically from the earlier session
1:18
is basically from the earlier session
1:18
is basically from the earlier session only and then we will see how we can
1:20
only and then we will see how we can
1:20
only and then we will see how we can access data using liquid on the
1:22
access data using liquid on the
1:22
access data using liquid on the different tables and what are the you
1:24
different tables and what are the you
1:24
different tables and what are the you know main keywords that we use for
1:27
know main keywords that we use for
1:27
know main keywords that we use for accessing the data and then we'll see
1:29
accessing the data and then we'll see
1:29
accessing the data and then we'll see that how we can uh you know basically
1:31
that how we can uh you know basically
1:31
that how we can uh you know basically how security works on the liquid when we
1:33
how security works on the liquid when we
1:33
how security works on the liquid when we work with the liquid with the data what
1:36
work with the liquid with the data what
1:36
work with the liquid with the data what are the you know Security check we can
1:37
are the you know Security check we can
1:37
are the you know Security check we can apply and then we'll have a overview of
1:40
apply and then we'll have a overview of
1:40
apply and then we'll have a overview of the table permissions and uh we are
1:43
the table permissions and uh we are
1:43
the table permissions and uh we are planning to have next session on the you
1:45
planning to have next session on the you
1:45
planning to have next session on the you know complete session on that uh
1:47
know complete session on that uh
1:47
know complete session on that uh security we will be discussing about the
1:49
security we will be discussing about the
1:49
security we will be discussing about the web roles and all those there so today
1:51
web roles and all those there so today
1:51
web roles and all those there so today it will be just uh little bit overview
1:54
it will be just uh little bit overview
1:54
it will be just uh little bit overview of how to you know the table permission
1:56
of how to you know the table permission
1:56
of how to you know the table permission works okay then we'll see that how we
1:58
works okay then we'll see that how we
1:58
works okay then we'll see that how we can use the f XML that's you know most
2:01
can use the f XML that's you know most
2:01
can use the f XML that's you know most commonly used for quering the data on
2:03
commonly used for quering the data on
2:03
commonly used for quering the data on the data ver tables so we'll see how we
2:06
the data ver tables so we'll see how we
2:06
the data ver tables so we'll see how we can use S XML using the liquid to get
2:08
can use S XML using the liquid to get
2:08
can use S XML using the liquid to get the data and then we will show the demo
2:11
the data and then we will show the demo
2:11
the data and then we will show the demo of all these things that we willing
2:14
of all these things that we willing
2:14
of all these things that we willing here
2:16
here
2:16
here so before uh going in much detail let's
2:20
so before uh going in much detail let's
2:20
so before uh going in much detail let's have a quick introduction about ourself
2:21
have a quick introduction about ourself
2:21
have a quick introduction about ourself myself Mahindra and I have my friend W
2:24
myself Mahindra and I have my friend W
2:24
myself Mahindra and I have my friend W with me we both are Microsoft MVPs and
2:26
with me we both are Microsoft MVPs and
2:27
with me we both are Microsoft MVPs and as well as C Corner MVPs and we have
2:29
as well as C Corner MVPs and we have
2:29
as well as C Corner MVPs and we have been working with Dynamics 365 or CRM
2:32
been working with Dynamics 365 or CRM
2:33
been working with Dynamics 365 or CRM from now couple of years
2:36
from now couple of years
2:36
from now couple of years here so yeah so let's
2:45
start okay so uh we discussed this on
2:49
start okay so uh we discussed this on
2:49
start okay so uh we discussed this on the last session but I uh you know uh
2:52
the last session but I uh you know uh
2:53
the last session but I uh you know uh added this uh slide here as well just to
2:55
added this uh slide here as well just to
2:55
added this uh slide here as well just to have that if there is some new audience
2:57
have that if there is some new audience
2:57
have that if there is some new audience that you know that will give that idea
2:59
that you know that will give that idea
2:59
that you know that will give that idea what is basically that liquid is so
3:02
what is basically that liquid is so
3:02
what is basically that liquid is so liquid is basically a template language
3:05
liquid is basically a template language
3:05
liquid is basically a template language that help us to you know work with the
3:07
that help us to you know work with the
3:07
that help us to you know work with the uh you know different data okay and
3:10
uh you know different data okay and
3:10
uh you know different data okay and these just just consider like when we
3:13
these just just consider like when we
3:13
these just just consider like when we are building one you know web
3:15
are building one you know web
3:15
are building one you know web application we use uh we can use a HTML
3:18
application we use uh we can use a HTML
3:18
application we use uh we can use a HTML language to you know put that static
3:21
language to you know put that static
3:21
language to you know put that static page right we can put the static content
3:23
page right we can put the static content
3:23
page right we can put the static content over the page using the HTML but if we
3:26
over the page using the HTML but if we
3:26
over the page using the HTML but if we want to make that web page Dynamic and
3:29
want to make that web page Dynamic and
3:29
want to make that web page Dynamic and where want to you know populate some of
3:31
where want to you know populate some of
3:31
where want to you know populate some of the data then we need to use some kind
3:33
the data then we need to use some kind
3:33
the data then we need to use some kind of framework like for example you know
3:35
of framework like for example you know
3:35
of framework like for example you know JavaScript jQuery and all those that we
3:37
JavaScript jQuery and all those that we
3:37
JavaScript jQuery and all those that we use to make that you know web page
3:39
use to make that you know web page
3:39
use to make that you know web page Dynamic right so similarly here on that
3:43
Dynamic right so similarly here on that
3:43
Dynamic right so similarly here on that power pages when we want to work with
3:45
power pages when we want to work with
3:45
power pages when we want to work with the data set when we want to make our uh
3:49
the data set when we want to make our uh
3:49
the data set when we want to make our uh you know web page as that uh you know uh
3:52
you know web page as that uh you know uh
3:52
you know web page as that uh you know uh Dynamic we use that liquid template and
3:56
Dynamic we use that liquid template and
3:56
Dynamic we use that liquid template and that help us to work with the data as
3:58
that help us to work with the data as
3:58
that help us to work with the data as well as you know we can apply different
4:00
well as you know we can apply different
4:00
well as you know we can apply different uh you know uh Logics uh there are we we
4:04
uh you know uh Logics uh there are we we
4:05
uh you know uh Logics uh there are we we discussed in earlier session that what
4:06
discussed in earlier session that what
4:06
discussed in earlier session that what are the different operators are there
4:08
are the different operators are there
4:08
are the different operators are there you know what are the different looping
4:11
you know what are the different looping
4:11
you know what are the different looping uh you know controls are there which we
4:12
uh you know controls are there which we
4:13
uh you know controls are there which we can use in liquid to work with the data
4:15
can use in liquid to work with the data
4:15
can use in liquid to work with the data right so normally we use Liquid on the
4:18
right so normally we use Liquid on the
4:18
right so normally we use Liquid on the web template so that we can you know
4:20
web template so that we can you know
4:20
web template so that we can you know build some reusable template which can
4:22
build some reusable template which can
4:22
build some reusable template which can be used on the multi multiple you know
4:24
be used on the multi multiple you know
4:24
be used on the multi multiple you know pages so wherever we require we can just
4:27
pages so wherever we require we can just
4:27
pages so wherever we require we can just set as that this will be the background
4:29
set as that this will be the background
4:29
set as that this will be the background uh template working for this page and
4:32
uh template working for this page and
4:32
uh template working for this page and then the code that is defined on the web
4:34
then the code that is defined on the web
4:34
then the code that is defined on the web template can be used to render the
4:36
template can be used to render the
4:36
template can be used to render the contents on the web page okay so that's
4:39
contents on the web page okay so that's
4:39
contents on the web page okay so that's basically that uh introduction about
4:42
basically that uh introduction about
4:42
basically that uh introduction about that
4:47
liquid
4:49
liquid
4:49
liquid so the first thing that we want to talk
4:51
so the first thing that we want to talk
4:51
so the first thing that we want to talk that how we want to you know when we
4:53
that how we want to you know when we
4:53
that how we want to you know when we want to get the data from the different
4:56
want to get the data from the different
4:56
want to get the data from the different data table what are the keywords that we
4:59
data table what are the keywords that we
4:59
data table what are the keywords that we can use
5:00
can use
5:00
can use right so just consider that yes of
5:02
right so just consider that yes of
5:02
right so just consider that yes of course when you are building web page
5:04
course when you are building web page
5:04
course when you are building web page you can go to that you know P web page
5:07
you can go to that you know P web page
5:07
you can go to that you know P web page uh you know portal Studio portal maker
5:09
uh you know portal Studio portal maker
5:09
uh you know portal Studio portal maker studio and there you can put that uh
5:12
studio and there you can put that uh
5:12
studio and there you can put that uh different controls that is there so you
5:14
different controls that is there so you
5:14
different controls that is there so you can you know put that list View and
5:17
can you know put that list View and
5:17
can you know put that list View and under that list view then you can see
5:18
under that list view then you can see
5:18
under that list view then you can see lots of data right so that is there but
5:21
lots of data right so that is there but
5:22
lots of data right so that is there but let's say if you want to write the code
5:23
let's say if you want to write the code
5:24
let's say if you want to write the code using liquid and then you want to fetch
5:26
using liquid and then you want to fetch
5:26
using liquid and then you want to fetch the data and while fetching the data
5:28
the data and while fetching the data
5:28
the data and while fetching the data maybe you want to you know apply some
5:30
maybe you want to you know apply some
5:30
maybe you want to you know apply some condition or maybe you have some kind of
5:33
condition or maybe you have some kind of
5:33
condition or maybe you have some kind of requirement to check this particular
5:35
requirement to check this particular
5:35
requirement to check this particular record if this fulfill that particular
5:37
record if this fulfill that particular
5:37
record if this fulfill that particular condition only then render it there okay
5:40
condition only then render it there okay
5:41
condition only then render it there okay or maybe you want to do some other kind
5:43
or maybe you want to do some other kind
5:43
or maybe you want to do some other kind of formatting with the data so in that
5:46
of formatting with the data so in that
5:46
of formatting with the data so in that case we can use Liquid here right so in
5:50
case we can use Liquid here right so in
5:50
case we can use Liquid here right so in the liquid you can see that mainly we
5:52
the liquid you can see that mainly we
5:52
the liquid you can see that mainly we have two three you know keywords that we
5:54
have two three you know keywords that we
5:54
have two three you know keywords that we use so for example here we have the list
5:57
use so for example here we have the list
5:57
use so for example here we have the list view that is normally used when you want
5:59
view that is normally used when you want
5:59
view that is normally used when you want to work with the views that is available
6:02
to work with the views that is available
6:02
to work with the views that is available in the datab okay so for example here on
6:05
in the datab okay so for example here on
6:05
in the datab okay so for example here on the screen you can see that I'm using
6:08
the screen you can see that I'm using
6:08
the screen you can see that I'm using account table and under that account
6:10
account table and under that account
6:10
account table and under that account table we have a all accounts view so
6:13
table we have a all accounts view so
6:13
table we have a all accounts view so this view is created there and now we
6:16
this view is created there and now we
6:16
this view is created there and now we are using that view to fetch the data
6:19
are using that view to fetch the data
6:19
are using that view to fetch the data using the entity view keyword okay as
6:21
using the entity view keyword okay as
6:21
using the entity view keyword okay as you can see here we have the curly Braes
6:23
you can see here we have the curly Braes
6:23
you can see here we have the curly Braes and then we have the percentage sign so
6:25
and then we have the percentage sign so
6:26
and then we have the percentage sign so these are the basically you know uh tags
6:28
these are the basically you know uh tags
6:28
these are the basically you know uh tags that we used while we write that liquid
6:31
that we used while we write that liquid
6:31
that we used while we write that liquid code so all that liquid code is you know
6:33
code so all that liquid code is you know
6:33
code so all that liquid code is you know written under these two tags right so
6:37
written under these two tags right so
6:37
written under these two tags right so here now we are getting this from this
6:40
here now we are getting this from this
6:40
here now we are getting this from this all accounts View and once we have that
6:44
all accounts View and once we have that
6:44
all accounts View and once we have that we have other you know that like for
6:46
we have other you know that like for
6:46
we have other you know that like for example this total record is the method
6:48
example this total record is the method
6:48
example this total record is the method that we can use that okay we want to see
6:50
that we can use that okay we want to see
6:50
that we can use that okay we want to see that how many records are there so it's
6:52
that how many records are there so it's
6:52
that how many records are there so it's just like a count okay so you can use
6:55
just like a count okay so you can use
6:56
just like a count okay so you can use this entity View and do total record and
6:59
this entity View and do total record and
7:00
this entity View and do total record and then here it will give us that okay
7:02
then here it will give us that okay
7:02
then here it will give us that okay these are the total number of record
7:04
these are the total number of record
7:04
these are the total number of record that you have on the table right so we
7:06
that you have on the table right so we
7:06
that you have on the table right so we are just simply you can see here we have
7:08
are just simply you can see here we have
7:08
are just simply you can see here we have these two curly bres here so these are
7:11
these two curly bres here so these are
7:11
these two curly bres here so these are kind of a placeholder when we will run
7:13
kind of a placeholder when we will run
7:13
kind of a placeholder when we will run this web page it will get the data and
7:16
this web page it will get the data and
7:16
this web page it will get the data and it will render that data over the web
7:18
it will render that data over the web
7:18
it will render that data over the web page okay and then we are here you can
7:22
page okay and then we are here you can
7:22
page okay and then we are here you can see that we are using for Loop for Loop
7:25
see that we are using for Loop for Loop
7:25
see that we are using for Loop for Loop will be basically going through all the
7:28
will be basically going through all the
7:28
will be basically going through all the result set that we go from this entity
7:30
result set that we go from this entity
7:30
result set that we go from this entity View and then it will go one by one and
7:33
View and then it will go one by one and
7:33
View and then it will go one by one and then it will you can see from this uh
7:36
then it will you can see from this uh
7:36
then it will you can see from this uh you know the uh item that we are using
7:40
you know the uh item that we are using
7:40
you know the uh item that we are using for you know uh to go through that
7:42
for you know uh to go through that
7:42
for you know uh to go through that record one by one so under that item the
7:45
record one by one so under that item the
7:45
record one by one so under that item the ACC item here we can access all the
7:48
ACC item here we can access all the
7:48
ACC item here we can access all the properties so right now I'm accessing
7:50
properties so right now I'm accessing
7:50
properties so right now I'm accessing the name property of the account so it
7:52
the name property of the account so it
7:52
the name property of the account so it will print the account name okay so
7:55
will print the account name okay so
7:55
will print the account name okay so using that account name we can uh you
7:57
using that account name we can uh you
7:57
using that account name we can uh you know go through those reports and print
7:59
know go through those reports and print
7:59
know go through those reports and print that so this is just an example like
8:01
that so this is just an example like
8:01
that so this is just an example like right now I have two account records and
8:04
right now I have two account records and
8:04
right now I have two account records and it will show you that you know we have
8:06
it will show you that you know we have
8:06
it will show you that you know we have two total customers and then name of the
8:08
two total customers and then name of the
8:08
two total customers and then name of the customer that displaying that this is a
8:11
customer that displaying that this is a
8:11
customer that displaying that this is a dumi test record that I have created
8:14
dumi test record that I have created
8:14
dumi test record that I have created right then we are closing that and then
8:16
right then we are closing that and then
8:16
right then we are closing that and then we have the closing of the entity view
8:20
we have the closing of the entity view
8:20
we have the closing of the entity view so this way using we can get the data
8:22
so this way using we can get the data
8:23
so this way using we can get the data from The View right apart from that we
8:26
from The View right apart from that we
8:26
from The View right apart from that we can also use the other things like we
8:28
can also use the other things like we
8:28
can also use the other things like we can use the entity lay we can use the
8:30
can use the entity lay we can use the
8:30
can use the entity lay we can use the fetch XML as well so I will I will have
8:33
fetch XML as well so I will I will have
8:34
fetch XML as well so I will I will have another you know another slide is there
8:36
another you know another slide is there
8:36
another you know another slide is there for the fetch XML which I will show you
8:38
for the fetch XML which I will show you
8:38
for the fetch XML which I will show you that how we can use the fetch XML code
8:40
that how we can use the fetch XML code
8:40
that how we can use the fetch XML code to get the data but this is how we can
8:43
to get the data but this is how we can
8:43
to get the data but this is how we can use from the entity
8:49
view okay so now we we saw that yes we
8:54
view okay so now we we saw that yes we
8:54
view okay so now we we saw that yes we can get the data from the table what
8:56
can get the data from the table what
8:56
can get the data from the table what about the security right so
8:59
about the security right so
8:59
about the security right so by default we have a different you know
9:02
by default we have a different you know
9:02
by default we have a different you know option that is applied to the security
9:05
option that is applied to the security
9:05
option that is applied to the security of the you know uh portal that what data
9:09
of the you know uh portal that what data
9:09
of the you know uh portal that what data you are seeing that is basically totally
9:11
you are seeing that is basically totally
9:11
you are seeing that is basically totally dependent on that what type of
9:13
dependent on that what type of
9:13
dependent on that what type of permissions that you have right but the
9:16
permissions that you have right but the
9:16
permissions that you have right but the permission will be only applied when you
9:18
permission will be only applied when you
9:18
permission will be only applied when you will log into that right so when you
9:20
will log into that right so when you
9:20
will log into that right so when you will log into that it will get that user
9:22
will log into that it will get that user
9:22
will log into that it will get that user and then once the user object is there
9:25
and then once the user object is there
9:25
and then once the user object is there then it will identify okay what are the
9:26
then it will identify okay what are the
9:26
then it will identify okay what are the permission assigned to this particular
9:28
permission assigned to this particular
9:28
permission assigned to this particular user but let's take an example that we
9:31
user but let's take an example that we
9:31
user but let's take an example that we have a web page when user is just you
9:33
have a web page when user is just you
9:33
have a web page when user is just you know going through browsing that web
9:35
know going through browsing that web
9:35
know going through browsing that web page and we want to check that if this
9:37
page and we want to check that if this
9:37
page and we want to check that if this user is authenticated user or not
9:40
user is authenticated user or not
9:40
user is authenticated user or not authenticated so we can use this control
9:43
authenticated so we can use this control
9:43
authenticated so we can use this control using IF user so user is a object
9:46
using IF user so user is a object
9:46
using IF user so user is a object basically which contains that
9:48
basically which contains that
9:48
basically which contains that information of the user who is you know
9:51
information of the user who is you know
9:51
information of the user who is you know logged in so if user is logged in then
9:53
logged in so if user is logged in then
9:53
logged in so if user is logged in then all the information will be there in
9:55
all the information will be there in
9:56
all the information will be there in this object if they are not logged in
9:58
this object if they are not logged in
9:58
this object if they are not logged in then this will be blank right so we are
10:01
then this will be blank right so we are
10:01
then this will be blank right so we are checking here that if this user it means
10:03
checking here that if this user it means
10:04
checking here that if this user it means it is a authenticated
10:06
it is a authenticated
10:06
it is a authenticated user and then next here you can see that
10:09
user and then next here you can see that
10:09
user and then next here you can see that this is another way that we are
10:11
this is another way that we are
10:11
this is another way that we are basically directly just getting a
10:13
basically directly just getting a
10:13
basically directly just getting a particular record ID and based on that
10:16
particular record ID and based on that
10:16
particular record ID and based on that record ID we are fetching this one
10:18
record ID we are fetching this one
10:18
record ID we are fetching this one record so you can see here that this
10:21
record so you can see here that this
10:21
record so you can see here that this user it will go ahead and normally the
10:24
user it will go ahead and normally the
10:24
user it will go ahead and normally the user that is accessing uh you know power
10:27
user that is accessing uh you know power
10:27
user that is accessing uh you know power pages are basically contact records okay
10:31
pages are basically contact records okay
10:31
pages are basically contact records okay we can have that user as well but not
10:33
we can have that user as well but not
10:33
we can have that user as well but not most of the time we use the contact as a
10:36
most of the time we use the contact as a
10:36
most of the time we use the contact as a portal user so when this user will be
10:38
portal user so when this user will be
10:38
portal user so when this user will be logged in it will go ahead and check
10:41
logged in it will go ahead and check
10:41
logged in it will go ahead and check that what is the parent customer ID so
10:43
that what is the parent customer ID so
10:43
that what is the parent customer ID so which is the parent account okay and
10:46
which is the parent account okay and
10:46
which is the parent account okay and from that account it will get that
10:48
from that account it will get that
10:48
from that account it will get that particular gu ID of that account and
10:50
particular gu ID of that account and
10:50
particular gu ID of that account and then it will try to query this account
10:53
then it will try to query this account
10:53
then it will try to query this account entity so you can see here we have that
10:55
entity so you can see here we have that
10:55
entity so you can see here we have that entity object and then under entity
10:57
entity object and then under entity
10:58
entity object and then under entity object we have account and then through
11:00
object we have account and then through
11:00
object we have account and then through that account it's getting that ID and
11:02
that account it's getting that ID and
11:02
that account it's getting that ID and then assigning to the account object
11:05
then assigning to the account object
11:05
then assigning to the account object okay now here on that account object
11:09
okay now here on that account object
11:09
okay now here on that account object once it is assigned it is checking that
11:12
once it is assigned it is checking that
11:12
once it is assigned it is checking that if this account means it has some
11:14
if this account means it has some
11:14
if this account means it has some information it return some information
11:17
information it return some information
11:17
information it return some information okay if that is correct then it will go
11:20
okay if that is correct then it will go
11:20
okay if that is correct then it will go ahead and it will check the next
11:22
ahead and it will check the next
11:22
ahead and it will check the next condition that it's checking this
11:24
condition that it's checking this
11:24
condition that it's checking this account permission can read it means
11:27
account permission can read it means
11:27
account permission can read it means that particular user have the read
11:29
that particular user have the read
11:29
that particular user have the read permission on the account if yes then it
11:32
permission on the account if yes then it
11:32
permission on the account if yes then it will go ahead and it will print name of
11:35
will go ahead and it will print name of
11:35
will go ahead and it will print name of the customer okay so this customer that
11:37
the customer okay so this customer that
11:37
the customer okay so this customer that this user is related to
11:40
this user is related to
11:40
this user is related to right and if that is not there it means
11:44
right and if that is not there it means
11:44
right and if that is not there it means this user is not authenticated then it
11:46
this user is not authenticated then it
11:46
this user is not authenticated then it will come here on the else part and it
11:48
will come here on the else part and it
11:48
will come here on the else part and it will display unknown company means that
11:51
will display unknown company means that
11:51
will display unknown company means that we are not able to identify that what is
11:53
we are not able to identify that what is
11:53
we are not able to identify that what is the company for this user because they
11:54
the company for this user because they
11:54
the company for this user because they are not authenticated right so this way
11:58
are not authenticated right so this way
11:58
are not authenticated right so this way we can use use the table permissions
12:01
we can use use the table permissions
12:01
we can use use the table permissions here to identify that user using the
12:04
here to identify that user using the
12:04
here to identify that user using the liquid code
12:06
liquid code
12:06
liquid code okay so uh this this is very useful here
12:10
okay so uh this this is very useful here
12:10
okay so uh this this is very useful here for you know some kind of the
12:11
for you know some kind of the
12:11
for you know some kind of the redirection as well so sometime we say
12:13
redirection as well so sometime we say
12:14
redirection as well so sometime we say that you know when uh somebody will try
12:16
that you know when uh somebody will try
12:16
that you know when uh somebody will try to you know access your web page if they
12:18
to you know access your web page if they
12:18
to you know access your web page if they are user you know authenticated then we
12:22
are user you know authenticated then we
12:22
are user you know authenticated then we will show that content if they are not
12:24
will show that content if they are not
12:24
will show that content if they are not authenticated we will transfer them to
12:26
authenticated we will transfer them to
12:26
authenticated we will transfer them to the you know uh the page where signin
12:28
the you know uh the page where signin
12:28
the you know uh the page where signin page they can go ahead and they can you
12:30
page they can go ahead and they can you
12:30
page they can go ahead and they can you know enter their credentials and so that
12:32
know enter their credentials and so that
12:32
know enter their credentials and so that they can be logged into the power pages
12:35
they can be logged into the power pages
12:35
they can be logged into the power pages so that's how we use this kind of uh you
12:38
so that's how we use this kind of uh you
12:38
so that's how we use this kind of uh you know liquid tags or liquid
12:41
know liquid tags or liquid
12:41
know liquid tags or liquid controls to check that user
12:44
controls to check that user
12:44
controls to check that user security
12:46
security
12:46
security okay so
12:49
okay so
12:49
okay so now so we know that how to get the data
12:53
now so we know that how to get the data
12:53
now so we know that how to get the data now we know that how we can use liquid
12:56
now we know that how we can use liquid
12:56
now we know that how we can use liquid uh you know code to check that
12:58
uh you know code to check that
12:58
uh you know code to check that permission
12:59
permission
12:59
permission but what is the permission how it is set
13:01
but what is the permission how it is set
13:01
but what is the permission how it is set up and all those things here so you can
13:04
up and all those things here so you can
13:04
up and all those things here so you can see that now in this screen this is
13:06
see that now in this screen this is
13:06
see that now in this screen this is basically the default screen that we get
13:09
basically the default screen that we get
13:09
basically the default screen that we get when we try to set up uh the table
13:11
when we try to set up uh the table
13:11
when we try to set up uh the table permission so just consider like if if
13:14
permission so just consider like if if
13:14
permission so just consider like if if you are already you know working with
13:16
you are already you know working with
13:16
you are already you know working with the data ver just you know you might be
13:19
the data ver just you know you might be
13:19
the data ver just you know you might be aware of the SQL uh sorry the security
13:22
aware of the SQL uh sorry the security
13:22
aware of the SQL uh sorry the security roles right under that security roles we
13:25
roles right under that security roles we
13:25
roles right under that security roles we have options basically there are two
13:28
have options basically there are two
13:28
have options basically there are two major options that I will say when we
13:30
major options that I will say when we
13:30
major options that I will say when we configure security role we have that
13:32
configure security role we have that
13:32
configure security role we have that access level which you know allow that
13:34
access level which you know allow that
13:34
access level which you know allow that up to what level you can see that
13:36
up to what level you can see that
13:36
up to what level you can see that information and then we have different
13:38
information and then we have different
13:38
information and then we have different set of permissions so those things are
13:41
set of permissions so those things are
13:41
set of permissions so those things are same here on the table permission as
13:43
same here on the table permission as
13:43
same here on the table permission as well you can see that this is basically
13:46
well you can see that this is basically
13:46
well you can see that this is basically the table that will tell you that okay
13:48
the table that will tell you that okay
13:48
the table that will tell you that okay on which table you are setting up the
13:50
on which table you are setting up the
13:50
on which table you are setting up the permission and then we have that access
13:53
permission and then we have that access
13:53
permission and then we have that access type these are the different different
13:55
type these are the different different
13:55
type these are the different different you know access levels are there that up
13:58
you know access levels are there that up
13:58
you know access levels are there that up to what level you can uh you know reach
14:00
to what level you can uh you know reach
14:00
to what level you can uh you know reach and you can get the data okay so we have
14:04
and you can get the data okay so we have
14:04
and you can get the data okay so we have different level here we have the global
14:06
different level here we have the global
14:06
different level here we have the global lbel we have the self we have the
14:07
lbel we have the self we have the
14:07
lbel we have the self we have the contact so all all these we will be
14:09
contact so all all these we will be
14:09
contact so all all these we will be discussing on the our next session where
14:12
discussing on the our next session where
14:12
discussing on the our next session where we will discuss all the web roles but
14:14
we will discuss all the web roles but
14:15
we will discuss all the web roles but just to give you an intro this is the
14:16
just to give you an intro this is the
14:16
just to give you an intro this is the access level so we need to set up so for
14:18
access level so we need to set up so for
14:18
access level so we need to set up so for example here right now this is a global
14:20
example here right now this is a global
14:20
example here right now this is a global access means that they can access that
14:23
access means that they can access that
14:23
access means that they can access that account record created by anybody so it
14:26
account record created by anybody so it
14:26
account record created by anybody so it can access you know complete
14:28
can access you know complete
14:28
can access you know complete organization
14:29
organization
14:29
organization account information here so it will
14:31
account information here so it will
14:31
account information here so it will display all the customers so this user
14:34
display all the customers so this user
14:34
display all the customers so this user if I will give this Global access means
14:36
if I will give this Global access means
14:36
if I will give this Global access means this user can read all the customer from
14:40
this user can read all the customer from
14:40
this user can read all the customer from the organization where this power page
14:42
the organization where this power page
14:42
the organization where this power page is connected to
14:44
is connected to
14:44
is connected to okay and then here we have the
14:46
okay and then here we have the
14:47
okay and then here we have the permissions so we can see here we have
14:48
permissions so we can see here we have
14:48
permissions so we can see here we have the read update create delete append and
14:52
the read update create delete append and
14:52
the read update create delete append and append to so these are basically most
14:54
append to so these are basically most
14:54
append to so these are basically most forly used the card you know uh set of
14:57
forly used the card you know uh set of
14:57
forly used the card you know uh set of permissions that is there so if the user
14:59
permissions that is there so if the user
14:59
permissions that is there so if the user can read the data or not if they can
15:01
can read the data or not if they can
15:01
can read the data or not if they can edit the data or not if they can you
15:03
edit the data or not if they can you
15:03
edit the data or not if they can you know create some new record or not if
15:06
know create some new record or not if
15:06
know create some new record or not if they can you know delete some record or
15:08
they can you know delete some record or
15:08
they can you know delete some record or not or append append to means they can
15:10
not or append append to means they can
15:10
not or append append to means they can associate do the association between two
15:12
associate do the association between two
15:12
associate do the association between two records right so they can set up the
15:14
records right so they can set up the
15:14
records right so they can set up the lookup or not so these These are the
15:17
lookup or not so these These are the
15:17
lookup or not so these These are the detail that is basically configured
15:19
detail that is basically configured
15:19
detail that is basically configured using the table permissions okay so in
15:23
using the table permissions okay so in
15:23
using the table permissions okay so in order to access the data yes we know
15:26
order to access the data yes we know
15:26
order to access the data yes we know that we can use the you know entity list
15:28
that we can use the you know entity list
15:28
that we can use the you know entity list and entity view entities as well to get
15:32
and entity view entities as well to get
15:32
and entity view entities as well to get the data but if you don't have the
15:34
the data but if you don't have the
15:34
the data but if you don't have the permission then you won't get the data
15:36
permission then you won't get the data
15:36
permission then you won't get the data right you need to have the table
15:38
right you need to have the table
15:38
right you need to have the table permission only then that data will be
15:41
permission only then that data will be
15:41
permission only then that data will be accessible by you okay otherwise you
15:44
accessible by you okay otherwise you
15:45
accessible by you okay otherwise you cannot do that data so these are the
15:46
cannot do that data so these are the
15:46
cannot do that data so these are the high level steps so when we want to go
15:48
high level steps so when we want to go
15:48
high level steps so when we want to go ahead and you know configure that we can
15:50
ahead and you know configure that we can
15:50
ahead and you know configure that we can select this uh you know uh these these
15:53
select this uh you know uh these these
15:53
select this uh you know uh these these details to set up the permission of the
15:56
details to set up the permission of the
15:56
details to set up the permission of the table yeah
16:00
table yeah
16:00
table yeah okay so
16:03
okay so
16:03
okay so now we uh we saw like now that basic uh
16:07
now we uh we saw like now that basic uh
16:07
now we uh we saw like now that basic uh you know introduction about that uh
16:09
you know introduction about that uh
16:09
you know introduction about that uh permissions now how about if we want to
16:12
permissions now how about if we want to
16:12
permissions now how about if we want to you know uh yes there is a view that
16:14
you know uh yes there is a view that
16:15
you know uh yes there is a view that okay that view is already created you
16:16
okay that view is already created you
16:16
okay that view is already created you are fetching the data from The View
16:18
are fetching the data from The View
16:18
are fetching the data from The View that's there but if you want to write
16:20
that's there but if you want to write
16:20
that's there but if you want to write your own query okay you want to design
16:23
your own query okay you want to design
16:23
your own query okay you want to design your own query so we have this Advanced
16:26
your own query so we have this Advanced
16:26
your own query so we have this Advanced find that we mostly used for
16:29
find that we mostly used for
16:29
find that we mostly used for while we want to write our you know
16:31
while we want to write our you know
16:31
while we want to write our you know fetchxml query so here you can see that
16:35
fetchxml query so here you can see that
16:35
fetchxml query so here you can see that when you will go to the advanced find
16:37
when you will go to the advanced find
16:37
when you will go to the advanced find feature you will get this editor where
16:39
feature you will get this editor where
16:39
feature you will get this editor where you can access you know all look for all
16:41
you can access you know all look for all
16:41
you can access you know all look for all the available table into your
16:43
the available table into your
16:43
the available table into your environment and then under that you can
16:46
environment and then under that you can
16:46
environment and then under that you can see all the fields which is basically
16:48
see all the fields which is basically
16:48
see all the fields which is basically set up as a searchable to Yes means
16:50
set up as a searchable to Yes means
16:50
set up as a searchable to Yes means those fields can be visible here under
16:52
those fields can be visible here under
16:52
those fields can be visible here under the advanced find and then you can there
16:55
the advanced find and then you can there
16:55
the advanced find and then you can there are different operators that is
16:57
are different operators that is
16:57
are different operators that is available you can do the comparison you
16:58
available you can do the comparison you
16:59
available you can do the comparison you can bring the data from you know
17:00
can bring the data from you know
17:00
can bring the data from you know different places here and depending on
17:03
different places here and depending on
17:03
different places here and depending on your requirement you can do you know uh
17:07
your requirement you can do you know uh
17:07
your requirement you can do you know uh create your query here and once uh you
17:09
create your query here and once uh you
17:09
create your query here and once uh you can then you can see that here we have
17:11
can then you can see that here we have
17:11
can then you can see that here we have the result button when you will click on
17:14
the result button when you will click on
17:14
the result button when you will click on this it will show you the data basically
17:16
this it will show you the data basically
17:16
this it will show you the data basically based on your query okay so now let's
17:20
based on your query okay so now let's
17:20
based on your query okay so now let's say for example you designed your query
17:22
say for example you designed your query
17:22
say for example you designed your query you tested it and now you want to use
17:24
you tested it and now you want to use
17:24
you tested it and now you want to use the same query to get the data into
17:26
the same query to get the data into
17:26
the same query to get the data into Power pages so you can see see here we
17:29
Power pages so you can see see here we
17:29
Power pages so you can see see here we have a download fetch XML button this
17:32
have a download fetch XML button this
17:32
have a download fetch XML button this button when you click on that it's
17:34
button when you click on that it's
17:34
button when you click on that it's basically generate the behind the scene
17:37
basically generate the behind the scene
17:37
basically generate the behind the scene what the fetch XML is generated okay so
17:40
what the fetch XML is generated okay so
17:40
what the fetch XML is generated okay so that fetch XML is basically get from
17:42
that fetch XML is basically get from
17:42
that fetch XML is basically get from here and we can directly place it under
17:45
here and we can directly place it under
17:45
here and we can directly place it under the fetch XML node on the liquid so you
17:48
the fetch XML node on the liquid so you
17:48
the fetch XML node on the liquid so you can see here we have the fetch XML node
17:50
can see here we have the fetch XML node
17:50
can see here we have the fetch XML node you know keyword that we use and then
17:54
you know keyword that we use and then
17:54
you know keyword that we use and then here I'm writing one object okay in this
17:57
here I'm writing one object okay in this
17:57
here I'm writing one object okay in this object I'm pasting my f XML that I have
17:59
object I'm pasting my f XML that I have
17:59
object I'm pasting my f XML that I have downloaded from here and then we have
18:02
downloaded from here and then we have
18:02
downloaded from here and then we have this end fxml you know tag here
18:06
this end fxml you know tag here
18:06
this end fxml you know tag here so now when we will execute this uh you
18:10
so now when we will execute this uh you
18:10
so now when we will execute this uh you know page where we have we are using
18:13
know page where we have we are using
18:13
know page where we have we are using this web template under that it will go
18:16
this web template under that it will go
18:16
this web template under that it will go ahead and get the data for us and then
18:19
ahead and get the data for us and then
18:19
ahead and get the data for us and then you can see here under that accounts
18:21
you can see here under that accounts
18:22
you can see here under that accounts object that is basically you know
18:23
object that is basically you know
18:23
object that is basically you know contain all the result set that is
18:25
contain all the result set that is
18:25
contain all the result set that is written by this query so I'm right now
18:28
written by this query so I'm right now
18:28
written by this query so I'm right now for example I have you know written a
18:30
for example I have you know written a
18:30
for example I have you know written a query that I'm using that relationship
18:32
query that I'm using that relationship
18:32
query that I'm using that relationship type is equal to vendor so I just want
18:34
type is equal to vendor so I just want
18:34
type is equal to vendor so I just want to get the list of the vendor from my
18:37
to get the list of the vendor from my
18:37
to get the list of the vendor from my environment and then same here I'm using
18:40
environment and then same here I'm using
18:40
environment and then same here I'm using the for Loop to go through that all that
18:43
the for Loop to go through that all that
18:43
the for Loop to go through that all that data that is part of this object one by
18:46
data that is part of this object one by
18:46
data that is part of this object one by one and then we can print here using the
18:50
one and then we can print here using the
18:50
one and then we can print here using the the item that we are using for that
18:52
the item that we are using for that
18:52
the item that we are using for that looping okay so this way we can use our
18:56
looping okay so this way we can use our
18:56
looping okay so this way we can use our P XML and you can design your query and
19:00
P XML and you can design your query and
19:00
P XML and you can design your query and use the fxml to get the data from the
19:02
use the fxml to get the data from the
19:02
use the fxml to get the data from the different table so whatever table you
19:04
different table so whatever table you
19:04
different table so whatever table you want to use but make sure you have a
19:06
want to use but make sure you have a
19:06
want to use but make sure you have a required permission only then you can
19:08
required permission only then you can
19:09
required permission only then you can access that data otherwise that won't be
19:12
access that data otherwise that won't be
19:12
access that data otherwise that won't be displayed okay and just similarly for
19:15
displayed okay and just similarly for
19:15
displayed okay and just similarly for example if you are using some you know
19:17
example if you are using some you know
19:17
example if you are using some you know out of the box uh controls that is
19:20
out of the box uh controls that is
19:20
out of the box uh controls that is available there for the let's say list
19:22
available there for the let's say list
19:22
available there for the let's say list View and if you don't have the
19:23
View and if you don't have the
19:23
View and if you don't have the permission you will get that you don't
19:25
permission you will get that you don't
19:25
permission you will get that you don't have permission or there is no data you
19:27
have permission or there is no data you
19:27
have permission or there is no data you know visible by because of this security
19:30
know visible by because of this security
19:30
know visible by because of this security permission that you don't have right but
19:32
permission that you don't have right but
19:32
permission that you don't have right but in term of the code it won't show you
19:35
in term of the code it won't show you
19:35
in term of the code it won't show you you can display your own custom message
19:37
you can display your own custom message
19:37
you can display your own custom message otherwise it will be blank right so this
19:41
otherwise it will be blank right so this
19:41
otherwise it will be blank right so this is uh this is that fetchxml then how we
19:44
is uh this is that fetchxml then how we
19:44
is uh this is that fetchxml then how we can use on that now let's see all this
19:47
can use on that now let's see all this
19:47
can use on that now let's see all this in the demo we will see that how we can
19:49
in the demo we will see that how we can
19:49
in the demo we will see that how we can apply all these
19:51
apply all these
19:51
apply all these liquid keywords into the web template
19:54
liquid keywords into the web template
19:54
liquid keywords into the web template and then how we can use that web
19:56
and then how we can use that web
19:56
and then how we can use that web template on the web pages to see the
19:58
template on the web pages to see the
19:58
template on the web pages to see the data okay so uh over to you bit now you
20:03
data okay so uh over to you bit now you
20:03
data okay so uh over to you bit now you can see the you know demo
20:05
can see the you know demo
20:05
can see the you know demo for
20:15
here do confirm once you can see my
20:26
screen uh we cannot see it
20:32
yet about
20:37
no no not
20:46
yet do you see my power Pages now we can
20:49
yet do you see my power Pages now we can
20:49
yet do you see my power Pages now we can see yes now we can see
20:53
it
20:55
it
20:55
it okay uh so just I have logged into my
20:58
okay uh so just I have logged into my
20:58
okay uh so just I have logged into my our Pages uh portal and I'm just syncing
21:02
our Pages uh portal and I'm just syncing
21:02
our Pages uh portal and I'm just syncing the
21:03
the
21:03
the configurations uh so just allow the
21:05
configurations uh so just allow the
21:05
configurations uh so just allow the minute to go for it
21:40
okay so if You observe here um I see my
21:44
okay so if You observe here um I see my
21:44
okay so if You observe here um I see my in the my visual studio code this is the
21:46
in the my visual studio code this is the
21:46
in the my visual studio code this is the first example uh where
21:49
first example uh where
21:49
first example uh where uh okay it is still loading
21:54
uh okay it is still loading
21:54
uh okay it is still loading okay so Mahindra can you confirm you see
21:57
okay so Mahindra can you confirm you see
21:57
okay so Mahindra can you confirm you see my first screen here in the
22:01
my first screen here in the
22:01
my first screen here in the navigation
22:04
navigation
22:04
navigation yeah I can
22:05
yeah I can
22:05
yeah I can see so
22:09
see so
22:09
see so here
22:13
okay so let me zoom in
22:25
here so here what I am doing right so
22:28
here so here what I am doing right so
22:28
here so here what I am doing right so just I went into this uh uh the power
22:31
just I went into this uh uh the power
22:31
just I went into this uh uh the power Pages uh and then I created one page and
22:34
Pages uh and then I created one page and
22:35
Pages uh and then I created one page and I named it as an liquid session two
22:37
I named it as an liquid session two
22:37
I named it as an liquid session two after that just I clicked on this edit
22:39
after that just I clicked on this edit
22:39
after that just I clicked on this edit code if I click on this edit code it
22:41
code if I click on this edit code it
22:42
code if I click on this edit code it will go and to this Vis Studio code that
22:45
will go and to this Vis Studio code that
22:45
will go and to this Vis Studio code that is online so here what I'm going to do
22:48
is online so here what I'm going to do
22:48
is online so here what I'm going to do here is I have kept this as an liquid
22:51
here is I have kept this as an liquid
22:51
here is I have kept this as an liquid session to as an paragraph and then I
22:54
session to as an paragraph and then I
22:54
session to as an paragraph and then I have included the key terms like the
22:56
have included the key terms like the
22:56
have included the key terms like the entity view its logical name name is
22:58
entity view its logical name name is
22:58
entity view its logical name name is account in this name I have used it as
23:01
account in this name I have used it as
23:01
account in this name I have used it as an all accounts so here this all
23:03
an all accounts so here this all
23:03
an all accounts so here this all accounts is nothing but one of my view
23:06
accounts is nothing but one of my view
23:06
accounts is nothing but one of my view name that is present in an account so
23:08
name that is present in an account so
23:08
name that is present in an account so here my intent was uh I would like to
23:11
here my intent was uh I would like to
23:11
here my intent was uh I would like to show all the list of all accounts what
23:14
show all the list of all accounts what
23:14
show all the list of all accounts what are all present and uh how many total
23:17
are all present and uh how many total
23:17
are all present and uh how many total account records that I having it so for
23:20
account records that I having it so for
23:20
account records that I having it so for that just I have used the UN AED list
23:24
that just I have used the UN AED list
23:24
that just I have used the UN AED list and also an list so for what I am going
23:27
and also an list so for what I am going
23:27
and also an list so for what I am going to do if I I have to use entity View and
23:30
to do if I I have to use entity View and
23:30
to do if I I have to use entity View and logical name as account and all accounts
23:32
logical name as account and all accounts
23:32
logical name as account and all accounts that means for this entity view I am
23:34
that means for this entity view I am
23:34
that means for this entity view I am giving as account as a logical name so
23:38
giving as account as a logical name so
23:38
giving as account as a logical name so here by giving this one all the accounts
23:41
here by giving this one all the accounts
23:41
here by giving this one all the accounts all accounts related view its records
23:44
all accounts related view its records
23:44
all accounts related view its records will come and sit inside this entity
23:46
will come and sit inside this entity
23:46
will come and sit inside this entity view so just I'm looping in here for ACC
23:50
view so just I'm looping in here for ACC
23:50
view so just I'm looping in here for ACC means the account which is present in
23:52
means the account which is present in
23:52
means the account which is present in for each and every account that is
23:53
for each and every account that is
23:53
for each and every account that is present in entity view. records just I
23:56
present in entity view. records just I
23:56
present in entity view. records just I am uh printing the ACC do
23:59
am uh printing the ACC do
23:59
am uh printing the ACC do name so I am going to iterate this till
24:03
name so I am going to iterate this till
24:03
name so I am going to iterate this till I see my all the list of items gets
24:06
I see my all the list of items gets
24:06
I see my all the list of items gets completed and then I'll be uh closing
24:09
completed and then I'll be uh closing
24:09
completed and then I'll be uh closing this particular entity view so if I go
24:12
this particular entity view so if I go
24:12
this particular entity view so if I go back to here and see it here in the
24:14
back to here and see it here in the
24:14
back to here and see it here in the liquid session to uh If You observe I
24:18
liquid session to uh If You observe I
24:18
liquid session to uh If You observe I have the three accounts that are present
24:21
have the three accounts that are present
24:21
have the three accounts that are present and uh we have the three total total
24:23
and uh we have the three total total
24:23
and uh we have the three total total three customers that are present out of
24:26
three customers that are present out of
24:26
three customers that are present out of which one test account test account one
24:28
which one test account test account one
24:28
which one test account test account one and test account to our uh
24:35
present so here if you see in the
24:45
data so if you see this account table
25:04
see I have three records that are
25:06
see I have three records that are
25:06
see I have three records that are present if I go back to here and see it
25:10
present if I go back to here and see it
25:10
present if I go back to here and see it here I have the test account test
25:11
here I have the test account test
25:11
here I have the test account test account one and test account two are
25:16
present in the same way I can go for the
25:18
present in the same way I can go for the
25:18
present in the same way I can go for the test
25:19
test
25:19
test account three
25:32
I just saving it it has saved now let me
25:36
I just saving it it has saved now let me
25:36
I just saving it it has saved now let me refresh
25:39
It If You observe I have the test
25:42
It If You observe I have the test
25:42
It If You observe I have the test account 1 2 and three are the accounts
25:45
account 1 2 and three are the accounts
25:45
account 1 2 and three are the accounts that are present so if You observe what
25:47
that are present so if You observe what
25:47
that are present so if You observe what is this one is the entity view is
25:49
is this one is the entity view is
25:49
is this one is the entity view is present if you use the entity view you
25:51
present if you use the entity view you
25:51
present if you use the entity view you can directly give this all accounts one
25:54
can directly give this all accounts one
25:54
can directly give this all accounts one so Here If You observe this is the in
25:57
so Here If You observe this is the in
25:57
so Here If You observe this is the in the this
25:59
the this
25:59
the this view I have this all accounts are
26:02
view I have this all accounts are
26:02
view I have this all accounts are present if I go back and see this all
26:10
accounts this all accounts have this
26:12
accounts this all accounts have this
26:12
accounts this all accounts have this account name and the main phone and the
26:14
account name and the main phone and the
26:14
account name and the main phone and the uh address one is present so that's what
26:17
uh address one is present so that's what
26:17
uh address one is present so that's what uh you can see it here so here just I
26:20
uh you can see it here so here just I
26:20
uh you can see it here so here just I have used the name only so that's why
26:22
have used the name only so that's why
26:22
have used the name only so that's why you are seeing this account test account
26:24
you are seeing this account test account
26:24
you are seeing this account test account name only so if you go back to here and
26:26
name only so if you go back to here and
26:26
name only so if you go back to here and see this account name and see here what
26:29
see this account name and see here what
26:29
see this account name and see here what is The Logical name that is present
26:32
is The Logical name that is present
26:32
is The Logical name that is present which is nothing but name so account.
26:36
which is nothing but name so account.
26:36
which is nothing but name so account. name which will provide you that the
26:39
name which will provide you that the
26:39
name which will provide you that the name it is
26:44
present now going back to the next page
26:48
present now going back to the next page
26:48
present now going back to the next page of
26:50
of
26:50
of it so here what I'm going to do it is uh
26:55
it so here what I'm going to do it is uh
26:55
it so here what I'm going to do it is uh I'm trying to uh if I am an authorized
26:58
I'm trying to uh if I am an authorized
26:59
I'm trying to uh if I am an authorized user then I'm going to print one
27:01
user then I'm going to print one
27:01
user then I'm going to print one particular account which is present here
27:04
particular account which is present here
27:04
particular account which is present here so in this list I have the test account
27:06
so in this list I have the test account
27:06
so in this list I have the test account right I am trying to print this
27:08
right I am trying to print this
27:08
right I am trying to print this particular test account if I'm an
27:10
particular test account if I'm an
27:10
particular test account if I'm an authenticated user if I am not an
27:11
authenticated user if I am not an
27:12
authenticated user if I am not an authenticated user then if You
27:15
authenticated user then if You
27:15
authenticated user then if You observe so I going to see it we are
27:18
observe so I going to see it we are
27:18
observe so I going to see it we are unable to provide any information to
27:19
unable to provide any information to
27:19
unable to provide any information to Anonymous visitors so Anonymous visitors
27:23
Anonymous visitors so Anonymous visitors
27:23
Anonymous visitors so Anonymous visitors means uh the people who don't have the
27:25
means uh the people who don't have the
27:25
means uh the people who don't have the access for it so I'm trying to give the
27:28
access for it so I'm trying to give the
27:28
access for it so I'm trying to give the access or to show the account details
27:30
access or to show the account details
27:31
access or to show the account details for the authenticated users only so just
27:33
for the authenticated users only so just
27:33
for the authenticated users only so just I'm going to sign
27:35
I'm going to sign
27:35
I'm going to sign in I'm going to use the Microsoft enter
27:38
in I'm going to use the Microsoft enter
27:38
in I'm going to use the Microsoft enter ID as an external
27:41
account then if I go to this same liquid
27:44
account then if I go to this same liquid
27:44
account then if I go to this same liquid session 2 one I see this company test
27:47
session 2 one I see this company test
27:47
session 2 one I see this company test account so let us go back to here and
27:50
account so let us go back to here and
27:50
account so let us go back to here and see the
27:52
see the
27:52
see the pages go back to here
27:58
and what I did just I created another
28:01
and what I did just I created another
28:01
and what I did just I created another page which is liquid session 2 hyphen 1
28:04
page which is liquid session 2 hyphen 1
28:04
page which is liquid session 2 hyphen 1 and in this just I clicked on edit
28:12
code and it opens into the visual studio
28:21
code okay so here what I am doing it is
28:27
code okay so here what I am doing it is
28:27
code okay so here what I am doing it is if user us that means if I am an
28:29
if user us that means if I am an
28:29
if user us that means if I am an authenticated user then I'm going to
28:32
authenticated user then I'm going to
28:32
authenticated user then I'm going to show it like what I'm doing right I'm
28:36
show it like what I'm doing right I'm
28:36
show it like what I'm doing right I'm just assigning a value that is to the
28:38
just assigning a value that is to the
28:38
just assigning a value that is to the account where entities dot the list of
28:41
account where entities dot the list of
28:41
account where entities dot the list of entities if the entities is account in
28:44
entities if the entities is account in
28:44
entities if the entities is account in that account I'm just taking the first
28:46
that account I'm just taking the first
28:46
that account I'm just taking the first account that is my test account that is
28:50
account that is my test account that is
28:50
account that is my test account that is present that is the test account that
28:52
present that is the test account that
28:52
present that is the test account that means I have the list of accounts that
28:53
means I have the list of accounts that
28:53
means I have the list of accounts that are present test account test account
28:55
are present test account test account
28:55
are present test account test account one test account two test account three
28:57
one test account two test account three
28:57
one test account two test account three I took the test account one guid and
29:00
I took the test account one guid and
29:00
I took the test account one guid and then just I kept it here and I assigned
29:03
then just I kept it here and I assigned
29:03
then just I kept it here and I assigned that to the account so if the account
29:06
that to the account so if the account
29:07
that to the account so if the account next I'm going to use the if condition
29:09
next I'm going to use the if condition
29:09
next I'm going to use the if condition which I have explained it in my previous
29:11
which I have explained it in my previous
29:11
which I have explained it in my previous session if account has value and account
29:15
session if account has value and account
29:15
session if account has value and account you have the permissions that is can
29:18
you have the permissions that is can
29:18
you have the permissions that is can read then I'm going to show the company
29:20
read then I'm going to show the company
29:20
read then I'm going to show the company as an account. name if this account does
29:23
as an account. name if this account does
29:23
as an account. name if this account does not have the permissions to read then
29:25
not have the permissions to read then
29:25
not have the permissions to read then I'll be showing as an unknown company if
29:28
I'll be showing as an unknown company if
29:28
I'll be showing as an unknown company if at all the user itself is not an
29:31
at all the user itself is not an
29:31
at all the user itself is not an authenticated user then I'm going to uh
29:33
authenticated user then I'm going to uh
29:33
authenticated user then I'm going to uh show it like this we are unable to
29:35
show it like this we are unable to
29:35
show it like this we are unable to provide any information to the anonymous
29:38
provide any information to the anonymous
29:38
provide any information to the anonymous visitors so how this is been carried
29:45
is so I went to the
29:48
is so I went to the
29:48
is so I went to the security and then I went to the table
29:53
security and then I went to the table
29:53
security and then I went to the table permissions here what I did was I
29:56
permissions here what I did was I
29:56
permissions here what I did was I created a new permission and then just
29:59
created a new permission and then just
29:59
created a new permission and then just added as an access to account and I have
30:01
added as an access to account and I have
30:01
added as an access to account and I have selected account and then I have given
30:03
selected account and then I have given
30:03
selected account and then I have given the global access and then I have given
30:06
the global access and then I have given
30:06
the global access and then I have given the read update delete and append uh and
30:10
the read update delete and append uh and
30:10
the read update delete and append uh and also after that I have add the rules as
30:12
also after that I have add the rules as
30:12
also after that I have add the rules as an authenticated users
30:15
an authenticated users
30:15
an authenticated users so let me go back to this
30:18
so let me go back to this
30:18
so let me go back to this one so if You observe I have provided
30:21
one so if You observe I have provided
30:21
one so if You observe I have provided the name as access to account data given
30:24
the name as access to account data given
30:24
the name as access to account data given the table as an account and access type
30:26
the table as an account and access type
30:26
the table as an account and access type as a global access and what kind of
30:28
as a global access and what kind of
30:28
as a global access and what kind of permission that means any people who
30:30
permission that means any people who
30:30
permission that means any people who have this particular access or the
30:31
have this particular access or the
30:31
have this particular access or the permission table permission they what
30:34
permission table permission they what
30:34
permission table permission they what they can do they can read update create
30:36
they can do they can read update create
30:37
they can do they can read update create I'll update the delete as well
30:40
I'll update the delete as well
30:40
I'll update the delete as well and which kind of roled users they can
30:43
and which kind of roled users they can
30:43
and which kind of roled users they can uh possess this uh table permission is
30:49
uh possess this uh table permission is
30:49
uh possess this uh table permission is the authenticator uses how you can use
30:51
the authenticator uses how you can use
30:51
the authenticator uses how you can use it is you can click on the ad roles and
30:54
it is you can click on the ad roles and
30:54
it is you can click on the ad roles and you can click on this one so I'm going
30:56
you can click on this one so I'm going
30:56
you can click on this one so I'm going to keep the administrators as well
31:00
so if You observe you will get this
31:02
so if You observe you will get this
31:02
so if You observe you will get this administrators and then I just clicked
31:04
administrators and then I just clicked
31:04
administrators and then I just clicked on
31:11
save so this is how you can perform a
31:14
save so this is how you can perform a
31:14
save so this is how you can perform a table permissions where I have given the
31:17
table permissions where I have given the
31:17
table permissions where I have given the access to the account where uh the
31:22
access to the account where uh the
31:23
access to the account where uh the access permission has been given so I'm
31:25
access permission has been given so I'm
31:26
access permission has been given so I'm what I'm referring to it is this is ADD
31:28
what I'm referring to it is this is ADD
31:28
what I'm referring to it is this is ADD table permission so here you can do it
31:31
table permission so here you can do it
31:31
table permission so here you can do it like by giving the account data table as
31:33
like by giving the account data table as
31:33
like by giving the account data table as an account and access type as a global
31:35
an account and access type as a global
31:35
an account and access type as a global access and you have provided the
31:37
access and you have provided the
31:37
access and you have provided the permission read update along with that
31:39
permission read update along with that
31:39
permission read update along with that just I have created a create and delete
31:41
just I have created a create and delete
31:41
just I have created a create and delete and also I have added the roles as well
31:45
and also I have added the roles as well
31:45
and also I have added the roles as well so if I go back and see it here on the
31:47
so if I go back and see it here on the
31:47
so if I go back and see it here on the liquid session
31:49
liquid session
31:49
liquid session 2/1 so I see that I am an authenticated
31:52
2/1 so I see that I am an authenticated
31:52
2/1 so I see that I am an authenticated user that's where I got the company as
31:54
user that's where I got the company as
31:54
user that's where I got the company as in test account again if I go back if I
31:58
in test account again if I go back if I
31:58
in test account again if I go back if I sign out you should see this Anonymous
32:01
sign out you should see this Anonymous
32:01
sign out you should see this Anonymous we are unable to provide any information
32:03
we are unable to provide any information
32:03
we are unable to provide any information to the anonymous visitors that is what I
32:06
to the anonymous visitors that is what I
32:06
to the anonymous visitors that is what I have been written here so if I not an
32:09
have been written here so if I not an
32:09
have been written here so if I not an authenticated user then he can only see
32:12
authenticated user then he can only see
32:12
authenticated user then he can only see this information we are unable to
32:15
this information we are unable to
32:15
this information we are unable to provide any information to the anonymous
32:19
provide any information to the anonymous
32:19
provide any information to the anonymous visitors now going back to the next uh
32:22
visitors now going back to the next uh
32:22
visitors now going back to the next uh demo of it next example so what I'm
32:25
demo of it next example so what I'm
32:25
demo of it next example so what I'm going to do is just
32:29
I'm going to sign in that means an
32:31
I'm going to sign in that means an
32:31
I'm going to sign in that means an authenticated
32:35
[Music]
32:37
[Music]
32:37
[Music] user so here what I'm going to do is
32:40
user so here what I'm going to do is
32:40
user so here what I'm going to do is just I'm iterating
32:42
just I'm iterating
32:42
just I'm iterating through all the list of accounts and I'm
32:45
through all the list of accounts and I'm
32:45
through all the list of accounts and I'm printing their account names side by
32:48
printing their account names side by
32:48
printing their account names side by side as test account test account one
32:50
side as test account test account one
32:50
side as test account test account one two and three like this so how it is
32:53
two and three like this so how it is
32:53
two and three like this so how it is been carried
32:55
been carried
32:55
been carried is again I went to the pages
32:58
is again I went to the pages
32:59
is again I went to the pages Went to went back to here session two of
33:04
Went to went back to here session two of
33:04
Went to went back to here session two of two what I did just I created a page and
33:08
two what I did just I created a page and
33:08
two what I did just I created a page and I have named this one and then just I
33:11
I have named this one and then just I
33:11
I have named this one and then just I clicked on edit code
33:30
so it will take some time here so okay
33:34
so it will take some time here so okay
33:34
so it will take some time here so okay what I did is just I have downloaded
33:37
what I did is just I have downloaded
33:37
what I did is just I have downloaded this particular fetch XML that is from
33:40
this particular fetch XML that is from
33:40
this particular fetch XML that is from the Advan
33:42
the Advan
33:42
the Advan find uh so I went to the Advan find and
33:47
find uh so I went to the Advan find and
33:47
find uh so I went to the Advan find and just I have selected account name which
33:49
just I have selected account name which
33:49
just I have selected account name which contains test and I just clicked on this
33:53
contains test and I just clicked on this
33:53
contains test and I just clicked on this one so I got this test account test
33:55
one so I got this test account test
33:55
one so I got this test account test account one and test account two and
33:58
account one and test account two and
33:58
account one and test account two and then if You observe
34:02
here so I have got this fetch XML where
34:06
here so I have got this fetch XML where
34:06
here so I have got this fetch XML where I am looking for the entity name as
34:08
I am looking for the entity name as
34:08
I am looking for the entity name as account and it has some filter attribute
34:10
account and it has some filter attribute
34:11
account and it has some filter attribute like the attribute name like test so
34:14
like the attribute name like test so
34:14
like the attribute name like test so just I have copied this particular fetch
34:17
just I have copied this particular fetch
34:17
just I have copied this particular fetch XML and then came back here and then
34:21
XML and then came back here and then
34:21
XML and then came back here and then just If You observe just I have copied
34:23
just If You observe just I have copied
34:23
just If You observe just I have copied and pasted here so after pasting it just
34:27
and pasted here so after pasting it just
34:27
and pasted here so after pasting it just you need to to uh include this
34:30
you need to to uh include this
34:30
you need to to uh include this particular keyword that is fetchxml
34:32
particular keyword that is fetchxml
34:32
particular keyword that is fetchxml accounts so if you perform this one then
34:36
accounts so if you perform this one then
34:36
accounts so if you perform this one then whenever the web page gets loaded then
34:41
whenever the web page gets loaded then
34:41
whenever the web page gets loaded then this gets executed and the result of
34:43
this gets executed and the result of
34:43
this gets executed and the result of these accounts that means all this
34:46
these accounts that means all this
34:46
these accounts that means all this result these four accounts the result
34:48
result these four accounts the result
34:48
result these four accounts the result set will go and SE it here in this
34:50
set will go and SE it here in this
34:50
set will go and SE it here in this particular accounts variable so now what
34:53
particular accounts variable so now what
34:53
particular accounts variable so now what I'm going to do as this accounts have
34:56
I'm going to do as this accounts have
34:56
I'm going to do as this accounts have its results entities so what I'm doing
35:00
its results entities so what I'm doing
35:00
its results entities so what I'm doing uh in this particular result of four
35:01
uh in this particular result of four
35:01
uh in this particular result of four accounts I retting to this each and
35:03
accounts I retting to this each and
35:03
accounts I retting to this each and every account and then printing that
35:06
every account and then printing that
35:06
every account and then printing that particular account how you can do that
35:08
particular account how you can do that
35:08
particular account how you can do that one is by using
35:10
one is by using
35:10
one is by using the double parenthesis the closed ones
35:13
the double parenthesis the closed ones
35:13
the double parenthesis the closed ones and the flower Braes the closed and the
35:16
and the flower Braes the closed and the
35:16
and the flower Braes the closed and the uh open paranthesis so what you are
35:18
uh open paranthesis so what you are
35:18
uh open paranthesis so what you are going to do account ACC of name so we
35:22
going to do account ACC of name so we
35:22
going to do account ACC of name so we have to make sure this particular ACC
35:24
have to make sure this particular ACC
35:24
have to make sure this particular ACC how it came is we whatever the variable
35:28
how it came is we whatever the variable
35:28
how it came is we whatever the variable that we have specified between the F
35:30
that we have specified between the F
35:30
that we have specified between the F that variable you have to use it is a
35:32
that variable you have to use it is a
35:32
that variable you have to use it is a name so name is nothing but uh my
35:36
name so name is nothing but uh my
35:36
name so name is nothing but uh my logical name of that particular column
35:38
logical name of that particular column
35:39
logical name of that particular column that is present on an account so how I'm
35:42
that is present on an account so how I'm
35:42
that is present on an account so how I'm going to do till this particular Loop
35:45
going to do till this particular Loop
35:45
going to do till this particular Loop gets completed I keep on printing this
35:48
gets completed I keep on printing this
35:48
gets completed I keep on printing this particular account
35:51
particular account
35:51
particular account name so once that is done just I'm going
35:54
name so once that is done just I'm going
35:54
name so once that is done just I'm going to click on the save
36:01
and then I'm coming back to here and
36:04
and then I'm coming back to here and
36:04
and then I'm coming back to here and just I click on
36:16
sync so once that is done just I'm going
36:20
sync so once that is done just I'm going
36:20
sync so once that is done just I'm going to click on preview and click on the
36:22
to click on preview and click on the
36:22
to click on preview and click on the desktop
36:37
so if You observe I in this liquid
36:39
so if You observe I in this liquid
36:39
so if You observe I in this liquid session 2 iPhone 2 which is nothing but
36:42
session 2 iPhone 2 which is nothing but
36:42
session 2 iPhone 2 which is nothing but my page name and in this particular page
36:46
my page name and in this particular page
36:46
my page name and in this particular page I'm printing
36:48
I'm printing
36:48
I'm printing these test account test account one test
36:51
these test account test account one test
36:51
these test account test account one test account two and test account three these
36:53
account two and test account three these
36:53
account two and test account three these are all the test accounts which I got it
36:55
are all the test accounts which I got it
36:55
are all the test accounts which I got it as an account so uh what I did just I
37:00
as an account so uh what I did just I
37:00
as an account so uh what I did just I first this fetch XML this fetchxml got
37:03
first this fetch XML this fetchxml got
37:03
first this fetch XML this fetchxml got executed after that executing of this
37:06
executed after that executing of this
37:06
executed after that executing of this particular fetch XML the values will
37:08
particular fetch XML the values will
37:08
particular fetch XML the values will come and sit in this accounts and in
37:11
come and sit in this accounts and in
37:11
come and sit in this accounts and in this accounts result each and every
37:14
this accounts result each and every
37:14
this accounts result each and every account I took it and then just am
37:15
account I took it and then just am
37:15
account I took it and then just am printing as an account of
37:17
printing as an account of
37:18
printing as an account of name with that just you can see all
37:21
name with that just you can see all
37:21
name with that just you can see all these particular accounts uh gets uh
37:24
these particular accounts uh gets uh
37:24
these particular accounts uh gets uh printed
37:27
so few points to get uh uh into the
37:33
so few points to get uh uh into the
37:33
so few points to get uh uh into the consideration
37:35
consideration
37:35
consideration was you will get some kind of issues if
37:39
was you will get some kind of issues if
37:39
was you will get some kind of issues if at all you if you don't specify the
37:42
at all you if you don't specify the
37:42
at all you if you don't specify the column name that is present so how you
37:44
column name that is present so how you
37:45
column name that is present so how you will know the column name of the logical
37:47
will know the column name of the logical
37:47
will know the column name of the logical name of the table just you have to go to
37:50
name of the table just you have to go to
37:50
name of the table just you have to go to the data and go to the respectable table
37:54
the data and go to the respectable table
37:54
the data and go to the respectable table and then look at that
37:58
and then look at that
37:58
and then look at that um logical name of
38:02
um logical name of
38:02
um logical name of it so if you go and see this logical
38:05
it so if you go and see this logical
38:05
it so if you go and see this logical name this logical name must and should
38:07
name this logical name must and should
38:07
name this logical name must and should has to match here if it does not matches
38:11
has to match here if it does not matches
38:11
has to match here if it does not matches then you will not get the proper results
38:14
then you will not get the proper results
38:14
then you will not get the proper results and in the same way if at all you don't
38:17
and in the same way if at all you don't
38:17
and in the same way if at all you don't get this accounts
38:19
get this accounts
38:19
get this accounts uh as a value then you will not
38:24
uh as a value then you will not
38:24
uh as a value then you will not see you don't see these values example
38:28
see you don't see these values example
38:28
see you don't see these values example see this just I am logging
38:30
see this just I am logging
38:30
see this just I am logging out and I'm clicking on liquid session
38:33
out and I'm clicking on liquid session
38:33
out and I'm clicking on liquid session two of two I don't see any of the values
38:36
two of two I don't see any of the values
38:36
two of two I don't see any of the values the reason
38:38
the reason
38:38
the reason is as that is for this table is accessed
38:42
is as that is for this table is accessed
38:42
is as that is for this table is accessed only by the authenticated users so
38:44
only by the authenticated users so
38:44
only by the authenticated users so unated users will not get the access and
38:47
unated users will not get the access and
38:48
unated users will not get the access and if they don't get the access this
38:49
if they don't get the access this
38:49
if they don't get the access this fetchxml statement will not get executed
38:52
fetchxml statement will not get executed
38:52
fetchxml statement will not get executed and if does not get executed then this
38:55
and if does not get executed then this
38:55
and if does not get executed then this ACC will not have any values and uh as
38:58
ACC will not have any values and uh as
38:58
ACC will not have any values and uh as it does not have any values it cannot
39:01
it does not have any values it cannot
39:01
it does not have any values it cannot print any of it so definitely you must
39:04
print any of it so definitely you must
39:04
print any of it so definitely you must and should has to be an authenticated
39:07
and should has to be an authenticated
39:07
and should has to be an authenticated user or an
39:19
administrator to uh just see these uh
39:24
administrator to uh just see these uh
39:24
administrator to uh just see these uh particular values that is test account
39:26
particular values that is test account
39:26
particular values that is test account test account one test account two and
39:28
test account one test account two and
39:28
test account one test account two and three and all so you can play around
39:30
three and all so you can play around
39:30
three and all so you can play around with the different kinds of uh um
39:35
with the different kinds of uh um
39:35
with the different kinds of uh um navigations like uh list and list view
39:38
navigations like uh list and list view
39:38
navigations like uh list and list view all these things that you can play it
39:40
all these things that you can play it
39:40
all these things that you can play it around but just here the intent is just
39:42
around but just here the intent is just
39:42
around but just here the intent is just to show how you can fetch the results
39:46
to show how you can fetch the results
39:46
to show how you can fetch the results from the fetch XML and then show that
39:49
from the fetch XML and then show that
39:49
from the fetch XML and then show that particular fetch XML results into an um
39:52
particular fetch XML results into an um
39:52
particular fetch XML results into an um the power pages on the web page as an
39:55
the power pages on the web page as an
39:55
the power pages on the web page as an web page template
39:58
web page template
39:58
web page template so if You observe here under the web
40:04
page I have these uh different liquid
40:08
page I have these uh different liquid
40:08
page I have these uh different liquid sessions that are present here so liquid
40:11
sessions that are present here so liquid
40:11
sessions that are present here so liquid session two liquid session two to two
40:13
session two liquid session two to two
40:13
session two liquid session two to two hyph 1 and two hyphen 2 uh these are all
40:16
hyph 1 and two hyphen 2 uh these are all
40:17
hyph 1 and two hyphen 2 uh these are all present if you go back and see it
40:19
present if you go back and see it
40:20
present if you go back and see it home liquid session
40:21
home liquid session
40:21
home liquid session [Music]
40:23
[Music]
40:23
[Music] two liquid session two hyphen one if it
40:27
two liquid session two hyphen one if it
40:27
two liquid session two hyphen one if it is is an authenticated user then only
40:29
is is an authenticated user then only
40:29
is is an authenticated user then only I'm giving an access for the to show or
40:33
I'm giving an access for the to show or
40:33
I'm giving an access for the to show or to view the account name of it and the
40:37
to view the account name of it and the
40:37
to view the account name of it and the third option of this particular demo the
40:38
third option of this particular demo the
40:38
third option of this particular demo the third demo is use the fetch XML and get
40:42
third demo is use the fetch XML and get
40:42
third demo is use the fetch XML and get the results from the fetch XML iterate
40:45
the results from the fetch XML iterate
40:45
the results from the fetch XML iterate this particular fetch XML results and
40:47
this particular fetch XML results and
40:47
this particular fetch XML results and then print them on an web page on the
40:50
then print them on an web page on the
40:50
then print them on an web page on the power portals so this is how uh you can
40:54
power portals so this is how uh you can
40:54
power portals so this is how uh you can easily perform this one
40:57
easily perform this one
40:58
easily perform this one like the fetchxml accounts all these
41:00
like the fetchxml accounts all these
41:00
like the fetchxml accounts all these things that you can
41:03
things that you can
41:03
things that you can perform so what to you
41:08
mahinder thank you thank you vanit for
41:10
mahinder thank you thank you vanit for
41:10
mahinder thank you thank you vanit for showing all the demo on this uh where
41:13
showing all the demo on this uh where
41:13
showing all the demo on this uh where you know can how we can get the data
41:16
you know can how we can get the data
41:16
you know can how we can get the data from data ver using different uh you
41:19
from data ver using different uh you
41:19
from data ver using different uh you know fetch XML or we can use the
41:21
know fetch XML or we can use the
41:21
know fetch XML or we can use the keywords for the you know entity view or
41:24
keywords for the you know entity view or
41:24
keywords for the you know entity view or entity list on that and uh yes the
41:28
entity list on that and uh yes the
41:28
entity list on that and uh yes the security is very much important here
41:31
security is very much important here
41:31
security is very much important here that you can only get the data if you
41:32
that you can only get the data if you
41:32
that you can only get the data if you are you know properly uh you have a
41:35
are you know properly uh you have a
41:35
are you know properly uh you have a proper permission on the table only then
41:37
proper permission on the table only then
41:37
proper permission on the table only then you can get the data and that's what we
41:39
you can get the data and that's what we
41:39
you can get the data and that's what we are going to as I said that we are going
41:41
are going to as I said that we are going
41:41
are going to as I said that we are going to cover and this is will be a whole lot
41:45
to cover and this is will be a whole lot
41:45
to cover and this is will be a whole lot of thing that you know you can not only
41:47
of thing that you know you can not only
41:47
of thing that you know you can not only the permission but up to what level
41:49
the permission but up to what level
41:49
the permission but up to what level right this what are what is your access
41:52
right this what are what is your access
41:52
right this what are what is your access level depending on that you can only
41:55
level depending on that you can only
41:55
level depending on that you can only access the database you know tables data
41:58
access the database you know tables data
41:58
access the database you know tables data so yeah that that we we will cover in
42:00
so yeah that that we we will cover in
42:01
so yeah that that we we will cover in our next sesson so that's what we wanted
42:04
our next sesson so that's what we wanted
42:04
our next sesson so that's what we wanted to cover thank you very much for joining
42:06
to cover thank you very much for joining
42:06
to cover thank you very much for joining us today keep uh you know stay tuned
42:08
us today keep uh you know stay tuned
42:08
us today keep uh you know stay tuned with us and all that our session is are
42:10
with us and all that our session is are
42:10
with us and all that our session is are there on the CH sh Corner live tv
42:13
there on the CH sh Corner live tv
42:13
there on the CH sh Corner live tv YouTube channel watch you can watch all
42:16
YouTube channel watch you can watch all
42:16
YouTube channel watch you can watch all our past uh session as well share with
42:19
our past uh session as well share with
42:19
our past uh session as well share with your community friends and stay tuned
42:21
your community friends and stay tuned
42:21
your community friends and stay tuned for the next episode thank you very much
42:23
for the next episode thank you very much
42:24
for the next episode thank you very much for joining us today
42:28
[Music]