Click here to Skip to main content

Comments by Arvind Jha (Top 11 by date)

Arvind Jha 1-Feb-16 12:29pm View

Thanks RDBurmon

Arvind Jha 31-Jan-16 13:14pm View

Hmm how to implement it?

Arvind Jha 31-Jan-16 11:42am View

Thanks Burmon, i had one updation on my question suppose if i also want to send a mail after that so is it possible if time is also there along with date.
Basically the case is the file is generated 5 times a day and needs to be sent as mail as attachment(excel file) with current timestamp.

Arvind Jha 30-Jan-16 21:05pm View

Actually the attachment needs to be sent as mail at the time of creation

Arvind Jha 29-Jan-16 6:29am View

Can it be not done in SSIS only through Expressions?

Arvind Jha 29-Jan-16 2:13am View

No Daniel.Anyways Thanks

Arvind Jha 28-Apr-14 7:29am View

<script language="javascript" type="text/javascript" src="/SiteAssets/jQueryLibrary/jquery-1.6.min.js"></script>
<script language="javascript" type="text/javascript" src="/SiteAssets/jQueryLibrary/jquery.SPServices-0.7.2.min.js"></script>
<script language="javascript" type="text/javascript">
var sText;

$(document).ready(function () {

$("select[title$='Store Name']").change(function () {

sText = $("select[title$='Store Name'] option:selected").text();

search();

});
});

function search(){
var context = new SP.ClientContext.get_current();
var web = context.get_web();
var list = web.get_lists().getByTitle('Store Details');
var query = '<view> <query><where><eq><fieldref name="\'Title\'/"><value type="\'Text\'">' + sText + '';
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(query);
this.collListItems = list.getItems(camlQuery);
context.load(this.collListItems);
context.executeQueryAsync(Function.createDelegate(this, this.onSuccess), Function.createDelegate(this, this.onFail));
}

function onSuccess(){
var listEnumerator=this.collListItems.getEnumerator();
while (listEnumerator.moveNext())
{
var item = listEnumerator.get_current();

$("input[title$='Region Name']").val(item.get_item('Region_x0020_Name'));
$("input[title$='District Name']").val(item.get_item('District_x0020_Name'));
$("input[title$='Region Name']").attr("disabled", "disabled");
$("input[title$='District Name']").attr("disabled", "disabled");
$("input[title$='District Manager']").val(item.get_item('District_x0020_Manager').get_lookupValue());
$("input[title$='Store Manager']").val(item.get_item('Store_x0020_Manager').get_lookupValue());
$("input[title$='Region Manager']").val(item.get_item('Region_x0020_Manager').get_lookupValue());
$("input[title$='Company Manager']").val(item.get_item('Company_x0020_Manager'));
$("input[title$='Store ManagerOld']").val(item.get_item('Store_x0020_Manager').get_lookupValue());
$("input[title$='District ManagerOld']").val(item.get_item('District_x0020_Manager').get_lookupValue());
$("input[title$='Company ManagerOld']").val(item.get_item('Company_x0020_Manager').get_lookupValue());
$("input[title$='Region Manager1']").val(item.get_item('Region_x0020_Manager').get_lookupValue()); }

}

function onFail(){
alert('');
}
</script>

Arvind Jha 18-May-13 11:08am View

I DONT WANT TO SEND AN ALERT ONLY A MESSAGE BOX

Arvind Jha 11-May-13 20:49pm View

How to use parameterized queries and why?

Arvind Jha 11-May-13 20:35pm View

Ho to check with debugger they are set to valid objects or not?

Arvind Jha 1-May-13 10:28am View

give a site where its explained properly