|
aws logus
FirefoxFileEoitViewHistoryBookmarksProfi aws logus
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindow Helpdws- Import bookmarks..Sprint BoardSRD QueueGithuh- Platform Sprint 1 Q2 - Platform Tea(z) Configure SSH access to multiple e© Console Home | Console Home | usSecurityGroup | EC2 | us-east-2© JY-20543 add AJ reports User piloSRD-6779 | JY-20632 | Unable toJy 19798 evaluation for ai activity8 Jiminny8 Ask Jiminny test report - 8 Apr 20Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilo% Configure SSH access to multiple «* New Tab- New labFirefoxSearch with Google or enter addressPlatform Sprint1 Q2 - Platfor...JY-20543 addAJ reports...MInbox (1,540) -lukas.kovalik...Meet - Daily -Jiminny203EC2 | us-east-2OWikipediaa Support Daily • in 4h 5 mA100% CS•Tue 14 Apr 10:55:5622°CNew York CityYouTube...
|
Alfred
|
Alfred
|
NULL
|
9863
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFileEditVi +SlackEDHomeDMsActivityFilesLater..•MoreFileEditViewGo+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelplihlSupport Daily - in 4h 5 m100% <47→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+TMOTOY TARNOY XOOLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:55:59New...
|
NULL
|
NULL
|
NULL
|
9864
|
|
Dia File Edit<ViewTabsBookmarksHistoryExtension Dia File Edit<ViewTabsBookmarksHistoryExtensionsWindowHelpSupport Daily • in 4h 4 m100% <478Tue 14 Apr 10:56:02...
|
NULL
|
NULL
|
NULL
|
9865
|
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Code changed:
Hide
Sync Changes
Hide This Notification
8
1
1
Previous Highlighted Error
Next Highlighted Error
<?php
namespace Jiminny\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Carbon;
use Jiminny\Traits\RequiresUUID;
/**
* Jiminny\Models\AutomatedReportResult
*
* @property int $id
* @property string $uuid
* @property int $report_id
* @property string|null $name
* @property int $status
* @property int $reason
* @property string $media_type
* @property int|null $parent_id
* @property array|null $payload
* @property array|null $response
* @property Carbon|null $requested_at
* @property Carbon|null $generated_at
* @property Carbon|null $sent_at
* @property Carbon|null $created_at
* @property Carbon|null $updated_at
* @property-read \Jiminny\Models\AutomatedReport $report
* @property-read AutomatedReportResult|null $parent
* @property-read \Illuminate\Database\Eloquent\Collection<int, AutomatedReportResult> $children
*/
class AutomatedReportResult extends Model
{
use RequiresUUID;
/**
* Status constants
*/
public const int STATUS_DEFAULT = 0;
public const int STATUS_REQUESTED = 1;
public const int STATUS_GENERATED = 2;
public const int STATUS_SENT = 3;
public const int STATUS_FAILED = 4;
/**
* Reason constants
*/
public const int REASON_DEFAULT = 0;
public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;
public const int REASON_PROPHET_API_ERROR = 2;
protected $table = 'automated_report_results';
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
*/
protected $fillable = [
'report_id',
'name',
'status',
'reason',
'media_type',
'parent_id',
'payload',
'response',
'requested_at',
'generated_at',
'sent_at',
];
/**
* Get the attributes that should be cast.
*
* @return array<string, string>
*/
protected function casts(): array
{
return [
'payload' => 'array',
'response' => 'array',
'requested_at' => 'datetime',
'generated_at' => 'datetime',
'sent_at' => 'datetime',
];
}
/**
* Get the automated report that owns this result.
*
* @return BelongsTo
*/
public function report(): BelongsTo
{
return $this->belongsTo(AutomatedReport::class, 'report_id')->withTrashed();
}
/**
* Get the parent report result.
*
* @return BelongsTo
*/
public function parent(): BelongsTo
{
return $this->belongsTo(self::class, 'parent_id');
}
/**
* Get the child report results.
*
* @return HasMany
*/
public function children(): HasMany
{
return $this->hasMany(self::class, 'parent_id');
}
/**
* Get the ID of the automated report result.
*
* @return int
*/
public function getId(): int
{
return $this->getAttribute('id');
}
/**
* Get the UUID of the automated report result.
*
* @return string
*/
public function getUuid(): string
{
return $this->getAttribute('id_string');
}
/**
* Get the report ID of the automated report result.
*
* @return int
*/
public function getReportId(): int
{
return $this->getAttribute('report_id');
}
/**
* Get the name of the automated report result.
*
* @return ?string
*/
public function getName(): ?string
{
return $this->getAttribute('name');
}
/**
* Get the status of the automated report result.
*
* @return int
*/
public function getStatus(): int
{
return $this->getAttribute('status');
}
/**
* Get the reason of the automated report result.
*
* @return int
*/
public function getReason(): int
{
return $this->getAttribute('reason');
}
/**
* Get the media type of the automated report result.
*
* @return string
*/
public function getMediaType(): ?string
{
return $this->getAttribute('media_type');
}
/**
* Get the parent ID of the automated report result.
*
* @return int|null
*/
public function getParentId(): ?int
{
return $this->getAttribute('parent_id');
}
/**
* Get the payload of the automated report result.
*
* @return array|null
*/
public function getPayload(): ?array
{
return $this->getAttribute('payload');
}
/**
* Get the response of the automated report result.
*
* @return array|null
*/
public function getResponse(): ?array
{
return $this->getAttribute('response');
}
/**
* Get the requested at date of the automated report result.
*
* @return Carbon|null
*/
public function getRequestedAt(): ?Carbon
{
return $this->getAttribute('requested_at');
}
/**
* Get the generated at date of the automated report result.
*
* @return Carbon|null
*/
public function getGeneratedAt(): ?Carbon
{
return $this->getAttribute('generated_at');
}
/**
* Get the sent at date of the automated report result.
*
* @return Carbon|null
*/
public function getSentAt(): ?Carbon
{
return $this->getAttribute('sent_at');
}
/**
* Get the created at date of the automated report result.
*
* @return Carbon
*/
public function getCreatedAt(): Carbon
{
return $this->getAttribute('created_at');
}
/**
* Get the updated at date of the automated report result.
*
* @return Carbon
*/
public function getUpdatedAt(): Carbon
{
return $this->getAttribute('updated_at');
}
/**
* Check if the report result is in requested status.
*
* @return bool
*/
public function isRequested(): bool
{
return $this->getStatus() === self::STATUS_REQUESTED;
}
/**
* Check if the report result is in generated status.
*
* @return bool
*/
public function isGenerated(): bool
{
return $this->getStatus() === self::STATUS_GENERATED;
}
/**
* Check if the report result is in sent status.
*
* @return bool
*/
public function isSent(): bool
{
return $this->getStatus() === self::STATUS_SENT;
}
/**
* Check if the report result is in failed status.
*
* @return bool
*/
public function isFailed(): bool
{
return $this->getStatus() === self::STATUS_FAILED;
}
public function getStatusLabel(): string
{
return match ($this->getStatus()) {
self::STATUS_REQUESTED => 'Requested',
self::STATUS_GENERATED => 'Generated',
self::STATUS_SENT => 'Sent',
self::STATUS_FAILED => 'Failed',
default => 'Default',
};
}
public function getReport(): AutomatedReport
{
return $this->getAttribute('report');
}
public function getFromDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['from_date'])) {
return null;
}
return Carbon::parse($payload['from_date']);
}
public function getToDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['to_date'])) {
return null;
}
return Carbon::parse($payload['to_date']);
}
public function getReportType(): ?string
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['report_type'])) {
return null;
}
return $payload['report_type'];
}
public function getGroups(): array
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['group_ids'])) {
return [];
}
return $payload['group_ids'];
}
public function getPdfUrl(): ?string
{
$response = $this->getResponse();
return $response['pdf_url'] ?? null;
}
public function getPodcastAudioUrl(): ?string
{
$response = $this->getResponse();
return $response['podcast_audio_url'] ?? null;
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…...
|
PhpStorm
|
faVsco.js – AutomatedReportResult.php
|
NULL
|
9866
|
|
DiaFile Edit View Tabs BookmarksHistory Extensions DiaFile Edit View Tabs BookmarksHistory Extensions Window<us-east-2.signin.aws.amazon.com / Amazon Web Services Sign-InHelp‹>0 ll 0Support Daily - in 4h 4m100% <47LTTue 14 Apr 10:56:05• ChatProvide feedbackMulti-session disabledEnglishawsIAM user sign in ©Account ID or alias (Don't have?)• Remember this accountIAM usernamePasswordYour path to Al productionAccelerate your Al implementationconfidently, with expert guidance from AWS• Show PasswordHaving trouble?Sign inSign in using root user emailCreate a new AWS account|Start your Al journey with AWS ›By continuing, you agree to AWS Customer Agreement orother agreement for AWS services, and the Privacy Notice.This site uses essential cookies. See our Cookie Notice formore information.© 2026 Amazon Web Services, Inc. or its affiliates. All rights reserved....
|
NULL
|
NULL
|
NULL
|
9867
|
|
PhpStormFileFV faVsco.js vProject vEditViewNavigat PhpStormFileFV faVsco.js vProject vEditViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny K vToolsWindowHelp• CommentContextinterfa© ConferencesOptinOutCi© Controller.php© ExportController.php© FrontendController.phprrontenocont olerau(C) GeocodinaController.ohc neatncneckcontroller.LiveCoachController.ph|© MissingTeamController.© MobileController.phpNotificationController.plNotificationProviderCon© PlaybackController.php© PlaylistController.php© PusherController.phpC) SlackController.pnp(C SupportController.pnpC) TeamSetupController.pl(C) UserAutomatedReports© WelcomeController.php> D MiddlewareRequests> D ResourcesD Responses• Iseralizers> D Transformers© Kernel.phpT, PlavlistTrackResourceTraitT) ValidateCrmConnectionRer› _ Integrations> D Interactions› D Jobs> D Listeners> C Mail|v C Models> D Activity• MAi> D AskAnything> M Calendar> M Connection› D Contracts› CrmD ElasticSearchOFeatureOpportunity© ParticipantPlaybackThemeD PlaylistD Scorecard• WebhookC Accountono©Activity.phpC Address.php© AiPrompt.php© AutomatedReport.php© AutomatedReportResult.ph© Calendar.php© Calllmport.php© ReportController.php© AutomatedReportsCommand.phpJiminnyDeouecommana.ongAutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpCreateActivityLoggedEvent.phpUserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php• RequestGeneratekeporJob.onoAutomatedReportResult.php= custom.log< console LUi-517518© AutomatedReport.php519* @property Carbon|null $updated_at520HOYIYTA* @property-read JiminnyWModels|AutomatedReport $report* @property-read AutomatedReportResult/null $parent* @property-read LIzzuminate\RatabaselELoquent\Collection<int, AutomatedReportResult> $ch.523522select * tron reans where 1o =133 Qgclass AutomatedReportResult extends Model523select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1)526select x troi arouos vnere 1o =909.use RequiresUUID;S2/select * from playbooks where team_id = 1;528select * from playbooks where id = 175;/**529select * from playbook_categories where playbook_id = 175;* Status constants530select * from users where team_id = 1;531select * from users where id = 7160;6 usages532select * from crm_profiles where user_id = 7160;pubLic const 1nt SIATUS_UEFAULI = 0;533select * from features;8 usages534selectpublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;• Extract Surround* Reason constants—536537538539540541542543# id, vvid, type, provider, playbook_category_id, user_id,lead_id, contact_id, account_id, opportunity.# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type ='conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMAC53 Ct6 usagespUDLic const 1nt REASUN_UEFAUll = 0;4 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 1;5 usagespublic const int REASON_PROPHET_API_ERROR = 2;protected $table = 'automated_report_results';/*** The attributes that are mass assignable.* @var array<int, string>protected $fillable = ["report_id',' name',Statusredson,'media_type','parent_id','payload','response','requested_at','generated_at',"sent_at",Windsurf changelog 2.12.21: A new version is available. // View Changelog (23 minutes ago)546547548549550551552553555556560-561562563564565E laravel.logA SF [jiminny@localhost]A HS_local [jiminny@localhost]A console [STAGING] X© AskJiminnyReportActivityService.phpAl console [PROD]© RequestGenerateAskJiminnyReportJobTest.phpfo?Tx: Auto vMlaycroundva jiminnyCONCAT (u.id, CASE WHEN U.id = t.owner_id THEN ' (owner) ' ELSE " END) AS USI016 A 13 X13 ^ vU. Clllall.sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1.n<->1: on t.id = u.team_idWheke Urtean s ano sarorov.lder z'salesforce';select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;1<->1.n: on cl.id = pl.layout_idsellect * From teams:SELECT r.* FROM automated_reports rjoin teams t on r.teamaid = t.idselect * from automated_reports;select * from automated_report_results where repontaig IN (34);Support Daily • in 4h 4mA100% [45)Tue 14 Apr 10:56:05RequestGenerateAskJiminnyReportJobTest vCascadeFixing ReportControlleAutomated Report FailTrigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES ):+D ..iRequestceneraterepori00.0ho:230-244$count = (int) $content['response'];if ($count < self::MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIESreturn false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Tiniaaer 2 -— Any Throwable excention (REASON PROPHET APT ERROR Or REASON DEFAULTJAM Requesatekenori.00.oho:29-191catch Ihrowable sexceptionsreason = sexception inscanceot ProphettxcepcionrAutomatedReportResult: :REASON_PROPHET_API_ERROR : AutomatedReportipules-ridetneporeisredsonrif ($this->attempts() < $this->tries) {Sthis->release (30): // retry after 30s} else ($this->fail($exception);ProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpointreturns no response key, DB errors, etc.)• The job retries once (2 tries total) before final failureASO: CheckAcryir VLount Tnrows AoiResponse xceotion T tne countar resconse ismaltormed - this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.pSame pattern but MIN_ACTIVITIES_COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search REASON_NOT_ENOUGH_ACTIVITIETrigger 2 - Any exception → REASON_PROPHET_API_ ERROR if ProphetException, else REASON DEFAULT . Retries once with 30s delaySummary of Failure CausesReasonvaluecauseREASON_NOT_ ENOUGH_ACTIVITILESDate range has < 10 activities (standard) or < 1 (AskJiminnyREASON_PROPHET_API_ERRProphet Al API threw an exceptionREASON_DEFAULTAnv other excention (D: error. malformed Ap)The reason tield on the AutomatedRenortResult recoro willl tell vou exacty which caseapplies.C1l -Ask anything (X4L)+ <> Code Claude Sonnet 4.6winasur leams44:535 charsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
9868
|
|
Dia<File Edit View Tabs BookmarksHistory Extens Dia<File Edit View Tabs BookmarksHistory Extensions WindowHelpus-east-2.signin.aws.amazon.com / Amazon Web Services Sign-In‹>0 ll 0a Support Daily - in 4h 4 m100% <47LTTue 14 Apr 10:56:07• ChatProvide feedbackMulti-session disabledEnglishawsIAM user sign in ©Account ID or alias (Don't have?)• Remember this accountIAM usernamePasswordYour path to Al productionAccelerate your Al implementationconfidently, with expert guidance from AWS• Show PasswordHaving trouble?Sign inSign in using root user emailCreate a new AWS account|Start your Al journey with AWS ›By continuing, you agree to AWS Customer Agreement orother agreement for AWS services, and the Privacy Notice.This site uses essential cookies. See our Cookie Notice formore information.© 2026 Amazon Web Services, Inc. or its affiliates. All rights reserved....
|
NULL
|
NULL
|
NULL
|
9869
|
|
us-east-2.signin.aws.amazon.com/oauth?client_id=ar us-east-2.signin.aws.amazon.com/oauth?client_id=arn%3Aaws%3Asignin%3A%3A%3Aconsole%2Fcloudwatch&code_challenge=Fdax6Rv9vU0rCRlxoWmmhXnxKIKJ3gNUH98LMj4v_jw&code_challenge_method=SHA-256&response_type=code&redirect_uri=https%3A%2F%2Fus-east-2.console.aws.amazon.com%2Fcloudwatch%2Fhome%3Fca-oauth-flow-id%3D847b%26hashArgs%3D%2523logsV2%253Alogs-insights%25243FqueryDetail%25243D%257E%2528end%257E0%257Estart%257E-3600%257EtimeType%257E%2527RELATIVE%257Etz%257E%2527UTC%257Eunit%257E%2527seconds%257EeditorString%257E%2527fields*20*40timestamp*2c*20*40message*2c*20*40logStream*2c*20*40log*0a*7c*20filter*20*40message*20like*20*2fXXXXX*2f*20*0a*7c*20filter*20*40message*20not*20like*20*2fAnalytic*2f*20*7c*20filter*20*40message*20not*20like*20*2fTranscript*2f*0a*7c*20filter*20*40message*20not*20like*20*2fWebhook*2f*20*7c*20filter*20*40message*20not*20like*20*2fMeetingBot*2f*20*0a*7c*20limit*2010000%257EqueryId%257E%25270551e814-f51a-4339-8372-80d7ba4cef27%257Esource%257E%2528%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-analytics%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-app%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-audio%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-calendar%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-conferences%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-crm-sync%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-default%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-delayed%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-dialers%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-dialers-fifo%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-download%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-emails%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-meeting-bot%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-nudges%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-1%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-2%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-3%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-4%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-5%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-delayed%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-softphone%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-video%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-video-app%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aphp%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aphp-app%2529%257Elang%257E%2527CWLI%257ElogClass%257E%2527STANDARD%257EqueryBy%257E%2527logGroupName%2529%26isauthcode%3Dtrue%26oauthStart%3D1776153363251%26region%3Dus-east-2%26state%3DhashArgsFromTB_us-east-2_bf524caeb24e5caf
us-east-2.signin.aws.amazon.com/oauth?client_id=arn%3Aaws%3Asignin%3A%3A%3Aconsole%2Fcloudwatch&code_challenge=Fdax6Rv9vU0rCRlxoWmmhXnxKIKJ3gNUH98LMj4v_jw&code_challenge_method=SHA-256&response_type=code&redirect_uri=https%3A%2F%2Fus-east-2.console.aws.amazon.com%2Fcloudwatch%2Fhome%3Fca-oauth-flow-id%3D847b%26hashArgs%3D%2523logsV2%253Alogs-insights%25243FqueryDetail%25243D%257E%2528end%257E0%257Estart%257E-3600%257EtimeType%257E%2527RELATIVE%257Etz%257E%2527UTC%257Eunit%257E%2527seconds%257EeditorString%257E%2527fields*20*40timestamp*2c*20*40message*2c*20*40logStream*2c*20*40log*0a*7c*20filter*20*40message*20like*20*2fXXXXX*2f*20*0a*7c*20filter*20*40message*20not*20like*20*2fAnalytic*2f*20*7c*20filter*20*40message*20not*20like*20*2fTranscript*2f*0a*7c*20filter*20*40message*20not*20like*20*2fWebhook*2f*20*7c*20filter*20*40message*20not*20like*20*2fMeetingBot*2f*20*0a*7c*20limit*2010000%257EqueryId%257E%25270551e814-f51a-4339-8372-80d7ba4cef27%257Esource%257E%2528%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-analytics%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-app%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-audio%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-calendar%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-conferences%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-crm-sync%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-default%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-delayed%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-dialers%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-dialers-fifo%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-download%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-emails%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-meeting-bot%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-nudges%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-1%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-2%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-3%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-4%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-5%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-delayed%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-softphone%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-video%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-video-app%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aphp%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aphp-app%2529%257Elang%257E%2527CWLI%257ElogClass%257E%2527STANDARD%257EqueryBy%257E%2527logGroupName%2529%26isauthcode%3Dtrue%26oauthStart%3D1776153363251%26region%3Dus-east-2%26state%3DhashArgsFromTB_us-east-2_bf524caeb24e5caf
More...
|
Dia
|
Personal: Amazon Web Ser…
|
NULL
|
9870
|
|
Provide feedback
Multi-session disabled
Multi-sess Provide feedback
Multi-session disabled
Multi-session disabled
Language English
Amazon Web Services logo
IAM user sign in
IAM user sign in
Account ID or alias
(Don't have?)
(Don't have?)
Account ID or alias (Don't have?)
Remember this account
Remember this account
IAM username
IAM username
Password
Password
Show Password
Show Password
Having trouble?
Having trouble?
Sign in
Sign in using root user email
Create a new AWS account
By continuing, you agree to
AWS Customer Agreement
AWS Customer Agreement
or other agreement for AWS services, and the
Privacy Notice
Privacy Notice
. This site uses essential cookies. See our
Cookie Notice
Cookie Notice
for more information.
Amazon Web Services Marketing
©
2026
Amazon Web Services, Inc. or its affiliates. All rights reserved.
us-east-2.signin.aws.amazon.com / Amazon Web Services Sign-In
us-east-2.signin.aws.amazon.com/oauth?client_id=arn%3Aaws%3Asignin%3A%3A%3Aconsole%2Fcloudwatch&code_challenge=Fdax6Rv9vU0rCRlxoWmmhXnxKIKJ3gNUH98LMj4v_jw&code_challenge_method=SHA-256&response_type=code&redirect_uri=https%3A%2F%2Fus-east-2.console.aws.amazon.com%2Fcloudwatch%2Fhome%3Fca-oauth-flow-id%3D847b%26hashArgs%3D%2523logsV2%253Alogs-insights%25243FqueryDetail%25243D%257E%2528end%257E0%257Estart%257E-3600%257EtimeType%257E%2527RELATIVE%257Etz%257E%2527UTC%257Eunit%257E%2527seconds%257EeditorString%257E%2527fields*20*40timestamp*2c*20*40message*2c*20*40logStream*2c*20*40log*0a*7c*20filter*20*40message*20like*20*2fXXXXX*2f*20*0a*7c*20filter*20*40message*20not*20like*20*2fAnalytic*2f*20*7c*20filter*20*40message*20not*20like*20*2fTranscript*2f*0a*7c*20filter*20*40message*20not*20like*20*2fWebhook*2f*20*7c*20filter*20*40message*20not*20like*20*2fMeetingBot*2f*20*0a*7c*20limit*2010000%257EqueryId%257E%25270551e814-f51a-4339-8372-80d7ba4cef27%257Esource%257E%2528%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-analytics%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-app%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-audio%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-calendar%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-conferences%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-crm-sync%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-default%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-delayed%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-dialers%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-dialers-fifo%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-download%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-emails%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-meeting-bot%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-nudges%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-1%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-2%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-3%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-4%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-5%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-processing-delayed%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-softphone%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-video%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aworker-video-app%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aphp%257E%2527arn*3aaws*3alogs*3aus-east-2*3a410346195943*3alog-group*3aphp-app%2529%257Elang%257E%2527CWLI%257ElogClass%257E%2527STANDARD%257EqueryBy%257E%2527logGroupName%2529%26isauthcode%3Dtrue%26oauthStart%3D1776153363251%26region%3Dus-east-2%26state%3DhashArgsFromTB_us-east-2_bf524caeb24e5caf
More...
|
Dia
|
Personal: Amazon Web Ser…
|
NULL
|
9871
|
|
DiA FileEdit ViewTabsBookmarksHistoryQ Ask anythin DiA FileEdit ViewTabsBookmarksHistoryQ Ask anything...+ Add tabs or filesExtensions WindowHelpCD0 llo) Support Daily • in 4h 4 m100% CTue 14 Apr 10:56:10• ChatEnglishawsIAM user sign in ©Account ID or alias (Don't have?)• Remember this accountIAM usernamePasswordYour path to Al productionAccelerate your Al implementationconfidently, with expert guidance from AWS• Show PasswordHaving trouble?Sign inSign in using root user emailCreate a new AWS account|Start your Al journey with AWS ›By continuing, you agree to AWS Customer Agreement orother agreement for AWS services, and the Privacy Notice.This site uses essential cookies. See our Cookie Notice formore information.© 2026 Amazon Web Services, Inc. or its affiliates. All rights reserved....
|
NULL
|
NULL
|
NULL
|
9872
|
|
PhpStormProject vNavigatelaraveRefactonWindowFVrav PhpStormProject vNavigatelaraveRefactonWindowFVravsco.isv#1894 on.lY-18909-automated-renorts-ask-liminnv k• CommentContextinterfa© ConferencesOptinOutCi© Controller.php© ExportController.php© FrontendController.phprrontenocont olerau(C) GeocodinaController.phc neatncneckcontroller.LiveCoachController.ph|© MissingTeamController.© MobileController.phpNotificationController.plNotificationProviderCon© PlaybackController.php© PlaylistController.php© PusherController.phpC) SlackController.pnp(C SupportController.pnpC) TeamSetupController.pl(C) UserAutomatedReports© WelcomeController.php• MiddlewareRequests> D ResourcesC Responses• Iseralizers> D Transformers© Kernel.phpT, PlavlistTrackResourceTraitT) ValidateCrmConnectionRer› _ Integrations> D Interactions> D Jobs> D Listeners> C Mail|v C Models> D Activity• MAi> D AskAnything> M Calendar> M Connection› D Contracts› CrmD ElasticSearchOFeatureOpportunity© ParticipantPlaybackThemeD PlaylistD Scorecard• WebhookC Accountono©Activity.phpC Address.php© AiPrompt.php© AutomatedReport.php© AutomatedReportResult.ph© Calendar.php© Calllmport.php© ReportController.php© AutomatedReportsCommand.phpJiminnyDeouecommana.ongAutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.phpTrackProviderInstalledEvent.phpCreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php• RequestGeneratekeporJob.onoAutomatedReportResult.php= custom.log< console LUi-517518© AutomatedReport.php519* @property Carbon|null $updated_at520HOYIYTA* @property-read JiminnyWModels|AutomatedReport $report* @property-read AutomatedReportResult/null $parent522* @property-read LIzluminatelRatabaselELoquent\Collection<int, AutomatedReportResult> $ch 523select * tron reans wnere 1o =133 Qgclass AutomatedReportResult extends Model523select * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1)526select x troi arouos were 1o = 909.use RequiresUUID;S2/select * from playbooks where team_id = 1;528select * from playbooks where id = 175;/**529select * from playbook_categories where playbook_id = 175;* Status constants530select * from users where team_id = 1;531select * from users where id = 7160;6 usages532select * from crm_profiles where user_id = 7160;pubLic const 1nt SIATUS_UEFAULI = 0;533select * from features;8 usages534selectpublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;• Extract Surround* Reason constants—536537538539540541542543# id, vvid, type, provider, playbook_category_id, user_id,lead_id, contact_id, account_id, opportunity.# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type ='conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMAC53 Ct6 usagespUDLic const 1nt REASUN_UEFAUll = 0;4 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 1;5 usagespublic const int REASON_PROPHET_API_ERROR = 2;protected $table = 'automated_report_results';/*** The attributes that are mass assignable.* @var array<int, string>protected $fillable = ["report_id',' name',Statusredson,'media_type','parent_id','payload','response','requested_at',' generated_at',"sent_at",546547548549550551552553555556560561562563564565E laravel.logA SF [jiminny@localhost]A HS_local [jiminny@localhost]A console [STAGING] X© AskJiminnyReportActivityService.phpAl console [PROD]© RequestGenerateAskJiminnyReportJobTest.phpfo?Tx: Auto vMlaycroundvSa jiminny vCONCAT (u.id, CASE WHEN U.id = t.owner_id THEN ' (owner) ' ELSE " END) AS USI016 A 13 X13 ^ vU. Clllall.sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1.n<->1: on t.id = u.team_idWheke Urtean s ano sarorov.lder z'salesforce';select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;1<->1.n: on cl.id = pl.layout_idsellect * From teams:SELECT r.* FROM automated_reports rjoin teams t on r.teamaid = t.idselect * from automated_reports;select * from automated_report_results where repontaig IN (34);Support Daily • in 4h 4 m100% C2Tue 14 Apr 10:56:10RequestGenerateAskJiminnyReportJobTest vCascadeFixing ReportControlleAutomated Report FailTrigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES ):+D..i Requestcenleratekepori.00.0h0:230-244$count = (int) $content['response'];1t scount < seltii AaINIESCOINT$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIESreturn false:MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Tiniaaer 2 -— Any Throwable excention (REASON PROPHET APT ERROR Or REASON DEFAULTJAM Reques:terepor.00,oho:20-191|catchIhrowable sexceptionsreason = sexception inscanceot ProphettxcepcionrAutomatedReportResult: :REASON_PROPHET_API_ERROR : AutomatedReportipules-ridetneporeisredsonrif ($this->attempts() < $this->tries) {Sthis->release (30): // retry after 30s} else (sthis-stal sexcentionProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpointreturns no response key, DB errors, etc.)• The job retries once (2 tries total) before final failureASO: CheckAcryir VLount Tnrows AoiResponse xceotion T tne countar resconse ismaltormed - this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.pSame pattern but MIN_ACTIVITIES_COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search REASON_NOT_ENOUGH_ACTIVITIETrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASON DEFAULT . Retries once with 30s delaySummary of Failure CausesReasonvaluecauseREASON_NOT_ ENOUGH_ACTIVITILESDate range has < 10 activities (standard) or < 1 (AskJiminnyREASON_PROPHET_API_ERRProphet Al API threw an exceptionREASON_DEFAULTAnv other excention (D? error. maltormed ApThe reason tield on the AutomatedRenortResult recoro willl tell vou exacty which caseapplies.C1l -Ask anything (X4L)+ <> Code Claude Sonnet 4.6Winasun leamsf 4 space:...
|
NULL
|
NULL
|
NULL
|
9873
|
|
Dia File EditViewTabsAbout DiaCheck for Updates... Dia File EditViewTabsAbout DiaCheck for Updates...Invite to Dia...0 Settings...d Import from Another Browser...O ServicesHide DiaHide OthersShow Alli Sign Out(* Quit DiaBookmarksHistoryExtensions WindowHelp) Support Daily • in 4h 4 m100% <8• Tue 14 Apr 10:56:11• ChatEnglish v28,aws2 HT8 Hr sign in ©88 QAccount ID or alias (Don't have?)• Remember this accountIAM usernamePasswordYour path to Al productionAccelerate your Al implementationconfidently, with expert guidance from AWS• Show PasswordHaving trouble?Sign inSign in using root user emailCreate a new AWS account|Start your Al journey with AWS ›By continuing, you agree to AWS Customer Agreement orother agreement for AWS services, and the Privacy Notice.This site uses essential cookies. See our Cookie Notice formore information.© 2026 Amazon Web Services, Inc. or its affiliates. All rights reserved....
|
NULL
|
NULL
|
NULL
|
9874
|
|
PhpStormProject vNavigatelaraveRefactonWindowFVrav PhpStormProject vNavigatelaraveRefactonWindowFVravsco.isv#1894 on.lY-18909-automated-renorts-ask-liminnv k• CommentContextinterfa© ConferencesOptinOutCi© Controller.php© ExportController.php© FrontendController.phprrontenocont olerau(C) GeocodinaController.phc neatncneckcontroller.LiveCoachController.ph|© MissingTeamController.© MobileController.phpNotificationController.plNotificationProviderCon© PlaybackController.php© PlaylistController.php© PusherController.phpC) SlackController.pnp(C SupportController.pnpC) TeamSetupController.pl(C) UserAutomatedReports© WelcomeController.php• MiddlewareRequests> D ResourcesC Responses• Iseralizers> D Transformers© Kernel.phpT, PlavlistTrackResourceTraitT) ValidateCrmConnectionRer› _ Integrations> D Interactions> D Jobs> D Listeners> C Mail|v C Models> D Activity• MAi> D AskAnything> M Calendar> M Connection› D Contracts› CrmD ElasticSearchOFeatureOpportunity© ParticipantPlaybackThemeD PlaylistD Scorecard• WebhookC Accountono©Activity.phpC Address.php© AiPrompt.php© AutomatedReport.php© AutomatedReportResult.ph© Calendar.php© Calllmport.php© ReportController.php© AutomatedReportsCommand.phpJiminnyDeouecommana.ongAutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAutomatedReportsService.phpCreateHeldActivityEvent.phpTrackProviderInstalledEvent.phpCreateActivityLoggedEvent.php© ActivityLogged.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php• RequestGeneratekeporJob.onoAutomatedReportResult.php= custom.log< console LUi-517518© AutomatedReport.php519* @property Carbon|null $updated_at520HOYIYTA* @property-read JiminnyWModels|AutomatedReport $report* @property-read AutomatedReportResult/null $parent522* @property-read LIzluminatelRatabaselELoquent\Collection<int, AutomatedReportResult> $ch 523523select * tron reans wnere 1o =133 Qgclass AutomatedReportResult extends Modelselect * from groups g JOIN playbooks p 1..n<->1: on g.playbook_id = p.id where g.team_id = 1)select x troi arouos were 1o = 909.use RequiresUUID;S2/select * from playbooks where team_id = 1;528select * from playbooks where id = 175;/**529select * from playbook_categories where playbook_id = 175;* Status constants530select * from users where team_id = 1;531select * from users where id = 7160;6 usages532select * from crm_profiles where user_id = 7160;pubLic const 1nt SIATUS_UEFAULI = 0;533select * from features;8 usages534selectpublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;• Extract Surround* Reason constants—536537538539540541542543# id, vvid, type, provider, playbook_category_id, user_id,lead_id, contact_id, account_id, opportunity.# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type ='conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMAC53 Ct6 usagespUDLic const 1nt REASUN_UEFAUll = 0;4 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 1;5 usagespublic const int REASON_PROPHET_API_ERROR = 2;protected $table = 'automated_report_results';/*** The attributes that are mass assignable.* @var array<int, string>protected $fillable = ["report_id',' name',Statusredson,'media_type','parent_id','payload','response','requested_at',' generated_at',"sent_at",546547548549550551552553555556560561562563564565E laravel.logA SF [jiminny@localhost]A HS_local [jiminny@localhost]A console [STAGING] X© AskJiminnyReportActivityService.phpAl console [PROD]© RequestGenerateAskJiminnyReportJobTest.phpfo?Tx: Auto vMlaycroundvSa jiminny vCONCAT (u.id, CASE WHEN U.id = t.owner_id THEN ' (owner) ' ELSE " END) AS USI016 A 13 X13 ^ vU. Clllall.sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1.n<->1: on t.id = u.team_idWheke Urtean s ano sarorov.lder z'salesforce';select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;1<->1.n: on cl.id = pl.layout_idsellect * From teams:SELECT r.* FROM automated_reports rjoin teams t on r.teamaid = t.idselect * from automated_reports;select * from automated_report_results where repontaig IN (34);Support Daily • in 4h 4 m100% C2•8• Tue 14 Apr 10:56:13RequestGenerateAskJiminnyReportJobTest vCascadeFixing ReportControlleAutomated Report FailTrigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES ):+0 .i Requestcenleratekepori.00.0h0:230-244$count = (int) $content['response'];1t scount < seltii AaINIESCOINT$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIESreturn false:MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Tiniaaer 2 -— Any Throwable excention (REASON PROPHET APT ERROR Or REASON DEFAULTJAM Reques:terepor.00,oho:20-191|catchIhrowable sexceptionsreason = sexception inscanceot ProphettxcepcionrAutomatedReportResult: :REASON_PROPHET_API_ERROR : AutomatedReportipules-ridetneporeisredsonrif ($this->attempts() < $this->tries) {Sthis->release (30): // retry after 30s} else (sthis-stal sexcentionProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpointreturns no response key, DB errors, etc.)• The job retries once (2 tries total) before final failureASO: CheckAcryir VLount Tnrows AoiResponse xceotion T tne countar resconse ismaltormed - this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.pSame pattern but MIN_ACTIVITIES_COUNT is 1:Trigger 1 - Fewer than 1 activity from the saved search REASON_NOT_ENOUGH_ACTIVITIETrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASON DEFAULT . Retries once with 30s delaySummary of Failure CausesReasonvaluecauseREASON_NOT_ ENOUGH_ACTIVITILESDate range has < 10 activities (standard) or < 1 (AskJiminnyREASON_PROPHET_API_ERRProphet Al API threw an exceptionREASON_DEFAULTAnv other excention (D? error. maltormed ApThe reason tield on the AutomatedRenortResult recoro willl tell vou exacty which caseapplies.C1l -Ask anything (X4L)+ <> Code Claude Sonnet 4.6Winasun leamsf 4 space:...
|
NULL
|
NULL
|
NULL
|
9875
|
|
Dia<FileEdit ViewQ Ask anything...TabsBookmarks Dia<FileEdit ViewQ Ask anything...TabsBookmarksHistoryExtensions WindowHelpCD0 llo) Support Daily - in 4h 4 m100% <8• Tue 14 Apr 10:56:14• Chat+ Add tabs or filesEnglishawsIAM user sign in ©Account ID or alias (Don't have?)• Remember this accountIAM usernamePasswordYour path to Al productionAccelerate your Al implementationconfidently, with expert guidance from AWS• Show PasswordHaving trouble?Sign inSign in using root user emailCreate a new AWS account|Start your Al journey with AWS ›By continuing, you agree to AWS Customer Agreement orother agreement for AWS services, and the Privacy Notice.This site uses essential cookies. See our Cookie Notice formore information.© 2026 Amazon Web Services, Inc. or its affiliates. All rights reserved....
|
Dia
|
Personal: Amazon Web Ser…
|
NULL
|
9876
|
|
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
Directories
platform-inner-team
ai-chapter
alerts
backend
confusion-clinic
curiosity_lab
engineering
frontend
general
infra-changes
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Steliyan Georgiev
Adelina Petrova
,
Ilian Kyuchukov
,
Steliyan Georgiev
Adelina Petrova
Galya Dimitrova
Vasil Vasilev
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Yankov
Nikolay Yankov
Jira Cloud
Toast
Google Calendar
Messages
Messages
Add canvas
Add canvas
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Steliyan Georgiev
Apr 8th at 4:12:14 PM
4:12 PM
Все още кодът не e в master, защото ПРът не е одобрен, но ето така изглежда един примирен рекуест за Panorama report:
curl -X 'POST' \
'
http://localhost:9080/ask-anything-on-demand/request-report
http://localhost:9080/ask-anything-on-demand/request-report
' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '{
"userQuestion": "What are the most common topics in these calls?",
"history": [
],
"attemptNumber": 1,
"callIds": [
"77332439",
"74714697",
"34525304",
"2574920"
],
"teamId": 1,
"request_id": "test_req_q_2",
"callback_url": "
https://localhost:8080
https://localhost:8080
",
"reportPeriod": "Apr 1 - Apr 8"
}'
Lukas Kovalik
Apr 8th at 4:12:58 PM
4:12 PM
ще го наглася
(edited)
1 reaction, react with +1 emoji
1
Add reaction…
Jump to date
Nikolay Yankov
Today at 10:19:59 AM
10:19 AM
като създам дефиниция daily, веднага ли трябва да създаде репорт?
Nikolay Yankov
Today at 10:32:27 AM
10:32 AM
10 мин минаха, още не идва репорт
Lukas Kovalik
Today at 10:34:10 AM
10:34 AM
не само daily но трябва да се пусне команда
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:35:08 AM
10:35
php artisan automated-reports
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:35:39 AM
10:35 AM
значи не създава веднага по принцип, в някакъв час на деня ли стъздава?
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:36:11 AM
10:36 AM
това ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:36:27 AM
10:36
крон го пуска през нощ
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:37:19 AM
10:37
така че мануално пусни при тестване
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:38:26 AM
10:38
ако трябва да тестваме други репорти може да променя команда за тестване да приема параметър за report template и д си пускаме определен когато тестваме
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:41:03 AM
10:41 AM
можеш ли да я ръннеш ти командата
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:43:05 AM
10:43 AM
да
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
New
Nikolay Yankov
Today at 10:45:52 AM
10:45 AM
пиши кат оя ръннеш
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:52:52 AM
10:52 AM
забавих се че ми се разбазикаха settings за среди
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:53:07 AM
10:53
пуснах и мина и fail-на
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:53:20 AM
10:53
има result но е failed
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
+SlackFileEDHomeDMsActivityFilesLater..•More+EditViewGoHistoryWindowHelp‹ >0 ll§ Support Daily • in 4h 4 m100% C→Search Jiminny IncJiminny ...Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev84= Unreads• MessagesThreadsAdd canvas+TMOTOy TARNOY XOOLAI10 мин минаха, още не идва репортToday ~HuddlesDrafts & sentLukas Kovalik 10:34 AMне само daily но трябва да се пусне командаDirectoriesphp artisan automated-reportsExternal connectionsLaterNikolay Yankov 10:35 AMalik 10:36 AMъздава веднага по принцип, в някакьв час на деня ли стъздава?еда всичко applicable за днес (ако не понедлник или начало на месец е само daily)ска през нощнуално пусни при тестванеі да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеі когато тествамеnkov 10:41 AMда я рьннеш ти командатаalik 10:43 AMYou made a lot of progressYou checked everything off your list.Create Remindernkov 10:45 AMя рьннешalik 10:52 AMче ми се разбазикаха settings за средиина и fail-нано e faileda Angelova, Nikolay Yankov, Steliyan GeorgievTue 14 Apr 10:56:17New...
|
Slack
|
Aneliya Angelova, Nikolay Yankov, Steliyan Georgie Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev (DM) - Jiminny Inc - 1 new item - Slack...
|
NULL
|
9877
|
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
New Tab
Close tab
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
22°
C
New York City
Open menu
Mozilla Firefox
Search with Google or enter address
Search with Google or enter address
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Open context menu for Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Open context menu for JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Inbox (1,540) - [EMAIL] - Jiminny Mail
Inbox (1,540) - [EMAIL] - Jiminny Mail
Open context menu for Inbox (1,540) - [EMAIL] - Jiminny Mail
Meet - Daily - Platform
Meet - Daily - Platform
Open context menu for Meet - Daily - Platform
Jiminny
Jiminny
Open context menu for Jiminny
EC2 | us-east-2
EC2 | us-east-2
Open context menu for EC2 | us-east-2
Wikipedia
Wikipedia
Open context menu for Wikipedia
YouTube
YouTube
Open context menu for YouTube
Customize
Customize...
|
Firefox
|
Work — Mozilla Firefox
|
NULL
|
9878
|
|
JY-20543 add AJ reports User pilot tracking by Lak JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
Console Home | Console Home | us-east-2
Console Home | Console Home | us-east-2
SecurityGroup | EC2 | us-east-2
SecurityGroup | EC2 | us-east-2
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
SRD-6779 | JY-20632 | Unable to log in to Sidekick with SSO by yalokin-jiminny · Pull Request #11935 · jiminny/app
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jy 19798 evaluation for ai activity types by nikolaybiaivanov · Pull Request #468 · jiminny/prophet
Jiminny
Jiminny
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Ask Jiminny test report - 8 Apr 2026 - Ask Jiminny test report - 13 Apr 2026.pdf
Service-Desk - Queues - Platform team - Service space - Jira
Service-Desk - Queues - Platform team - Service space - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Configure SSH access to multiple environment - Engineering - Confluence
Configure SSH access to multiple environment - Engineering - Confluence
New Tab
New Tab
Close tab
New Tab
Customize sidebar
Open Google Gemini (⌃X)
Tabs from other devices
Open history (⇧⌘H)
Open bookmarks (⌘B)
22°
C
New York City
Open menu
Mozilla Firefox
Search with Google or enter address
Search with Google or enter address
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
Open context menu for Platform Sprint 1 Q2 - Platform Team - Scrum Board - Jira
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Open context menu for JY-20543 add AJ reports User pilot tracking by LakyLak · Pull Request #11932 · jiminny/app
Inbox (1,540) - [EMAIL] - Jiminny Mail
Inbox (1,540) - [EMAIL] - Jiminny Mail
Open context menu for Inbox (1,540) - [EMAIL] - Jiminny Mail
Meet - Daily - Platform
Meet - Daily - Platform
Open context menu for Meet - Daily - Platform
Jiminny
Jiminny
Open context menu for Jiminny
EC2 | us-east-2
EC2 | us-east-2
Open context menu for EC2 | us-east-2
Wikipedia
Wikipedia
Open context menu for Wikipedia
YouTube
YouTube
Open context menu for YouTube
Customize
Customize...
|
Firefox
|
Work — Mozilla Firefox
|
NULL
|
9879
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFile+EditV +SlackEDHomeDMsActivityFilesLater..•MoreFile+EditViewGoHistoryWindowHelplihlSupport Daily - in 4h 4 m100% <47→Search Jiminny IncJiminny ...Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev84= UnreadsThreads• MessagesAdd canvas+TMOTOy TARNOY XOOLAI10 мин минаха, още не идва репортToday ~HuddlesDrafts & sentLukas Kovalik 10:34 AMне само daily но трябва да се пусне командаDirectoriesphp artisan automated-reportsExternal connectionsLaterNikolay Yankov 10:35 AMalik 10:36 AMъздава веднага по принцип, в някакьв час на деня ли стъздава?еда всичко applicable за днес (ако не понедлник или начало на месец е само daily)ска през нощнуално пусни при тестванеі да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеі когато тествамеnkov 10:41 AMда я рьннеш ти командатаalik 10:43 AMYou made a lot of progressYou checked everything off your list.Create Remindernkov 10:45 AMя рьннешalik 10:52 AMче ми се разбазикаха settings за средиина и fail-наHo e faileda Angelova, Nikolay Yankov, Steliyan GeorgievTue 14 Apr 10:56:21New...
|
NULL
|
NULL
|
NULL
|
9880
|
|
FirefoxFileEoitViewHistoryBookmarksProfilesToolsWi FirefoxFileEoitViewHistoryBookmarksProfilesToolsWindowHelpImport bookmarks...Sprint BoardT SRD QueuePlatform Sprint 1 Q2 - Platform Tea(z) Configure SSH access to multiple e• Console Home | Console Home | u:SecurityGroup | EC2 | us-east-2© JY-20543 add AJ reports User piloSRD-6779 | JY-20632 | Unable toJy 19798 evaluation for ai activityJiminny8 Ask Jiminny test report - 8 Apr 20Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilc* Configure SSH access to multiple «* New Tab- New laoaws - Search with GoogleAmazon Wea Servicesaws consoleaws certificationaws loginaws skill builderaws sFirefox Suggest.EC2 | us-east-2 - us-east-2.console.aws.amazon.com/ec2/home?region=us-east-2#SecurityGroup:securityGroupld=sg-48ec3e21EC2 Management Console - us-east-2.console.aws.amazon.com/ec2/v2/home?region=us-east-2#SecuritvGroup:securitvGroupld=sa-48ec3e21SecurityGroup | EC2 | us-east-2Switch to TabFirefoxSearch with Google or enter addressPlatform SprintJY-20543 addAJ reports...MInbox (1,540) -lukas.kovalik...Meet - Daily -Jiminny203EC2 | us-east-2OWikipedialibd: Support Daily • in 4h 4 mA100% CS•Tue 14 Apr 10:56:2122°CNew York CityYouTube...
|
NULL
|
NULL
|
NULL
|
9881
|
|
FirefoxFileEoitViewHistory Bookmarks ProfilesTools FirefoxFileEoitViewHistory Bookmarks ProfilesTools Window HelpC< 40 ll O SupportDaily•in 4h4m A 100% C Tue 14 Apr 10:56:25•••)+us-east-2.console.aws.amazon.com/cloudwatch/home?ca-oauth-flow-id=847b&hashArgs=%23logsV2%3Alogs-insights%243FqueryDetail%243D~(end~0~start~-3600~timeType~'RELATIVE~tz~'UTC~unit~'seconds~editorString~'fields*20*40timestamp*2c*20*40message*2c*20*40logs $Platform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple eConsole Home | Console Home | use SecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User piloSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activitya Jiminny8) Ask Jiminny test report - 8 Apr 20:# Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilc(x) Configure SSH access to multipleUnauthorized+ New Tab...
|
NULL
|
NULL
|
NULL
|
9884
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFile+EditV +SlackEDHomeDMsActivityFilesLater..•MoreFile+EditViewGoHistoryWindowHelplihlSupport Daily - in 4h 4 m100% <47→Search Jiminny IncJiminny ...Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev84= UnreadsThreads• MessagesAdd canvas+NMOTOy TORNOY XOOLAI10 мин минаха, още не идва репортToday ~HuddlesDrafts & sentLukas Kovalik 10:34 AMне само daily но трябва да се пусне командаDirectoriesphp artisan automated-reportsExternal connectionsLaterNikolay Yankov 10:35 AMalik 10:36 AMъздава веднага по принцип, в някакьв час на деня ли стъздава?еда всичко applicable за днес (ако не понедлник или начало на месец е само daily)ска през нощнуално пусни при тестванеі да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеі когато тествамеnkov 10:41 AMда я рьннеш ти командатаalik 10:43 AMYou made a lot of progressYou checked everything off your list.Create Remindernkov 10:45 AMя рьннешalik 10:52 AMче ми се разбазикаха settings за средиина и fail-наHo e faileda Angelova, Nikolay Yankov, Steliyan GeorgievTue 14 Apr 10:56:32New...
|
NULL
|
NULL
|
NULL
|
9887
|
|
FirefoxFileEoitViewHistoryBookmarksProfllesToolsWi FirefoxFileEoitViewHistoryBookmarksProfllesToolsWindowHelpus-east-1.console.aws.amazon.com/console/home?region=us-east-1#awssparch[Option+S]©Platform Sprint 1 Q2 - Platform TeaO EC2@ Elastic Container ServiceG 53* CodeDeployElastiCache F0? Aurora and RDS liäl Amazon OpenSearch Ser...& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User pilSRD-6779 |JY-20632 | Unable to |( Jy 19798 evaluation for ai activity(8) Jiminnyg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc~ Contigure SsH access to multipleo Console Home | Console Home *+ New TabCa CloudWatch• CloudFront MediaLiveConsole Home Info:: Recently visited InfoEC2iö Amazon OpenSearch ServiceCloudWatchAmazon ConnectSimple Queue ServicenillesisAurora and RDSAmazon Data FirehoseAmazon bearock(&D API GatewayCQ IAM Identity CenterView all services# Welcome to AWS#AWS Health infoGetting started with AWS 2hamaheon ge the mos tut raluableTraining and certificationLearn from AWS experts and advance yourskills and knowledge.AWS Builder Center 2Learn, build, and connect with builders inthe AWS community.No health dataYou don't have permissions to access AWS Health.Go to AWS HealthApp Developer (4)Setlet sious n3 30 m AVvs ror popuar bushnes and echniea use cases.Cloud Architect (4) Platform Engineer (4) Al Ops (4)Auomare lanes soale sever migaion NVS Cioud usng templates 12?Automates VMware workload testing and migration setup to AWS Cloud L?CloudShellreedback< 40 l6lReset to default layout: Applications (0) InfoRegion: US East (N. Virginia)Select Region -us-east-1 (Current Region)Q Find applicationsName• Description • Region • | Originati...No applicationsGet started by creating an application.Create applicationj Support Daily • in 4h 4mA100% C© Tue 14 Apr 10:56:32=United gfates (N. Virginia) *Account ID: 4387-4037-0364STAGE]+ Add widgetsCreate application)‹ 1 >- 1Cost and usage infoCrer mont!ecased month endSavings opportunitiesO Not enabledGo to myApplicationsCost breakdown® Access deniedExplore AWS infoAmazon S3 Files 12Access your 53 buckets as sharedfile systemsTry AWS DevOps Agent 2Your autonomous agent forincident resolution and reliability.Go to Billing and Cost ManagementThe AWS Sustainability cons...Transparent carbon data forinformed cloud choicesDatabase Savings Plans 2ªFlexible pricing model that reducesyour database costs by up to 35%.© 2026, Amazon Web Services, Inc. or its affiliates.Privacy Terms Cookie preferences...
|
NULL
|
NULL
|
NULL
|
9888
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFile+EditV +SlackEDHomeDMsActivityFilesLater..•MoreFile+EditViewGoHistoryWindowHelplihlSupport Daily - in 4h 4 m100% <47→Search Jiminny IncJiminny ...Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev84= UnreadsThreads• MessagesAdd canvas+NMOTOy TORNOY XOOLAI10 мин минаха, още не идва репортToday ~HuddlesDrafts & sentLukas Kovalik 10:34 AMне само daily но трябва да се пусне командаDirectoriesphp artisan automated-reportsExternal connectionsLaterNikolay Yankov 10:35 AMalik 10:36 AMъздава веднага по принцип, в някакьв час на деня ли стъздава?еда всичко applicable за днес (ако не понедлник или начало на месец е само daily)ска през нощнуално пусни при тестванеі да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеі когато тествамеnkov 10:41 AMда я рьннеш ти командатаalik 10:43 AMYou made a lot of progressYou checked everything off your list.Create Remindernkov 10:45 AMя рьннешalik 10:52 AMче ми се разбазикаха settings за средиина и fail-наHo e faileda Angelova, Nikolay Yankov, Steliyan GeorgievTue 14 Apr 10:56:33New...
|
NULL
|
NULL
|
NULL
|
9889
|
|
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
Directories
platform-inner-team
ai-chapter
alerts
backend
confusion-clinic
curiosity_lab
engineering
frontend
general
infra-changes
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Steliyan Georgiev
Adelina Petrova
,
Ilian Kyuchukov
,
Steliyan Georgiev
Adelina Petrova
Galya Dimitrova
Vasil Vasilev
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Yankov
Nikolay Yankov
Jira Cloud
Toast
Google Calendar
Messages
Messages
Add canvas
Add canvas
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Steliyan Georgiev
Apr 8th at 4:12:14 PM
4:12 PM
Все още кодът не e в master, защото ПРът не е одобрен, но ето така изглежда един примирен рекуест за Panorama report:
curl -X 'POST' \
'
http://localhost:9080/ask-anything-on-demand/request-report
http://localhost:9080/ask-anything-on-demand/request-report
' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '{
"userQuestion": "What are the most common topics in these calls?",
"history": [
],
"attemptNumber": 1,
"callIds": [
+SlackEDHomeDMsActivityFilesLater..•MoreFile+EditViewGoHistoryWindowHelplihlSupport Daily - in 4h 4 m100% C4→Search Jiminny IncJiminny ...Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev84= UnreadsThreads• MessagesAdd canvas+NMOTOy TORNOY XOOLAI10 мин минаха, още не идва репортToday ~HuddlesDrafts & sentLukas Kovalik 10:34 AMне само daily но трябва да се пусне командаDirectoriesphp artisan automated-reportsExternal connectionsLaterNikolay Yankov 10:35 AMalik 10:36 AMъздава веднага по принцип, в някакьв час на деня ли стъздава?еда всичко applicable за днес (ако не понедлник или начало на месец е само daily)ска през нощнуално пусни при тестванеі да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеі когато тествамеnkov 10:41 AMда я рьннеш ти командатаalik 10:43 AMYou made a lot of progressYou checked everything off your list.Create Remindernkov 10:45 AMя рьннешalik 10:52 AMче ми се разбазикаха settings за средиина и fail-наHo e faileda Angelova, Nikolay Yankov, Steliyan GeorgievTue 14 Apr 10:56:43New...
|
Slack
|
Aneliya Angelova, Nikolay Yankov, Steliyan Georgie Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev (DM) - Jiminny Inc - 1 new item - Slack...
|
NULL
|
9894
|
|
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
Directories
platform-inner-team
ai-chapter
alerts
backend
confusion-clinic
curiosity_lab
engineering
frontend
general
infra-changes
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Steliyan Georgiev
Adelina Petrova
,
Ilian Kyuchukov
,
Steliyan Georgiev
Adelina Petrova
Galya Dimitrova
Vasil Vasilev
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Yankov
Nikolay Yankov
Jira Cloud
Toast
Google Calendar
Messages
Messages
Add canvas
Add canvas
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Steliyan Georgiev
Apr 8th at 4:12:14 PM
4:12 PM
Все още кодът не e в master, защото ПРът не е одобрен, но ето така изглежда един примирен рекуест за Panorama report:
curl -X 'POST' \
'
http://localhost:9080/ask-anything-on-demand/request-report
http://localhost:9080/ask-anything-on-demand/request-report
' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '{
"userQuestion": "What are the most common topics in these calls?",
"history": [
],
"attemptNumber": 1,
"callIds": [
"77332439",
"74714697",
"34525304",
"2574920"
],
"teamId": 1,
"request_id": "test_req_q_2",
"callback_url": "
https://localhost:8080
https://localhost:8080
",
"reportPeriod": "Apr 1 - Apr 8"
}'
Lukas Kovalik
Apr 8th at 4:12:58 PM
4:12 PM
ще го наглася
(edited)
1 reaction, react with +1 emoji
1
Add reaction…
Jump to date
Nikolay Yankov
Today at 10:19:59 AM
10:19 AM
като създам дефиниция daily, веднага ли трябва да създаде репорт?
Nikolay Yankov
Today at 10:32:27 AM
10:32 AM
10 мин минаха, още не идва репорт
FirefoxFileEoitViewHistoryawsO EC2BookmarksProfilesToolsWindow Helpus-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2#Q SearchC Elastic Container Servicef s3 CodeDeployGa CloudWatch,40 lil#Support Daily - in 4h 4m (A 100% C4• 8 Tue 14 Apr 10:56:43[Option+5]]ElastiCache (o:) Aurora and RDS i&l Amazon OpenSearch Ser…..United States (Ohio)Account ID: 4387-4037-0364STAGE)• CloudFront MediaLivePlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User pilc5 SRD-6779 | JY-20632 | Unable to( Jy 19798 evaluation for ai activitya Jiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilo~ Contigure SsH access to multipleCloudWatch | us-east-2+ New Tabreedback© 2026, Amazon Web Services, Inc. or its affiliates.PrivacyTermsCookie preferences...
|
Slack
|
Aneliya Angelova, Nikolay Yankov, Steliyan Georgie Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev (DM) - Jiminny Inc - 1 new item - Slack...
|
NULL
|
9895
|
|
FirefoxFileEditViewHistoryBookmarks)ProfilesToolsW FirefoxFileEditViewHistoryBookmarks)ProfilesToolsWindowHelpus-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2#* Suooort Dailv . in 4h 4ml(A) 100% C 8 Tue 14 Apr 10:56:44awsO EC2Q SearchElastic Container Service s3# CodeDeployGa CloudWatch[Option+5] ]ElastiCache (o:) Aurora and RDS i&l Amazon OpenSearch Ser…..United States Ohio)Account ID: 4387-4037-0364(STAGE• CloudFront MediaLivePlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple eConsole Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activitya Jiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformJY-20543 add AJ reports User pilc~ Contigure SsH access to multipleCa CloudWatch | us-east-2+ New TabCloudShellreedback© 2026, Amazon Web Services, Inc. or its affiliates.PrivacyTermsCookie preferences...
|
NULL
|
NULL
|
NULL
|
9896
|
|
+SlackFileEDHomeDMsEditViewGoActivityFiles..•More+ +SlackFileEDHomeDMsEditViewGoActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelp< →0 lhl§ Support Daily • in 4h 4 m100% C→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+NMOTOY TARNOY X0OLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командата#Lukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:56:45New...
|
NULL
|
NULL
|
NULL
|
9897
|
|
FirefoxPlatform Sprint 1 Q2 - Platform Tea& Co FirefoxPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activity(8) Jiminnyg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pil(x) Configure SSH access to multipleCa CloudWatch | us-east-2*+ New TabHistoryBookmarksProfilesToolsWindow Helpus-edslz.console.dws.dmdzon.com/clouawd.cm/nome.reelon=us-edstLtnome.aws• search[Option+S]©0 EC2© Elastic Container ServiceG 53 € CodeDeployCo CloudWatchElastiCache 0? Aurora and RDS iêl Amazon OpenSearch Ser... €® CloudFront a MediaLiveCloud WatchICloudWatchFavorites and recentsmgestionDashboardsAlarms Ao O27 ©o• Al Operations• GenAl Observability"Adication SignalsNew• Infrastructure Monitoring• Logs• Metrics New• Network Monitoring• SetupOverview infoOverviewFilter by resource groupAlarms by AWS service infoServicesEC2simole vueue servicein alarm OInsumcient data OoklhlTue 14 Apr 10:56:47Support Daily • in 4h 4m12h1w100% C2"United States (Ohio) *Account ID: 4387-4037-0364STAGE]Custom !UTC timezoneActionsview recentalarms casnooareiRecent alarms info• meeting-bots-ec2-cpu-utilization|• meeting-bot-sqs-alarm(1)CPUUtilization > 50 for 1 datapoints within 5 minutes - (50)05:0005:5006:0006:300/:0007:5005:0005:5006:0006:300/:0007:30Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboardApplication InsightsGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it worksConfigure Application InsightsCloudShellreedback9 2026, Amazon Web Services, Inc, or its arhliates.PrivacyTermscookie preterences...
|
NULL
|
NULL
|
NULL
|
9898
|
|
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
Directories
platform-inner-team
ai-chapter
alerts
backend
confusion-clinic
curiosity_lab
engineering
frontend
general
infra-changes
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Steliyan Georgiev
Adelina Petrova
,
Ilian Kyuchukov
,
Steliyan Georgiev
Adelina Petrova
Galya Dimitrova
Vasil Vasilev
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Yankov
Nikolay Yankov
Jira Cloud
Toast
Google Calendar
Messages
Messages
Add canvas
Add canvas
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Steliyan Georgiev
Apr 8th at 4:12:14 PM
4:12 PM
Все още кодът не e в master, защото ПРът не е одобрен, но ето така изглежда един примирен рекуест за Panorama report:
curl -X 'POST' \
'
http://localhost:9080/ask-anything-on-demand/request-report
http://localhost:9080/ask-anything-on-demand/request-report
' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '{
"userQuestion": "What are the most common topics in these calls?",
"history": [
],
"attemptNumber": 1,
"callIds": [
"77332439",
"74714697",
"34525304",
"2574920"
],
"teamId": 1,
"request_id": "test_req_q_2",
"callback_url": "
https://localhost:8080
https://localhost:8080
",
"reportPeriod": "Apr 1 - Apr 8"
}'
Lukas Kovalik
Apr 8th at 4:12:58 PM
4:12 PM
ще го наглася
(edited)
1 reaction, react with +1 emoji
1
Add reaction…
Jump to date
Nikolay Yankov
Today at 10:19:59 AM
10:19 AM
като създам дефиниция daily, веднага ли трябва да създаде репорт?
Nikolay Yankov
Today at 10:32:27 AM
10:32 AM
10 мин минаха, още не идва репорт
Lukas Kovalik
Today at 10:34:10 AM
10:34 AM
не само daily но трябва да се пусне команда
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:35:08 AM
10:35
php artisan automated-reports
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:35:39 AM
10:35 AM
значи не създава веднага по принцип, в някакъв час на деня ли стъздава?
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:36:11 AM
10:36 AM
това ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:36:27 AM
10:36
крон го пуска през нощ
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:37:19 AM
10:37
така че мануално пусни при тестване
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:38:26 AM
10:38
ако трябва да тестваме други репорти може да променя команда за тестване да приема параметър за report template и д си пускаме определен когато тестваме
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:41:03 AM
10:41 AM
можеш ли да я ръннеш ти командата
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:43:05 AM
10:43 AM
да
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
New
Nikolay Yankov
Today at 10:45:52 AM
10:45 AM
пиши кат оя ръннеш
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:52:52 AM
10:52 AM
забавих се че ми се разбазикаха settings за среди
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
FirefoxPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activity(8) Jiminnyg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pil(x) Configure SSH access to multipleCa CloudWatch | us-east-2*+ New TabHistoryBookmarksProfilesToolsWindow Helpus-edslz.console.dws.dmdzon.com/clouawd.cm/nome.reelon=us-edst-Ltnome.aws• search[Option+S]©0 EC2Elastic Container ServiceG 53 CodeDeployCo CloudWatchElasticache (03) Aurora and RDS ill Amazon OpenSearch Ser... ®) CloudFront MedialiveCloud WatchICloudWatchFavorites and recentsmigestionDashboardsAlarms Ao O27 ©o• Al Operations• GenAl Observability"Adication SignalsNew• Infrastructure Monitoring• Logs• Metrics New• Network Monitoring• SetupOverview infoOverviewFilter by resource group•)Alarms by AWS service infoServicesEC2simole vueue servicein alarm OInsufficient data 0OK21nSupport Daily • in 4h 4m1w100% C28 Tue 14 Apr 10:56:53United States (Ohio) *Account ID: 4387-4037-0364STAGE]Custom !UTC timezoneActionsvew recentalarms casnooaroi•(1)(1)Recent alarms info• meeting-bots-ec2-cpu-utilizationPercent50%Cruurilizarion > b0 Tor carapoints Witnin • minures - (50).®27%4.04%05:0005:3006:0006:3007:0007:30• Cruutilization• meeting-bot-sqs-alarmLount8.7E-34.42-304:0005:00- vumperorvesscceskecelveo• NumberOfMessagesReceived (expected)06:0007:00Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboardApplication InsightsGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it worksConfigure Application InsightsCloudShellreedback9 2026, Amazon Web Services, Inc, or its arhliates.PrivacyTermscookie preterences...
|
Slack
|
Aneliya Angelova, Nikolay Yankov, Steliyan Georgie Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev (DM) - Jiminny Inc - 1 new item - Slack...
|
NULL
|
9899
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFileEditVi +SlackEDHomeDMsActivityFilesLater..•MoreFileEditViewGo+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-team(*)Channels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelplihlSupport Daily - in 4h 3m100% <47→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+TMOTOY TARNOY XOOLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:57:00New...
|
NULL
|
NULL
|
NULL
|
9902
|
|
FirefoxFileEoitViewHistoryPlatform Sprint 1 Q2 - P FirefoxFileEoitViewHistoryPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activity8 Jiminnyg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformJY-20543 add AJ reports User pil(x) Configure SSH access to multipleCa CloudWatch | us-east-2*+ New TabBookmarksProfilesToolsWindow Helpus-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2#home:aws• search[Option+5] ©]0 EC2© Elastic Container ServiceG 53 € CodeDeployCo CloudWatchElastiCache F0? Aurora and RDS iêl Amazon OpenSearch Ser…..CloudFront B MediaLiveCloud WatchICloudWatchFavorites and recentsmgestionDashboardsAlarms Ao O27 ©o• Al Operations• GenAl ObservabilityAplication SignalsNew• Infrastructure Monitoring# Logs• Metrics New• Network Monitoring• SetupOverview infoOverviewFilter by resource group•)Alarms by AWS service infoServicesEC2simole vueue servicein alarm OInsufficient data 0OK212hj Support Daily • in 4h 4mUnited States (Ohio) *1wA100% CS•Tue 14 Apr 10:57:00Account ID: 4387-4037-0364Custom !UTC timezoneActions ™vew recentalarms casnooarei•(1)(1)Recent alarms info• meeting-bots-ec2-cpu-utilizationPercent50%Cruurilizarion > b0 Tor carapoints Witnin • minures - (o0)27%4.04%05:0005:3006:0006:3007:0007:30• Cruutilization• meeting-bot-sqs-alarmLount4.42-304:0005:00- vumperorvessadeskeceveo• NumberOfMessagesReceived (expected)06:0007:00Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboardApplication InsightsGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it worksConfigure Application InsightsCloudShellreedback9 2026, Amazon Web Services, Inc, or its arhliates.PrivacyTermscookie preterences...
|
NULL
|
NULL
|
NULL
|
9903
|
|
Firefox File•.••<Eoit→ViewHistory Bookmarks P Firefox File•.••<Eoit→ViewHistory Bookmarks ProfilesTools Window Help© us-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2# Support Daily • in 4h 3mA100% C & Tue 14 Apr 10:57:06awsPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple eConsole Home | Console Home | use SecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User piloSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activitya Jiminny8 Ask Jiminny test report - 8 Apr 20:# Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc(x) Configure SSH access to multiple• Cloudwatch console+ New Tabwransteruine data tromus-east-z.console.aws.amazon.com...
|
NULL
|
NULL
|
NULL
|
9906
|
|
FirefoxFileEoitViewHistoryawsO EC2BookmarksProfile FirefoxFileEoitViewHistoryawsO EC2BookmarksProfilesToolsWindow Helpus-east-2.console.aws.amazon.com/cloudwatch/home?region=us-east-2Q Search@ Elastic Container Servicef s3 CodeDeployCa CloudWatchC40mO#Support Daily - in 4h 3m (A 100% C4• 8 Tue 14 Apr 10:57:09[Option+S]]( ElastiCache Ko:) Aurora and RDS i&l Amazon OpenSearch Ser…..United States (Ohio)Account ID: 4387-4037-0364STAGE)• CloudFront MediaLivePlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple e@ Console Home | Console Home | usSecurityGroup | EC2 |us-east-2JY-20543 add AJ reports User pilc5 SRD-6779 | JY-20632 | Unable to( Jy 19798 evaluation for ai activitya Jiminnyg Ask Jiminny test report - 8 Apr 201≤ Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc~ Contigure SsH access to multipleCloudWatch | us-east-2+ New TabCloudShellreedback© 2026, Amazon Web Services, Inc. or its affiliates.PrivacyTermsCookie preferences...
|
NULL
|
NULL
|
NULL
|
9907
|
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Code changed:
Hide
Sync Changes
Hide This Notification
8
1
1
Previous Highlighted Error
Next Highlighted Error
<?php
namespace Jiminny\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Carbon;
use Jiminny\Traits\RequiresUUID;
/**
* Jiminny\Models\AutomatedReportResult
*
* @property int $id
* @property string $uuid
* @property int $report_id
* @property string|null $name
* @property int $status
* @property int $reason
* @property string $media_type
* @property int|null $parent_id
* @property array|null $payload
* @property array|null $response
* @property Carbon|null $requested_at
* @property Carbon|null $generated_at
* @property Carbon|null $sent_at
* @property Carbon|null $created_at
* @property Carbon|null $updated_at
* @property-read \Jiminny\Models\AutomatedReport $report
* @property-read AutomatedReportResult|null $parent
* @property-read \Illuminate\Database\Eloquent\Collection<int, AutomatedReportResult> $children
*/
class AutomatedReportResult extends Model
{
use RequiresUUID;
/**
* Status constants
*/
public const int STATUS_DEFAULT = 0;
public const int STATUS_REQUESTED = 1;
public const int STATUS_GENERATED = 2;
public const int STATUS_SENT = 3;
public const int STATUS_FAILED = 4;
/**
* Reason constants
*/
public const int REASON_DEFAULT = 0;
public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;
public const int REASON_PROPHET_API_ERROR = 2;
protected $table = 'automated_report_results';
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
*/
protected $fillable = [
'report_id',
'name',
'status',
'reason',
'media_type',
'parent_id',
'payload',
'response',
'requested_at',
'generated_at',
'sent_at',
];
/**
* Get the attributes that should be cast.
*
* @return array<string, string>
*/
protected function casts(): array
{
return [
'payload' => 'array',
'response' => 'array',
'requested_at' => 'datetime',
'generated_at' => 'datetime',
'sent_at' => 'datetime',
];
}
/**
* Get the automated report that owns this result.
*
* @return BelongsTo
*/
public function report(): BelongsTo
{
return $this->belongsTo(AutomatedReport::class, 'report_id')->withTrashed();
}
/**
* Get the parent report result.
*
* @return BelongsTo
*/
public function parent(): BelongsTo
{
return $this->belongsTo(self::class, 'parent_id');
}
/**
* Get the child report results.
*
* @return HasMany
*/
public function children(): HasMany
{
return $this->hasMany(self::class, 'parent_id');
}
/**
* Get the ID of the automated report result.
*
* @return int
*/
public function getId(): int
{
return $this->getAttribute('id');
}
/**
* Get the UUID of the automated report result.
*
* @return string
*/
public function getUuid(): string
{
return $this->getAttribute('id_string');
}
/**
* Get the report ID of the automated report result.
*
* @return int
*/
public function getReportId(): int
{
return $this->getAttribute('report_id');
}
/**
* Get the name of the automated report result.
*
* @return ?string
*/
public function getName(): ?string
{
return $this->getAttribute('name');
}
/**
* Get the status of the automated report result.
*
* @return int
*/
public function getStatus(): int
{
return $this->getAttribute('status');
}
/**
* Get the reason of the automated report result.
*
* @return int
*/
public function getReason(): int
{
return $this->getAttribute('reason');
}
/**
* Get the media type of the automated report result.
*
* @return string
*/
public function getMediaType(): ?string
{
return $this->getAttribute('media_type');
}
/**
* Get the parent ID of the automated report result.
*
* @return int|null
*/
public function getParentId(): ?int
{
return $this->getAttribute('parent_id');
}
/**
* Get the payload of the automated report result.
*
* @return array|null
*/
public function getPayload(): ?array
{
return $this->getAttribute('payload');
}
/**
* Get the response of the automated report result.
*
* @return array|null
*/
public function getResponse(): ?array
{
return $this->getAttribute('response');
}
/**
* Get the requested at date of the automated report result.
*
* @return Carbon|null
*/
public function getRequestedAt(): ?Carbon
{
return $this->getAttribute('requested_at');
}
/**
* Get the generated at date of the automated report result.
*
* @return Carbon|null
*/
public function getGeneratedAt(): ?Carbon
{
return $this->getAttribute('generated_at');
}
/**
* Get the sent at date of the automated report result.
*
* @return Carbon|null
*/
public function getSentAt(): ?Carbon
{
return $this->getAttribute('sent_at');
}
/**
* Get the created at date of the automated report result.
*
* @return Carbon
*/
public function getCreatedAt(): Carbon
{
return $this->getAttribute('created_at');
}
/**
* Get the updated at date of the automated report result.
*
* @return Carbon
*/
public function getUpdatedAt(): Carbon
{
return $this->getAttribute('updated_at');
}
/**
* Check if the report result is in requested status.
*
* @return bool
*/
public function isRequested(): bool
{
return $this->getStatus() === self::STATUS_REQUESTED;
}
/**
* Check if the report result is in generated status.
*
* @return bool
*/
public function isGenerated(): bool
{
return $this->getStatus() === self::STATUS_GENERATED;
}
/**
* Check if the report result is in sent status.
*
* @return bool
*/
public function isSent(): bool
{
return $this->getStatus() === self::STATUS_SENT;
}
/**
* Check if the report result is in failed status.
*
* @return bool
*/
public function isFailed(): bool
{
return $this->getStatus() === self::STATUS_FAILED;
}
public function getStatusLabel(): string
{
return match ($this->getStatus()) {
self::STATUS_REQUESTED => 'Requested',
self::STATUS_GENERATED => 'Generated',
self::STATUS_SENT => 'Sent',
self::STATUS_FAILED => 'Failed',
default => 'Default',
};
}
public function getReport(): AutomatedReport
{
return $this->getAttribute('report');
}
public function getFromDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['from_date'])) {
return null;
}
return Carbon::parse($payload['from_date']);
}
public function getToDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['to_date'])) {
return null;
}
return Carbon::parse($payload['to_date']);
}
public function getReportType(): ?string
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['report_type'])) {
return null;
}
return $payload['report_type'];
}
public function getGroups(): array
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['group_ids'])) {
return [];
}
return $payload['group_ids'];
}
public function getPdfUrl(): ?string
{
$response = $this->getResponse();
return $response['pdf_url'] ?? null;
}
public function getPodcastAudioUrl(): ?string
{
$response = $this->getResponse();
return $response['podcast_audio_url'] ?? null;
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (34);
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – AutomatedReportResult.php
|
NULL
|
9909
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFileEditVi +SlackEDHomeDMsActivityFilesLater..•MoreFileEditViewGo+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelplihlSupport Daily - in 4h 3m100% <47→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+TMOTOY TARNOY XOOLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:57:20New...
|
PhpStorm
|
faVsco.js – AutomatedReportResult.php
|
NULL
|
9910
|
|
PhpStormFileFV faVsco.js vProject vEditViewNavigat PhpStormFileFV faVsco.js vProject vEditViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-iminny K vToolsWindowHelp• CommentContextinterfa© ConferencesOptinOutCi© Controller.php© ExportController.php© FrontendController.phprrontenocont olerau(C) GeocodinaController.ohc neanncneckcontroller.LiveCoachController.ph|© MissingTeamController.© MobileController.phpNotificationController.plNotificationProviderCon© PlaybackController.php© PlaylistController.php© PusherController.phpC) SlackController.pnp(C SupportController.pnpC) TeamSetupController.pl(C) UserAutomatedReports© WelcomeController.php> D MiddlewareRequests> D ResourcesD Responses• Iseralizers> D Transformers© Kernel.phpT, PlavlistTrackResourceTraitT) ValidateCrmConnectionRei› _ Integrations> D Interactions› D Jobs> D Listeners› D Mailv C Models> D Activity• MAi> D AskAnything> M Calendar> M Connection› D Contracts› CrmD ElasticSearchOFeatureOpportunity© ParticipantPlaybackThemeD PlaylistD Scorecard• WebhookC Accountono©Activity.phpC Address.php© AiPrompt.php© AutomatedReport.php© AutomatedReportResult.ph© Calendar.php© Calllmport.php© ReportController.php© AutomatedReportsCommand.phpJiminnyDeouecommana.ongAutomatedReportsSendCommand.php© AutomatedReportsRepository.phpAutomatedReportsService.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.phpCreateActivityLoggedEvent.phpUserPilotActivityListener.php© ActivityLogged.php© AutomatedReportsCallbackService.php© RequestGenerateAskJiminnyReportJob.php• RequestGeneratekeporJob.onoAutomatedReportResult.php= custom.log< console EUi-517518© AutomatedReport.php519* @property Carbon|null $updated_at520HOYIYTA* @property-read JiminnyWModels|AutomatedReport $report* @property-read AutomatedReportResult/null $parent* @property-read LIzluminatelRatabaselELoquent\Collection<int, AutomatedReportResult> $ch 523522select * tron reans where 1o =133 Qgclass AutomatedReportResult extends Model523526select * from groups g JOIN playbooks p 1..n<-›1: on g.playbook_id = p.id where g.team_id = 1;select x t'oi arouos vere 1o = 909.use RequiresUUID;S2/select * from playbooks where team_id = 1;528select * from playbooks where id = 175;/**529select * from playbook_categories where playbook_id = 175;* Status constants530select * from users where team_id = 1;531select * from users where id = 7160;6 usages532select * from crm_profiles where user_id = 7160;pubLic const 1nt SIATUS_UEFAULT = 0;533select * from features;8 usages534selectpublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;• Extract Surround* Reason constants—536537538539540541542543# id, vvid, type, provider, playbook_category_id, user_id,lead_id, contact_id, account_id, opportunity.# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type ='conference'# and crm_provider_id IS NOT NULLand provider != 'uploader' and actual_start_time IS NOT NULLORDER by id desc;select * from activities where id = 54747783; # 00U0400000pCZojMAC53 Ct6 usagespUDLic const 1nt REASUN_UEFAUll = 0;4 usagespublic const int REASON_NOT_ENOUGH_ACTIVITIES = 1;5 usagespublic const int REASON_PROPHET_API_ERROR = 2;protected $table = 'automated_report_results';/*** The attributes that are mass assignable.* @var array<int, string>protected $fillable = ["report_id',' name',Statusredson,'media_type','parent_id','payload','response','requested_at','generated_at',"sent_at",Windsurf changelog 2.12.21: A new version is available. // View Changelog (24 minutes ago)546547548549550551552553555556560-561562563564565E laravel.logA SF [jiminny@localhost]A HS_local [jiminny@localhost]A console [STAGING] X© AskJiminnyReportActivityService.phpAl console [PROD]© RequestGenerateAskJiminnyReportJobTest.phpfo?Tx: Auto vMlaycroundvSa jiminny vCONCAT (u.id, CASE WHEN U.id = t.owner_id THEN ' (owner) ' ELSE " END) AS USI016 A 13 X13 ^ vU. Clllall.sa.*t.owner_id FROM social_accounts saJOIN users u on u.id = sa.sociable_idJOIN teams t1.n<->1: on t.id = u.team_idWheke Urteam o s and sarorovlder z.'salesforce';select p.id, p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc 1<->1..n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;1<->1.n: on cl.id = pl.layout_idwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.teamaid = t.idand r.status = 1select * from automated_ report_results where repontaid IN (18, 33);select * from automated_reports;select * from automated_report_results where repontaig IN (34);Support Daily • in 4h 3mA100% |45]Tue 14 Apr 10:57:20RequestGenerateAsk.liminnvRenort.lob TestCascadeFixing ReportControlleAutomated Report Fail+D ..hy is thore report result faled CAutonatedReportResult.phptL44 how could itwLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportkesult.Read ATsta rast context Automaleakepor kesul slAlUs rAILED or markasta.... In 4.125Now ler me also reao Requestceneraterevortjo.oho luiv o certne comolee ocure:Read RequestceerateReportJob.phpSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STAIUS FALLED.ke•vestuener creredoruoekecuestuenerclere.orooonloTrigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES ):• RequestGeJob.php:236-244scount =inr scontentresponse'if ($count < self::MIN_ACTIVITIES_COUNT) €sthis->tan Revort AutomatedReportResult:: REASON NOT ENOUGH ACTUNINDIESIreturn false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Trigger 2 - Any Throwable exception (REASON PROPHET_APT_ ERROR Or REASON_DEFAULT):• ReotJob.php:125-151} catch (Throwable $exception) {$reason = $exception instanceof ProphetException ?AutomatedReportResuLt::REASON_PROPHET_APL_ERROR : Automatedreportr$this->failReport($reason);if (sthis-sattempts() ≤ sthis-stries) eSthis->release(30); // retry after 30selsesihas->tan sexcent lonProphetException → REASON_PROPHET_API_ERROR (Prophet Al API error)Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpointreturns no response key. DB errors, etc.)• The job retries once (2 tries total) before final failureAlso: checkActivityCount throws ApiResponseException if the count APl response ismaltormed — this ouooles un to the catch olock aboveRequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.php)same oatern oUE MIN ACININIES COUNIISETrigger 1 - Fewer than 1 activity from the saved search → REASON_NOT_ENOUGH_ACTIVITIETrigger 2 - Any exception → REASON_PROPHET_API_ERROR if ProphetException, else REASAsk anything (XAL)+ <› CodeClaude Sonnet 4.6winasur leams44:535 charsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
9911
|
|
Project: faVsco.js, menu
#11894 on JY-18909-automa Project: faVsco.js, menu
#11894 on JY-18909-automated-reports-ask-jiminny, menu
Start Listening for PHP Debug Connections
RequestGenerateAskJiminnyReportJobTest
Run 'RequestGenerateAskJiminnyReportJobTest'
Debug 'RequestGenerateAskJiminnyReportJobTest'
More Actions
JetBrains AI
Search Everywhere
IDE and Project Settings
Code changed:
Hide
Sync Changes
Hide This Notification
8
1
1
Previous Highlighted Error
Next Highlighted Error
<?php
namespace Jiminny\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Carbon;
use Jiminny\Traits\RequiresUUID;
/**
* Jiminny\Models\AutomatedReportResult
*
* @property int $id
* @property string $uuid
* @property int $report_id
* @property string|null $name
* @property int $status
* @property int $reason
* @property string $media_type
* @property int|null $parent_id
* @property array|null $payload
* @property array|null $response
* @property Carbon|null $requested_at
* @property Carbon|null $generated_at
* @property Carbon|null $sent_at
* @property Carbon|null $created_at
* @property Carbon|null $updated_at
* @property-read \Jiminny\Models\AutomatedReport $report
* @property-read AutomatedReportResult|null $parent
* @property-read \Illuminate\Database\Eloquent\Collection<int, AutomatedReportResult> $children
*/
class AutomatedReportResult extends Model
{
use RequiresUUID;
/**
* Status constants
*/
public const int STATUS_DEFAULT = 0;
public const int STATUS_REQUESTED = 1;
public const int STATUS_GENERATED = 2;
public const int STATUS_SENT = 3;
public const int STATUS_FAILED = 4;
/**
* Reason constants
*/
public const int REASON_DEFAULT = 0;
public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;
public const int REASON_PROPHET_API_ERROR = 2;
protected $table = 'automated_report_results';
/**
* The attributes that are mass assignable.
*
* @var array<int, string>
*/
protected $fillable = [
'report_id',
'name',
'status',
'reason',
'media_type',
'parent_id',
'payload',
'response',
'requested_at',
'generated_at',
'sent_at',
];
/**
* Get the attributes that should be cast.
*
* @return array<string, string>
*/
protected function casts(): array
{
return [
'payload' => 'array',
'response' => 'array',
'requested_at' => 'datetime',
'generated_at' => 'datetime',
'sent_at' => 'datetime',
];
}
/**
* Get the automated report that owns this result.
*
* @return BelongsTo
*/
public function report(): BelongsTo
{
return $this->belongsTo(AutomatedReport::class, 'report_id')->withTrashed();
}
/**
* Get the parent report result.
*
* @return BelongsTo
*/
public function parent(): BelongsTo
{
return $this->belongsTo(self::class, 'parent_id');
}
/**
* Get the child report results.
*
* @return HasMany
*/
public function children(): HasMany
{
return $this->hasMany(self::class, 'parent_id');
}
/**
* Get the ID of the automated report result.
*
* @return int
*/
public function getId(): int
{
return $this->getAttribute('id');
}
/**
* Get the UUID of the automated report result.
*
* @return string
*/
public function getUuid(): string
{
return $this->getAttribute('id_string');
}
/**
* Get the report ID of the automated report result.
*
* @return int
*/
public function getReportId(): int
{
return $this->getAttribute('report_id');
}
/**
* Get the name of the automated report result.
*
* @return ?string
*/
public function getName(): ?string
{
return $this->getAttribute('name');
}
/**
* Get the status of the automated report result.
*
* @return int
*/
public function getStatus(): int
{
return $this->getAttribute('status');
}
/**
* Get the reason of the automated report result.
*
* @return int
*/
public function getReason(): int
{
return $this->getAttribute('reason');
}
/**
* Get the media type of the automated report result.
*
* @return string
*/
public function getMediaType(): ?string
{
return $this->getAttribute('media_type');
}
/**
* Get the parent ID of the automated report result.
*
* @return int|null
*/
public function getParentId(): ?int
{
return $this->getAttribute('parent_id');
}
/**
* Get the payload of the automated report result.
*
* @return array|null
*/
public function getPayload(): ?array
{
return $this->getAttribute('payload');
}
/**
* Get the response of the automated report result.
*
* @return array|null
*/
public function getResponse(): ?array
{
return $this->getAttribute('response');
}
/**
* Get the requested at date of the automated report result.
*
* @return Carbon|null
*/
public function getRequestedAt(): ?Carbon
{
return $this->getAttribute('requested_at');
}
/**
* Get the generated at date of the automated report result.
*
* @return Carbon|null
*/
public function getGeneratedAt(): ?Carbon
{
return $this->getAttribute('generated_at');
}
/**
* Get the sent at date of the automated report result.
*
* @return Carbon|null
*/
public function getSentAt(): ?Carbon
{
return $this->getAttribute('sent_at');
}
/**
* Get the created at date of the automated report result.
*
* @return Carbon
*/
public function getCreatedAt(): Carbon
{
return $this->getAttribute('created_at');
}
/**
* Get the updated at date of the automated report result.
*
* @return Carbon
*/
public function getUpdatedAt(): Carbon
{
return $this->getAttribute('updated_at');
}
/**
* Check if the report result is in requested status.
*
* @return bool
*/
public function isRequested(): bool
{
return $this->getStatus() === self::STATUS_REQUESTED;
}
/**
* Check if the report result is in generated status.
*
* @return bool
*/
public function isGenerated(): bool
{
return $this->getStatus() === self::STATUS_GENERATED;
}
/**
* Check if the report result is in sent status.
*
* @return bool
*/
public function isSent(): bool
{
return $this->getStatus() === self::STATUS_SENT;
}
/**
* Check if the report result is in failed status.
*
* @return bool
*/
public function isFailed(): bool
{
return $this->getStatus() === self::STATUS_FAILED;
}
public function getStatusLabel(): string
{
return match ($this->getStatus()) {
self::STATUS_REQUESTED => 'Requested',
self::STATUS_GENERATED => 'Generated',
self::STATUS_SENT => 'Sent',
self::STATUS_FAILED => 'Failed',
default => 'Default',
};
}
public function getReport(): AutomatedReport
{
return $this->getAttribute('report');
}
public function getFromDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['from_date'])) {
return null;
}
return Carbon::parse($payload['from_date']);
}
public function getToDate(): ?Carbon
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['to_date'])) {
return null;
}
return Carbon::parse($payload['to_date']);
}
public function getReportType(): ?string
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['report_type'])) {
return null;
}
return $payload['report_type'];
}
public function getGroups(): array
{
$payload = $this->getPayload();
if (empty($payload) || empty($payload['group_ids'])) {
return [];
}
return $payload['group_ids'];
}
public function getPdfUrl(): ?string
{
$response = $this->getResponse();
return $response['pdf_url'] ?? null;
}
public function getPodcastAudioUrl(): ?string
{
$response = $this->getResponse();
return $response['podcast_audio_url'] ?? null;
}
}
Execute
Explain Plan
Browse Query History
View Parameters
Open Query Execution Settings…
In-Editor Results
Tx: Auto
Cancel Running Statements
Playground
jiminny
Sync Changes
Hide This Notification
Code changed:
Hide
16
13
13
Previous Highlighted Error
Next Highlighted Error
SELECT * FROM teams WHERE id = 1;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 283;
SELECT * FROM crm_fields WHERE id = 2234;
SELECT * FROM crm_field_values WHERE crm_field_id = 2234;
select * from crm_profiles where user_id = 143;
select * from record_types where crm_configuration_id = 39; # 0121K000001MHElQAO,0121K000001MHEqQAO
select * from business_processes where crm_configuration_id = 39;
# 01941000000H669AAC, 01941000000H66JAAS
select * from record_type_field_values
where record_type_id IN (24);
select * from crm_field_values where id IN (2730);
select * from crm_configurations where id = 39;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce'; #1035
select * from users where team_id = 1; # 222 group 3
SELECT * FROM activities WHERE user_id = 222 order by id desc;
select * from sidekick_settings where team_id = 1;
select * from teams where id = 1;
select * from team_features where team_id = 1;
select * from activities where crm_configuration_id = 2
and provider = 'ms-teams' and id = 608765;
SELECT * FROM activities WHERE crm_configuration_id = 2 and crm_provider_id = '59523413338';
select * from sidekick_settings where team_id = 2;
SELECT * FROM activities WHERE id = 608660;
select * from activity_summary_logs where activity_id = 608660;
select * from ai_prompts where transcription_id = 11214;
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('ed78a437-2804-450e-ab2f-56ab1c641346') = uuid;
# id: 608818, crm: 59628809737
SELECT * FROM activities WHERE uuid_to_bin('36b06e55-afdd-4782-8dee-c624cd0af191') = uuid;
# id: 608821, crm: 59632069252
SELECT ce.start_time, ce.end_time, a.id, a.uuid, crm_provider_id, calendar_event_id, title,
playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id,
scheduled_start_time, scheduled_end_time, actual_start_time, actual_end_time, a.created_at
FROM activities a
join calendar_events ce on a.calendar_event_id = ce.id
WHERE a.id IN (608818, 608821);
select * from users where team_id = 1;
select * from team_settings where team_id = 1;
select * from crm_profiles where crm_configuration_id = 39 order by user_id;
select * from team_features where team_id = 1;
select * from users where team_id = 2;
SELECT * FROM activities WHERE uuid_to_bin('ec7647e9-5225-458b-b475-f31aa2769204') = uuid; # 612639
# Preslava N. Ivanova, grou id 3
SELECT * FROM opportunities WHERE uuid_to_bin('a2928fe5-aec5-46cb-85d9-7654c89e46a6') = uuid;
select * from activities where opportunity_id = 344 and actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00';
select
a.id,
a.type,
a.scheduled_start_time,
a.actual_start_time,
a.created_at,
a.opportunity_id,
a.status
FROM activities a
WHERE opportunity_id = 344
and status IN ('completed', 'received', 'delivered')
and (
(a.actual_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.created_at between '2024-10-11 00:00:00' and '2024-10-12 00:00:00')
OR (a.scheduled_start_time between '2024-10-11 00:00:00' and '2024-10-12 00:00:00'))
;
SELECT * FROM users WHERE id = 222;
SELECT * FROM crm_profiles WHERE user_id = 222;
select * from crm_layouts where crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 281;
select * from group_deal_risk_types;
select * from opportunities where team_id = 1;
SELECT * FROM opportunities WHERE id = 315;
SELECT * FROM crm_field_data WHERE object_id = 315;
select * from crm_field_data where object_id = 260;
select * from generic_ai_prompts where subject_id = 315;
select * from teams; # 36, 21, 121, [EMAIL]
SELECT * FROM social_accounts WHERE sociable_id = 121 and provider = 'bullhorn';
# [PASSWORD_DOTS]
select * from teams where id = 1;
select * from crm_configurations where id = 39;
select * from users where team_id = 1;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 1;
# 1 - 00541000004281rAAA
# 204 - 0052g000003freeAAA
# 429 - 0052g000003qGOiAAM
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
select * from activities where type = 'softphone'
and created_at > '2024-12-11 15:24:36' order by id desc;
select * from activity_providers where team_id = 1;
select * from activity_provider_users where activity_provider_id = 328;
select * from opportunities where crm_configuration_id = 39
AND account_id = 178 AND is_closed = false
order by created_at DESC;
select * from contacts where id = 3952;
select * from accounts where id = 178;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations where id = 21;
select * from users where team_id = 36;
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 36
and sa.provider = 'bullhorn';
select * from social_accounts where id = 348;
UPDATE social_accounts SET
provider_user_token = '21442_6802599_91:41179a58-21e7-4d7c-ad58-56bb666b2f65',
provider_refresh_token = '21442_6802599_91:01c6b335-3f2a-42e4-85ff-8a08fa65fceb',
expires = 1733998131,
state = 'connected'
WHERE id = 348;
# [PASSWORD_DOTS]
select * from teams where id = 31;
select * from crm_configurations where id = 18;
select * from users where team_id = 31; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 31;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 31
and sa.provider = 'close';
select * from contacts where crm_configuration_id = 18;
# [PASSWORD_DOTS] NEPTUNE [PASSWORD_DOTS]
select * from teams;
select * from users where id IN (1030, 1035, 1052);
select * from crm_configurations;
select * from users where team_id = 65; # 257
select * from team_settings where team_id = 65; # 257
select * from invitations where team_id = 65; # 257
select * from users where email = '[EMAIL]'; # 257
select u.email, cp.* from users u
join crm_profiles cp on u.id = cp.user_id
where u.team_id = 65;
select * from crm_configurations where id = 53;
select * from accounts where crm_configuration_id = 53 order by id desc;
select * from leads where crm_configuration_id = 53 order by id desc;
select * from contacts where crm_configuration_id = 53 order by id desc;
select * from opportunities where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 53 order by id desc;
select * from crm_fields where crm_configuration_id = 53 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 53 order by id desc;
select * from stages where crm_configuration_id = 53 order by id desc;
select * from crm_profiles where crm_configuration_id = 13;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
and sa.provider = 'integration-app';
select * from contacts where crm_configuration_id = 13;
select * from social_accounts where sociable_id = 283;
SELECT * FROM opportunities WHERE crm_provider_id = '006O400000E9bzeIAB';
select * from activity_providers where team_id = 65;
SELECT * FROM activities WHERE crm_configuration_id IN (51, 52, 53);
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 65
;
# [PASSWORD_DOTS] STAGING [PASSWORD_DOTS]
SELECT * FROM teams;
SELECT * FROM teams WHERE id = 88;
SELECT * FROM teams WHERE id = 89;
select * from team_settings where team_id = 89;
SELECT * FROM users WHERE team_id = 89;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 89;
select * from users;
SELECT * FROM social_accounts WHERE sociable_id = 1761;
SELECT * FROM crm_configurations WHERE id = 70;
select * from accounts where crm_configuration_id = 70 order by id desc;
select * from leads where crm_configuration_id = 70 order by id desc;
select * from contacts where crm_configuration_id = 70 order by id desc;
select * from opportunities where crm_configuration_id = 70 order by id desc;
select * from crm_profiles where crm_configuration_id = 70 order by id desc;
select * from crm_fields where crm_configuration_id = 70 order by id desc;
select * from crm_field_values where crm_field_id = 3536 order by id desc;
select * from crm_layouts where crm_configuration_id = 70 order by id desc;
select * from stages where crm_configuration_id = 70 order by id desc;
select * from business_processes where crm_configuration_id = 70 order by id desc;
select * from business_process_stages where business_process_id = 34;
select * from contacts where id = 10468;
select * from crm_layouts where crm_configuration_id = 70;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 388;
SELECT * FROM crm_fields WHERE id IN (3533,3534,3535);
select * from activities where crm_configuration_id = 70
and (account_id IS NOT NULL or lead_id IS NOT NULL or contact_id IS NOT NULL or opportunity_id IS NOT NULL) order by id desc;
SELECT * FROM activities WHERE uuid_to_bin('2e10b60f-8a61-41c5-a3d4-28835353dc65') = uuid;
SELECT * FROM activities where crm_configuration_id = 69 ;
SELECT * FROM users WHERE email LIKE '%[EMAIL]%';
SELECT * FROM activities WHERE uuid_to_bin('5a150c93-40fc-42ec-b3bd-c1d328e09f6e') = uuid;
SELECT * FROM opportunities WHERE id = 385;
select * from participants p
join activities a on p.activity_id = a.id
where a.crm_configuration_id = 70
and (p.lead_id IS NOT NULL or p.contact_id IS NOT NULL);
SELECT * FROM participants WHERE id = 1013638;
select * from teams where id = 90;
select * from users where team_id = 90;
select * from social_accounts where social_accounts.sociable_id IN (1960,1760);
SELECT * FROM crm_profiles WHERE crm_configuration_id = 71;
select * from invitations where team_id = 90;
select * from crm_configurations where id = 71;
select * from accounts where crm_configuration_id = 71 order by id desc;
select * from leads where crm_configuration_id = 71 order by id desc;
select * from contacts where crm_configuration_id = 71 order by id desc;
select * from opportunities where crm_configuration_id = 71 order by id desc;
select * from crm_profiles where crm_configuration_id = 71 order by id desc;
select * from crm_fields where crm_configuration_id = 71 order by id desc;
select * from crm_field_values where crm_field_id = 3341 order by id desc;
select * from crm_layouts where crm_configuration_id = 71 order by id desc;
select * from stages where crm_configuration_id = 71 order by id desc;
select * from users order by secondary_email desc;
select u.id, u.email, u.status, sa.id, sa.provider_user_id from social_accounts sa
join users u on sa.sociable_id = u.id
where sa.provider = 'google' and u.email LIKE 'aneliya%';
select * from failed_jobs order by id desc;
select * from users where email = '[EMAIL]' or secondary_email = '[EMAIL]';
select * from teams;
SELECT * FROM crm_profiles WHERE crm_configuration_id = 39;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type = 'task';
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 1
and sa.provider = 'salesforce';
# [PASSWORD_DOTS]
SELECT * FROM activities WHERE uuid_to_bin('c38b3895-fd0f-4b1f-9fb2-c170dba137c6') = uuid;
SELECT * FROM crm_configurations WHERE id = 70;
select * from teams where id = 1;
select * from groups where team_id = 1;
select * from users where team_id = 1;
select o.id, o.name,o.close_date, u.id, u.name, u.group_id, r.id, r.display_name, g.name, g.scope from opportunities o
join users u on o.user_id = u.id
join groups g on u.group_id = g.id
join role_user ru on u.id = ru.user_id
join roles r on ru.role_id = r.id
where o.crm_configuration_id = 39 and close_date > '2024-01-01 00:00:00';
select * from role_user where user_id = 143;
select * from roles;
select * from role_user;
select * from groups where id = 9;
select * from scope_groups where group_id = 9;
# [PASSWORD_DOTS]
select * from teams where id = 36;
select * from crm_configurations;
SELECT * FROM social_accounts WHERE sociable_id = 121;
https://crmsandbox.zoho.com/crm/jiminnyw4/tab/Leads/4776201000005049105
https://crmsandbox.zoho.com/crm/
https://crm.zoho.com/crm/org3469620/tab/Leads/230045000229559080
https://crm.zoho.com/crm/
org3469620
SELECT * FROM activities WHERE uuid_to_bin('03382d20-c8bc-48e7-a3d4-90b52fa5ceab') = uuid;
select * from users where email LIKE "%mobile_automation_%";
select * from social_accounts where sociable_id IN (2228);
select * from crm_profiles where user_id IN (2222,2223,2226,2227);
select * from teams order by id desc;
SELECT * FROM users WHERE id = 2229;
SELECT * FROM crm_profiles WHERE user_id = 2229;
select * from opportunities where crm_configuration_id = 88;
select * from crm_fields where crm_configuration_id = 88;
select * from crm_profiles where crm_configuration_id = 88;
SELECT * FROM teams WHERE id = 1;
SELECT * FROM users WHERE id = 143;
SELECT * FROM users WHERE uuid_to_bin('fde193d3-06a2-4e1a-8895-62b94039215d') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73385071-a756-42ae-9c73-8b53f2309467') = uuid;
https://app.staging.jiminny.com/ondemand?
min_duration=1
&
only_recorded=1
&
user_id%5B%5D=641f1acb-16b8-42d1-8726-df52979dad0e
&
sequence_number=2
select * from users where team_id = 1 and email like '%stoyan%'
select * from coaching_feedbacks;
select * from teams;
SELECT * FROM users WHERE team_id = 36;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from users where id = 143;
SELECT * FROM users WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM teams WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
SELECT * FROM activity_shares WHERE uuid_to_bin('73180eeb-33de-4065-977d-ccbe0e6c94fc') = uuid;
select * from users where team_id = 2;
select * from activities where crm_configuration_id = 39
and activities.scheduled_start_time BETWEEN '2025-04-09 00:00:00' AND '2025-04-09 23:59:59'
AND user_id = 143
order by id desc;
# [PASSWORD_DOTS]
select * from teams where id = 142; # 2312, 126
select * from team_settings;
select * from users where team_id = 142; # 21642
SELECT * FROM social_accounts WHERE sociable_id = 21642;
SELECT * FROM crm_profiles cp join users u ON u.id = cp.user_id WHERE team_id = 142;
select * from crm_profiles where id IN (93);
select * from invitations;
select * from team_features where team_id = 1;
SELECT * FROM crm_configurations WHERE id = 126;
select * from accounts where crm_configuration_id = 126 order by id desc;
select * from leads where crm_configuration_id = 126 order by id desc;
select * from contacts where crm_configuration_id = 126 order by id desc;
select * from opportunities where crm_configuration_id = 126 order by id desc;
select * from crm_profiles where crm_configuration_id = 126 order by id desc;
select * from crm_fields where crm_configuration_id = 126 # 11060
# and type IN ('picklist', 'status')
# and object_type = 'task'
order by id desc;
# 5731,5732,5733
select DISTINCT crm_field_id from crm_field_values where crm_field_id IN (11151,12239,12215,12185,12175,12165,12144,12137,12127,12109,12107,12105,12103,12092,12037,12005,12003,11987,11969,11958,11951,11942,11931,11924,11921,11917,11915,11901,11893,11883,11872,11870,11868,11866,11839,11833,11821,11793,11780,11777,11769,11757,11737,11735,11656,11645,11638,11629,11618,11611,11602,11591,11584,11581,11558,11544,11543,11534,11532,11529,11527,11503,11497,11493,11488,11470,11468,11457,11455,11397,11387,11372,11363,11348,11323,11318,11309,11301,11300,11292,11290,11286,11284,11256,11252,11242,11237,11233,11219,11176,11160) order by id desc;
select * from crm_layouts where crm_configuration_id = 126 order by id desc;
SELECT * FROM crm_layout_entities WHERE crm_layout_id in (300,299,298);
select * from stages where crm_configuration_id = 126 order by id desc;
select * from business_processes where crm_configuration_id = 126 order by id desc;
select * from business_process_stages where business_process_id IN (76,75,74,73);
select * from playbooks where team_id = 142;
select * from playbook_layouts where playbook_id IN (108);
SELECT * FROM playbook_categories WHERE playbook_id IN (108);
select * from teams where id = 130;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 2
and sa.provider = 'hubspot';
SELECT * FROM activities
WHERE crm_configuration_id = 110;
select * from teams;
select * from crm_configurations;
SELECT * FROM activities WHERE id = 628773;
SELECT * FROM crm_profiles WHERE user_id = 1460;
SELECT * FROM social_accounts WHERE sociable_id = 2291;
select * from teams;
select ru.*, pr.*, p.* from users u join role_user ru on ru.user_id = u.id
join permission_role pr on pr.role_id = ru.role_id
join permissions p on p.id = pr.permission_id
where team_id = 495 and p.name IN ('dial');
select * from teams where id = 145;
select * from crm_configurations where id = 129;
select * from social_accounts where sociable_id = 2317;
SELECT * FROM activities WHERE uuid_to_bin('8dbab184-a333-4268-ad57-fb41f8d53a9a') = uuid;
select * from teams where id = 1;
SELECT * FROM crm_layouts WHERE crm_configuration_id = 39;
SELECT * FROM crm_layout_entities WHERE crm_layout_id = 280;
SELECT * FROM crm_layout_entities WHERE id = 5507;
SELECT * FROM crm_fields WHERE crm_configuration_id = 39 and object_type IN ('event');
select * from teams;
select * from activities where crm_configuration_id = 14;
SELECT * FROM social_accounts where provider = 'copper';
select * from activities where id = 628467;
select * from participants where activity_id = 628467;
SELECT * FROM contacts WHERE id = 3969;
SELECT * FROM accounts WHERE id = 177;
SELECT * FROM activities WHERE uuid_to_bin('4eb54c77-cfa3-2bd4-84a7-9ed46a21c988') = uuid;
# [PASSWORD_DOTS] BH
select * from teams where id = 36;
SELECT * FROM crm_configurations WHERE id = 21;
select * from activities where crm_configuration_id = 21 and id = 607901;
select * from activities where crm_configuration_id = 21;
select * roles;
select * from permissions;
select * from permission_role where permission_id = 226;
select * from migrations order by id desc;
# mercury
# neptune
# earth
select * from teams;
select * from teams where id = 19;
select * from teams where id = 27;
select * from users where team_id = 27;
SELECT * FROM crm_configurations WHERE id = 42;
select * from social_accounts sa
join users u on sa.sociable_id = u.id
where u.team_id = 19
and sa.provider = 'pipedrive';
select * from activities where id = 631461;
SELECT * FROM crm_field_values WHERE crm_field_id = 180;
select * from teams where id = 2;
SELECT * FROM social_accounts WHERE sociable_id = 89;
SELECT * FROM activities WHERE uuid_to_bin('ba0c029a-bc14-4e17-8603-64174acebcbb') = uuid; # 634273
select * from activity_summary_logs where activity_id = 634273;
select * from sidekick_settings where team_id = 2;
select * from teams; # 2, 2
SELECT * FROM crm_configurations WHERE team_id = 2; # 2
select * from team_features where team_id = 2;
select * from features;
SELECT * FROM opportunities WHERE crm_configuration_id = 2 and crm_provider_id = '51317301383';
SELECT * FROM opportunities WHERE crm_configuration_id = 2 order by id desc;
select * from automated_reports order by id desc;
select * from automated_report_results order by id desc;
select * from users where team_id = 1 and id IN (7160, 3248);
select * from migrations order by id desc;
SELECT
CONCAT(u.id, CASE WHEN u.id = t.owner_id THEN ' (owner)' ELSE '' END) AS user_id,
u.email,
sa.*,
t.owner_id FROM social_accounts sa
JOIN users u on u.id = sa.sociable_id
JOIN teams t on t.id = u.team_id
WHERE u.team_id = 1 and sa.provider = 'salesforce';
select * from teams where id = 1;
select * from groups g JOIN playbooks p on g.playbook_id = p.id where g.team_id = 1;
select * from groups where id = 565;
select * from playbooks where team_id = 1;
select * from playbooks where id = 175;
select * from playbook_categories where playbook_id = 175;
select * from users where team_id = 1;
select * from users where id = 7160;
select * from crm_profiles where user_id = 7160;
select * from features;
select
*
# id, uuid, type, provider, playbook_category_id, user_id, lead_id, contact_id, account_id, opportunity_id, stage_id,
# crm_configuration_id, crm_provider_id, transcription_id, status
from activities where crm_configuration_id = 1 and type = 'conference'
# and crm_provider_id IS NOT NULL
and provider != 'uploader' and actual_start_time IS NOT NULL
ORDER by id desc;
select * from activities where id = 54747783; # 00UO400000pCzojMAC
select p.id, p.activity_type, pc.id, pc.name
FROM playbooks p
join playbook_categories pc on p.id = pc.playbook_id
where p.team_id = 1 and p.activity_type = 'event';
SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';
SELECT * FROM crm_field_values WHERE crm_field_id = 4;
select * from crm_layouts cl join playbook_layouts pl on cl.id = pl.layout_id
where crm_configuration_id = 1 and pl.playbook_id = 175;
select * from teams;
SELECT r.* FROM automated_reports r
join teams t on r.team_id = t.id
WHERE r.frequency = 'daily'
and r.status = 1
AND t.status = 'active'
AND (r.expires_at >= now() OR r.expires_at IS NULL);
select * from automated_report_results where report_id IN (18, 33);
select * from automated_reports;
select * from automated_report_results where report_id IN (34);
Project
Project
New File or Directory…
Expand Selected
Collapse All
Options
Hide...
|
PhpStorm
|
faVsco.js – AutomatedReportResult.php
|
NULL
|
9912
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFileEditVi +SlackEDHomeDMsActivityFilesLater..•MoreFileEditViewGo+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelplihlSupport Daily - in 4h 3m100% <47→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+TMOTOY TARNOY XOOLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:57:34New...
|
NULL
|
NULL
|
NULL
|
9913
|
|
PhpStormFileEditToolsWindowHelpFV faVsco.s vProjec PhpStormFileEditToolsWindowHelpFV faVsco.s vProject vViewNavigateCodeLaravelRefactor#11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php= .env=.env.circleci=.env.circleci-nightly= .env.local=.env.migrate=.env.nikilocalE env.othenenv.oroduction=.env.production-eu=.env.ga= .env.qaiE .env.rootE.env.staging=.gitattributes• .gitignore=.php-cs-fixer.cachephp.php-cs-fixer.dist.phppnp onostormimera.one=.phpunit.result.cache=.prettierignoreE .windsurfrulespip lue nelper.onephp_ide_helper_models.phpphp artisanO composer.json0 composer.lock0 dependency-checker.json dev.jsonEids.txtEinfection.ison.distM+INSIALL.moM+ INTERNAL_WEBHOOK_SETUP.mcEjiminny_storageM+ licenses.mdM MakefileO package-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTe raw_sql_query.sqlM- KEADMEMO{0 sonar-project.properties=test.py<> Untitled Diagram.xmlIs vetur.config.jsM+ WEBHOOK_FILTERING_IMPLEMEI› ib External LibrariesE Scratches and Consolesv M Database Consoles, & lminnva ocalhostAPRUDÁ QA4 QAI4 QAI PRODV A STAGINGA console [STAGING]A console_1 [STAGING]« uranus [STAGING]yJiminnyDeouecommana.ongAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php) AutomatedReportsService.php© CreateActivityLoqgedEvent.phpc UserrilotacuiviiyListener.ongActivityLoagea.onp(e AutomatedRenortscalllbackService.onv© RequestGenerateAsKJiminnyReportJob.phpRequestGenerateReportJob.php© AutomatedReportResult.php x© AutomatedReport.php* @property Carbon/null $updated_atA8X1X1A* Oproperty-read Jiminny\Models\AutomatedReport $report* @property-read AutomatedReportResult|null $parent* Oproperty-read JIlluminatelRatabase)Eloquent|Collection<int, Automat 52333 (U9class AutomatedReportResult extends Model53 Gt60 6use reoutresuuro./*** scacus conscants*/o usaeespublic const int STATUS_DEFAULT = 0;o usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;pubLic const 1nt SIATUS_SENI = 5:public const int STATUS_FAILED = 4;* Reason constants*/o usages4 usdyes5 usagespublic const int REASON_DEFAULT = 0;public const int REASON_NOT_ENOUGH_ACTIVITIES = 1;PUDLIC Const Int REASUN_PRUPHEI_APL_ERRUR = 21protected Stable ='automated report results':/*** The attributes that are mass assignable.* @var array<int, string>protected $fillable = ['report_id',"name"'status',reason",'media_type',parent_ld'payload',"response',' requested_at',' generated_at','sent_at',Winasurt changelog 2.12.21: A new version is avallable. |/ View Changelog (24 minutes agoE custom.logconsole PRODI= laravel.logL console [EUlA SF ljiminny@localhost]A HS_local [iminny@localhost]L console [SlAGING X© AskJiminnyReportActivityService.phpC RequestGenerateAskJiminnyReportJobTest.phpx:Autov517520521522=525526527152815565510045345355365375385395405415425435445455465475485495501551552555556—558559560561562563564565566 v567PlaygroundCONCAT(u.id, CASE WHEN U.id = t.owner_id THEN ' (ownerDo jiminny016 A13 V13 M Vsarxt.owner_id FROM social_accounts saJOIN users u on U.id= sa.sociable idJOIN teams t 1..n<->1: on t.id = u.team_idWHERE U.team_id = 1 and sa.provider = 'salesforce';select * from teams where id = 1;select * from groups g JOIN playbooks p 1.n<->1: on g.playbook_id = p.id where g.tselect * from groups where id = 565;select * from playbooks where team_id = 1;select * from playbooks where id = 175;Iselect * from plavbook categories where plavbook id = 175:Iselect * from users wherereall0=select * from users where id = 7160;select * from crm_profiles where user_id = 7160;select * from features;select# id, uvid, type, provider, playbook_category_id, user_id, lead_id, contact_id, ac# crm_configuration_id, crm_provider_id, transcription_id, statusfrom activities where crm_configuration_id = 1 and type = 'conference'*ano crn orovloer 10 1o NU NULIand provider != 'uploader' and actual_start_time IS NOT NULLURUcK Dy 10 desc,select * from activities where id = 54747783; # 00U0400000pCzojMACseceel o.ru,p.activity_type, pc.id, pc.nameFROM playbooks pjoin playbook_categories pc1<->1.n: on p.id = pc.playbook_idwhere p.team_id = 1 and p.activity_type = 'event';SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';oeeee * Fror cen telo values wirke cen tleld o a4select * from crm lavouts cl ioin plavbook lavouts plwhere crm confiquration id = 1 and pl.plavbook id = 175:1<->1..n: on cl.id = pl.lavouselect * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r. freguency = 'daily'and r-status = 1AND tstatus = ''active'AND (r-expinescat >= now() OR r.expines.at IS NULL):select * trom automaced_report_results where report na IN (1o, 55):select * from automated_reports;select x Trom aucomared_report-resocts where cetmata iN (09)Support Daily • in 4h 3mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 10:57:35CascadeFixing ReportControlleAutomated Report Faill1 ..why is there report result failed @AutomatedReportResult.php#L44 how could it happenLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportResult.Read AutomatedReportResult.phpw68 Fast Context AutomatedReportResult STATUS_FAILED or markAsFailed or failed automated report result in 4.12sNow let me also read RequestGenerateReportJob.php fully to get the complete picture:kead kequestceneratekeportJob.ongSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth iobs call a private failReport(int $reason) method that updates the result to STATUS FATLED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES ):iRequestceneraterepori00.0ho:230-244$count = (int) $content['response'];if ($count < self: :MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult:: REASON_NOT_ENOUGH_ACTIVITIES);return false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Trigger 2 - Any Throwable exception ( REASON_PROPHET_API_ERROR or REASON_DEFAULT):M RequestGenerateReport.Job.php:125-151}catch (Throwable $exception) "sreason = Sexception instanceot ProphetException ?AutomatedReportResult: : REASON_PROPHET_API_ERROR : AutomatedReportResult::REASON_DEFAULT;$this->failReport(Sreason);if (sthis-→attempts() < sthis-tries) &Sthis->release (30): // retry after 30sj else {sthisstan" sexcention)ProphetException → REASON_PROPHET_API_ERROR (Prophet Al APl error)Anything else → REASON_DEFAULT (e.g., ApiResponseException when count endpoint returns no response key, DB errors, etc.)The job retries once (2 tries total) before tinal tallureAlso: checkActivityCount throws ApiResponseException if the count API response is malformed - this bubbles up to the catch block above.RequestGenerateAskJiminnyReportJob (RequestGenerateAskJiminnyReportJob.php)same oatern oUE MIN ACININIES COUNISTrigger 1 - Fewer than 1 activity from the saved search → REASON_NOT_ENOUGH_ACTIVITIESTrigger 2 - Any exception → REASON PROPHET API ERROR if ProphetException, else REASON DEFAULT. Retries once with 30s delay.Summary of Failure CausesReasonREASON_NOT_ENOUGH_ACTIVITIESKEASON PRUPNEI AFL CRKOKAsk anything (884L)valuecauseDate range has < 10 activities (standard) or < 1 (Ask Jiminny)Prophet Al API threw an exception+ <> CodeClaude Sonnet 4.6winasun leamsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
9914
|
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-jiminny k ~Project v© ReportController.php© JiminnyDebugCommand.phpO dev.jsonAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php= ids.txt© AutomatedReportsService.phpEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mo© CreateActivityLoqgedEvent.phpc UserrilotacuiviiyListener.oneC ActivityLogged.phpjiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xml(c AutomatedRenortscallbackService.one© RequestGenerateAskJiminnyReportJob.phpRequestGenerateReportJob.php© AutomatedReportResult.php x© AutomatedReport.php* @property Carbon/null $updated_atA8X1X1A* Oproperty-read Jiminny\Models\AutomatedReport $report* @property-read AutomatedReportResult|null $parent* Oproperty-read LIlluminatellatabaselEloquent\Collection<int, Automit 552Teraw_sql_query.sqlMeR-ADME.moclass AutomatedReportResult extends Modelsonar-project.properties= test.pyuse reoutresuuro.4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAL QAI4 QAI PROD/*** Status constants*/o usaeespublic const int STATUS_DEFAULT = 0;8 usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;pubLic const 1nt SIATUS_SENI = 5:public const int STATUS_FAILED = 4;V L STAGING& console slAGiNgA console_1 [STAGING]* Reason constantsA uranus [STAGING]*/Services+oe|×~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGINGE consoleDockerOutputlini jiminny.automated report resultsUX. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonI payloadresponseI requested_atgenerated_at• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20ShULLpdf<null><null><null><null><null><nULL2026-04-14 07:48:572026-04-14 07:48:5710G64ĐE custom.log= laravel.logA SF ljiminny@localhost]< console PRODAl console (EU]console slAGiNG© RequestGenerateAskJiminnyReportJobTest.phpx: Auto vPlaygroundA HS_local [iminny@localhost]© AskJiminnyReportActivityService.php545546547548549550551555-556557558559562563564565566 %=567mo liminnvFROM playbooks pjoin playbook_categories pcKo>lan: on p.1d = pc.playbooK_10wnere p.team_1d = 1 and p.accivity_type = eventa016 A13 V,13 лISELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tyoe = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reportsrjoin teams t on r.team.id = t.idWHERE r.trequency = "dally'and r.status = 1AND t.status = 'active'DATMUI(r. exRicesnat >= now() OR r.expicesat IS NULL):select * from automated_report_results where ceRentaid IN (18, 33);select * from automated_reports;select * from automated_report_results where repont.id IN (34);Support Daily • in 4h 3mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 10:57:37CascadeFixing ReportControlleAutomated Report Faillwhy is there report result failed @AutomatedReportResult.php#L44 how could it happenLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportResult.Read AutomatedReportResult.php68 Fast Context AutomatedReportResult STATUS_FAILED or markAsFailed or failed automated report result in 4.12swNow let me also read RequestGenerateReportJob.php fully to get the complete picture:kead kequestcenerarekeportJob.ongSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):iRequestceneraterepor.00.0ho:230-244$count = (int) $content['response'];if ($count < self: :MIN_ACTIVITIES_COUNT) €$this->failReport(AutomatedReportResult:: REASON_NOT_ENOUGH_ACTIVITIES);return false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Trigger 2 - Any Throwable exception ( REASON_PROPHET_API_ERROR or REASON_DEFAULT):M RequestGenerateReport.Job.php:125-151Ask anything (384L)+ <>CodeClaude Sonnet 4.6• :• 8,Unable to resolve table 'automated_report_results'W Windsurf Teams4 spaces...
|
NULL
|
NULL
|
NULL
|
9915
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFileEditVi +SlackEDHomeDMsActivityFilesLater..•MoreFileEditViewGo+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelplihlSupport Daily - in 4h 3m100% <47→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+TMOTOY TARNOY XOOLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:57:41New...
|
NULL
|
NULL
|
NULL
|
9916
|
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-jiminny k ~Project v© ReportController.php© JiminnyDebugCommand.phpO dev.jsonAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php= ids.txt© AutomatedReportsService.phpEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mo© CreateActivityLoqgedEvent.phpc UserrilotacuiviiyListener.oneC ActivityLogged.phpjiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xml(c AutomatedRenortscallbackService.one© RequestGenerateAskJiminnyReportJob.phpRequestGenerateReportJob.php© AutomatedReportResult.php x© AutomatedReport.php* @property Carbon/null $updated_atA8X1X1A* Oproperty-read Jiminny\Models\AutomatedReport $report* @property-read AutomatedReportResult|null $parent* Oproperty-read LIlluminatellatabaselEloquent\Collection<int, Automit 552Teraw_sql_query.sqlMeR-ADME.moclass AutomatedReportResult extends Modelsonar-project.properties= test.pyuse reoutresuuro.4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAL QAI4 QAI PROD/*** Status constants*/o usaeespublic const int STATUS_DEFAULT = 0;8 usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;pubLic const 1nt SIATUS_SENI = 5:public const int STATUS_FAILED = 4;V L STAGING& console slAGiNgA console_1 [STAGING]* Reason constantsA uranus [STAGING]*/Services+oe|×~ D DatabaseV dEUA consolev djiminny@localhostans ocall4 SFV A PRODconsoleV A STAGING4 console 1 s 205 msDockerOutputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonIO payloadresponseI requested_atgenerated_at• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20ShULLpdf<null><null><null><null><null><nULL2026-04-14 07:48:572026-04-14 07:48:57E custom.log= laravel.logA SF ljiminny@localhost]console PRODIAl console (EU]console slAGiNG© RequestGenerateAskJiminnyReportJobTest.phpx:Auto vPlaygroundA HS_local [iminny@localhost]© AskJiminnyReportActivityService.php545546547548549550551555-556557558559560562563564565566 v=567mo liminnvFROM playbooks pjoin playbook_categories pcKo>lan: on p.1d = pc.playbooK_10wnere p.team_1d = 1 and p.accivity_type = eventa016 A13 V13 ^ VISELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tyoe = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'DATMUI(r.exRicesnat >= now() OR r.expicesat IS NULL):select * from automated_report_results where ceRentaid IN (18, 33);select * from automated_reports;select * from automated_report_results where repont.id IN (34);Support Daily • in 4h 3mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 10:57:41CascadeFixing ReportControlleAutomated Report Faillwhy is there report result failed @AutomatedReportResult.php#L44 how could it happenLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportResult.Read AutomatedReportResult.php68 Fast Context AutomatedReportResult STATUS_FAILED or markAsFailed or failed automated report result in 4.12swNow let me also read RequestGenerateReportJob.php fully to get the complete picture:kead kequestcenerarekeportJob.ongSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):iRequestceneraterepor.00.0ho:230-244$count = (int) $content['response'];if ($count < self: :MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult:: REASON_NOT_ENOUGH_ACTIVITIES);return false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Trigger 2 - Any Throwable exception ( REASON_PROPHET_API_ERROR or REASON_DEFAULT):M RequestGenerateReport.Job.php:125-151Ask anything (384L)+ <>CodeClaude Sonnet 4.6ACVw• :• 8,Unable to resolve table 'automated_report_results'W Windsurf Teams4 spaces...
|
NULL
|
NULL
|
NULL
|
9917
|
|
PhpStormFileEditViewNavigateCodeLaravelRefactorToo PhpStormFileEditViewNavigateCodeLaravelRefactorToolsWindowHelpFV faVsco.s v#11894 on JY-18909-automated-reports-ask-jiminny k ~Project v© ReportController.php© JiminnyDebugCommand.phpO dev.jsonAulomaleakeporissendcommand.onoC AutomatedReportsCommand.php= ids.txt© AutomatedReportsService.phpEinfection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.mo© CreateActivityLoqgedEvent.phpc UserrilotacuiviiyListener.oneC ActivityLogged.phpjiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xml(c AutomatedRenortscallbackService.one© RequestGenerateAskJiminnyReportJob.phpRequestGenerateReportJob.php© AutomatedReportResult.php x© AutomatedReport.php* @property Carbon/null $updated_atA8X1X1A* Oproperty-read Jiminny\Models\AutomatedReport $report* @property-read AutomatedReportResult|null $parent* Oproperty-read LIlluminatellatabaselEloquent\Collection<int, Automit 552Teraw_sql_query.sqlMeR-ADME.moclass AutomatedReportResult extends Modelsonar-project.properties= test.pyuse reoutresuuro.4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAL QAI4 QAI PROD/*** Status constants*/o usaeespublic const int STATUS_DEFAULT = 0;8 usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;pubLic const 1nt SIATUS_SENI = 5:public const int STATUS_FAILED = 4;V L STAGING& console slAGiNgA console_1 [STAGING]* Reason constantsA uranus [STAGING]*/Services+oe|×~ D DatabaseV dEUA consolev djiminny@localhostansocall4 SFV A PRODconsoleV A STAGING4 console 1 s 205 msDockerOutputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonI payloadI responseI requested_atIn generated at• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20SnuLlpdf<null><null><null><null><null>2026-04-14 07:48:572026-04-14 07:48:57E custom.log= laravel.logA SF ljiminny@localhost]console PRODIAl console (EU]A console [STAGING] >© RequestGenerateAskJiminnyReportJobTest.phpx:Auto vPlaygroundA HS_local [iminny@localhost]© AskJiminnyReportActivityService.php545546547548549550551555-556557155%560562563564565566 v=567mo liminnvFROM playbooks pjoin playbook_categories pcKo>lan: on p.1d = pc.playbooK_10wnere p.team_1d = 1 and p.accivity_type = eventa016 A13 V13 ^ VISELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tyoe = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.trequency = "dally'and r.status = 1AND t.status = 'active'DATMUI(r.exRicesnat >= now() OR r.expicesat IS NULL):select * from automated_report_results where ceRentaid IN (18, 33);select * from automated_reports;select * from automated_report_results where repont.id IN (34);Support Daily • in 4h 3mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 10:57:43CascadeFixing ReportControlleAutomated Report Faillwhy is there report result failed @AutomatedReportResult.php#L44 how could it happenLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportResult.Read AutomatedReportResult.php68 Fast Context AutomatedReportResult STATUS_FAILED or markAsFailed or failed automated report result in 4.12swNow let me also read RequestGenerateReportJob.php fully to get the complete picture:kead kequestcenerarekeportJob.ongSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):iRequestceneraterepor.00.0ho:230-244$count = (int) $content['response'];if ($count < self: :MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult::REASON_NOT_ENOUGH_ACTIVITIES);return false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Trigger 2 - Any Throwable exception ( REASON_PROPHET_API_ERROR or REASON_DEFAULT):M RequestGenerateReport.Job.php:125-151Ask anything (X4L)+ <>CodeClaude Sonnet 4.6CSVv• :• 8,Unable to resolve table 'automated_report_results'SUM: 1 8:1W Windsurf Teams4 spaces...
|
NULL
|
NULL
|
NULL
|
9918
|
|
+SlackEDHomeDMsActivityFilesLater..•MoreFileEditVi +SlackEDHomeDMsActivityFilesLater..•MoreFileEditViewGo+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelplihlSupport Daily - in 4h 3m100% <47→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+TMOTOY TARNOY XOOLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+AaTue 14 Apr 10:57:48New...
|
NULL
|
NULL
|
NULL
|
9919
|
|
PhpStormFileEditViewFV faVsco.s vProject vO dev.js PhpStormFileEditViewFV faVsco.s vProject vO dev.json= ids.txt= infection.json.distM+INS ALL.mdM+INIERNAL WEB"OOKS-UP.moEjiminny_storageM+ licenses.mdM MakefileOpackage-lock.json= phpstan.neon.dist= phpstan-baseline.neon< phpunit.xmlTeraw_sql_query.sqlMeR-ADME.mosonar-project.properties= test.py4> Untited Diagram.Xmius vetur.confia.isM+ WEBHOOK_FILTERING_IMPLEMEI› Ih External LibrariesE® Scratches and Consolesv D Database ConsolesA EU> A jiminny@localhost&PRODA QAL QAI4 QAI PRODV L STAGING& console slAGiNgA console_1 [STAGING]A uranus [STAGING]NavigateCodeLaravelRefactor,#11894 on JY-18909-automated-reports-ask-jiminny~© ReportController.phpToolsWindowHelp© CreateActivityLoqgedEvent.phpc UserPilotacuiviiyListener.ongC ActivityLogged.php545546(c AutomatedRenortscallbackService.one© RequestGenerateAsKJiminnyReportJob.php547RequestGenerateReportJob.php© AutomatedReportResult.php x© AutomatedReport.php548class AutomatedReportResult extends ModelA8 X1X1A× 549550551=552public const int STATUS_DEFAULT = 0;553o usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;pubLic const 1nt SIATUS_SENI = 5:pubLic const 1nt SIATUS_FALLED = 41554555556557558559560FROM playbooks pjoin playbook_categories pcKo>lan: on p.1d = pc.playbooK_10where p.ceam_1d = 1 and p.accivity_type = 'event)016 A13 V,13 ^ISELECT * FROM crm fields WHERE crm confiquration id = 1 and obiect tyoe = 'event':SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;* Reason constantsselect * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r. frequency = 'daily'and r.status = 1AND t.status = 'active'DATMUI(r. exRicesnat >= now() OR r.expicesat IS NULL):*/o usaees4 usages5 usagespublic const int REASON_DEFAULT = 0;public const int REASON_NOT_ENOUGH_ACTIEITIES = 1;public const int REASON_PROPHET_API_ERROR = 2;562563564565566 v=567select * from automated_report_results where ceRentaid IN (18, 33);select * from automated_reports;select * from automated_report_results where repont.id IN (34);53 Gtprotected $table = 'automated_report_results';Services+oe|×~ D DatabaseV dEUA consolev djiminny@localhostans ocall4 SFV A PRODconsoleV A STAGING4 console 1 s 205 msDockerJiminnybeouecommana.ongAulomaleakeporissendcommand.onoC AutomatedReportsCommand.phpAutomatedReportsRepository.php© AutomatedReportsService.phpE custom.log= laravel.logA SF ljiminny@localhost]console PRODIAl console (EU]A console [STAGING] >© RequestGenerateAskJiminnyReportJobTest.phpx:Auto vPlaygroundA HS_local [iminny@localhost]© AskJiminnyReportActivityService.phpmo liminnvOutputliii jiminny.automated report results X1 row yIx. AuleyDidOuuid (UUID)report_idnameI media_type•parent_idI statusIn reasonIO payloadI responseI requested_atoeneraredau• sent_at• created_atI updated_at4d790a02-ecdc-1b3c-aa56-9fadc94f8d20SnuLlpdf<null><null><null><null><null>2026-04-14 07:48:572026-04-14 07:48:57Windsurf changelog 2.12.21: A new version is available. // View Changelog (24 minutes ago)Support Daily • in 4h 3mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 10:57:48CascadeFixing ReportControlleAutomated Report Faillwhy is there report result failed @AutomatedReportResult.php#L44 how could it happenLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportResult.Read AutomatedReportResult.php68 Fast Context AutomatedReportResult STATUS_FAILED or markAsFailed or failed automated report result in 4.12swNow let me also read RequestGenerateReportJob.php fully to get the complete picture:kead kequestcenerarekeportJob.ongSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth jobs call a private failReport(int $reason) method that updates the result to STATUS_FAILED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):M RequestGenerateReport.Job.php:236-244$count = (int) $content['response'];if ($count < self: :MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult:: REASON_NOT_ENOUGH_ACTIVITIES);return false;MIN_ACTIVITIES_COUNT is 10 - fewer than 10 activities in the date range = failed.Trigger 2 - Any Throwable exception ( REASON_PROPHET_API_ERROR or REASON_DEFAULT):M RequestGenerateReport.Job.php:125-151Ask anything (X4L)+ <>CodeClaude Sonnet 4.6CSVv• :• 8,SUM: 1 8:1W Windsurf Teams4 spaces...
|
NULL
|
NULL
|
NULL
|
9920
|
|
PhpStormFileFV faVsco.jsProjectvEditViewNavigateCo PhpStormFileFV faVsco.jsProjectvEditViewNavigateCodeLaravelRefactorToolsWindowHelp( #11894 on JY-18909-automated-reports-ask-jiminny k ~© ReportController.php© JiminnyDebugCommand.phpC) AiPrompt.phpC AutomatedReportsSendCommand.phpC AutomatedReportsCommand.php© AutomatedReport.php© AutomatedReportResult.ph© AutomatedReportsRepository.php© AutomatedReportsService.php© Calendar.php© CreateHeldActivityEvent.php© TrackProviderInstalledEvent.php© Calllmport.php© CreateActivityLoqgedEvent.phpC UserPilotActivityListener.phpC ActivityLogged.php© CoachingFeedback.php© CoachingFeedbackVisibilit!© CoachingSection.php© CoachingSectionCriterion.f© CoachingSectionCriterionF(e AutomatedRenortscalllbackService.onv© RequestGenerateAskJiminnyReportJob.phpRequestGenerateReportJob.php© AutomatedReportResult.php x© AutomatedReport.php33class AutomatedReportResult extends ModelA8X1X1A© CoachingSectionFeedback© CommentAbstract.phpCommentInterface.php© Contact.php© Device.php© EmailMessage.php© GenericAiPrompt.php© Group.php43© Inbox.phpo usaeespublic const int STATUS_DEFAULT = 0;o usagespublic const int STATUS_REQUESTED = 1;16 usagespublic const int STATUS_GENERATED = 2;public const int STATUS_SENT = 3;public const int STATUS_FAILED = 4;© InboxEmail.php45© InboxEmailBatch.php© Invitation.php* Reason constants© JobLog.php© JobTitle.phpo usaees© Language.phpnuhlin manet int DeicnN ПЕCЛlIT - a•© LanguageDialect.php© Lead.php© MobileSetting.php© Model.php51PS$1© Moment.php© Nudge.php53 Gt© NudgeRun.phpservices+,ocv DatabaseV AEUc consoev & minnvo ocanost4 HS_local4 SFV A PRODA consoleY A STAGING4 console 1 s 205 msDockerFirefoxOutputfb jiminny.automated_report_results X1rowyTx: Auto vOidDuuid (UUID)report_idI namemedia_typeW parent_1dI statusreasonpayloadI responseI requested_atI generated_atI sent_atcreated_atupdated_atuoryoaly-ecoc-osc-aaso-ytadcyuroo/e<null>pdf<null>SIULL<null><null>SIULL070-04-140748192026-04-14 07:48:57Windsurf changelog 2.12.21: A new version is available. // View Changelog (24 minutes ago)= custom.logE laravel.logconsole PRODIAl console (EU]RequestGenerateAskJiminnyReportJobTest.phpx:Auto vA SF ljiminny@localhost]A console [STAGING] >A HS_local [iminny@localhost]© AskJiminnyReportActivityService.php545546547548549550551552[5531552555557558559560562563Playgroundmo liminnvFROM playbooks pjoin playbook_categories pcKo>lan: on p.1d = pc.playbooK_10wnere p.ceam_1d = 1 and p.acuivity_type = 'event":016 A13 V,13 ^SELECT * FROM crm_fields WHERE crm_configuration_id = 1 and object_type = 'event';SELECT * FROM crm_field_values WHERE crm_field_id = 4;select * from crm_layouts cl join playbook_layouts pl 1<->1.n: on cl.id = pl. layouwhere crm_configuration_id = 1 and pl.playbook_id = 175;select * from teams;SELECT r.* FROM automated_reports rjoin teams t on r.team.id = t.idWHERE r.freguency = 'daily'and r.status = 1AND t.status =acmve"DATMUI(r. exRicesnat >= now() OR r.expicesat IS NULL):select * from automated_report_results where ceRentaid IN (18, 33);Support Daily • in 4h 3mARequestGenerateAskJiminnyReportJobTestv100% C•Tue 14 Apr 10:57:50CascadeFixing ReportControlleAutomated Report Faillwhy is there report result failed @AutomatedReportResult.php#L44 how could it happenLet me explore the codebase to understand how STATUS_FAILED gets set on AutomatedReportResult.Read AutomatedReportResult.php68 Fast Context AutomatedReportResult STATUS_FAILED or markAsFailed or failed automated report result in 4.12swNow let me also read RequestGenerateReportJob.php fully to get the complete picture:kead kequestcenerarekeportJoo.ongSTATUS_FAILED is set by two jobs — here's a complete breakdown:Where STATUS_FAILED Gets SetBoth iobs call a private failReport(int $reason) method that updates the result to STATUS FATLED .RequestGenerateReportJob (RequestGenerateReportJob.php)Trigger 1 - Not enough activities ( REASON_NOT_ENOUGH_ACTIVITIES):M RequestGenerateReport.Job.php:236-244$count = (int) $content['response'];if ($count < self::MIN_ACTIVITIES_COUNT) {$this->failReport(AutomatedReportResult:: REASON_NOT_ENOUGH_ACTIVITIES);return false;NeSVywinasun leams50:50 2o charsuir-o( 4 spaces...
|
NULL
|
NULL
|
NULL
|
9921
|
|
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
Directories
platform-inner-team
ai-chapter
alerts
backend
confusion-clinic
curiosity_lab
engineering
frontend
general
infra-changes
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Steliyan Georgiev
Adelina Petrova
,
Ilian Kyuchukov
,
Steliyan Georgiev
Adelina Petrova
Galya Dimitrova
Vasil Vasilev
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Yankov
Nikolay Yankov
Jira Cloud
Toast
Google Calendar
Messages
Messages
Add canvas
Add canvas
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Steliyan Georgiev
Apr 8th at 4:12:14 PM
4:12 PM
Все още кодът не e в master, защото ПРът не е одобрен, но ето така изглежда един примирен рекуест за Panorama report:
curl -X 'POST' \
'
http://localhost:9080/ask-anything-on-demand/request-report
http://localhost:9080/ask-anything-on-demand/request-report
' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '{
"userQuestion": "What are the most common topics in these calls?",
"history": [
],
"attemptNumber": 1,
"callIds": [
"77332439",
"74714697",
"34525304",
"2574920"
],
"teamId": 1,
"request_id": "test_req_q_2",
"callback_url": "
https://localhost:8080
https://localhost:8080
",
"reportPeriod": "Apr 1 - Apr 8"
}'
Lukas Kovalik
Apr 8th at 4:12:58 PM
4:12 PM
ще го наглася
(edited)
1 reaction, react with +1 emoji
1
Add reaction…
Jump to date
Nikolay Yankov
Today at 10:19:59 AM
10:19 AM
като създам дефиниция daily, веднага ли трябва да създаде репорт?
Nikolay Yankov
Today at 10:32:27 AM
10:32 AM
10 мин минаха, още не идва репорт
Lukas Kovalik
Today at 10:34:10 AM
10:34 AM
не само daily но трябва да се пусне команда
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:35:08 AM
10:35
php artisan automated-reports
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:35:39 AM
10:35 AM
значи не създава веднага по принцип, в някакъв час на деня ли стъздава?
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:36:11 AM
10:36 AM
това ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:36:27 AM
10:36
FirefoxPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activity8 Jiminnyg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc(x) Configure SSH access to multipleCa CloudWatch | us-east-2+ Now Tab hiHistoryBookmarksProfilesToolsWindow Helpus-edslz.console.dws.dmdzon.com/clouawd.cm/nome.reelon=us-edstLtnome.aws• search[Option+S]©0 EC2© Elastic Container ServiceG 53 € CodeDeployCo CloudWatchElasticache (03) Aurora and RDS ill Amazon OpenSearch Ser...© CloudFront MediaLiveCloud WatchlCloudWatchFavorites and recentsmlgestiomDashboardsAlarms Ao O27 ©o• Al Operations• GenAl Observability• Application Signals (APM)• Infrastructure Monitoring+ LogsLog ManagementLog Analytics PreviewLog AnomaliesLive TailLogs InsightsContributor Insights• Metrics• Network Monitoring• SetupOverview infoOverviewFilter by resource group•)Alarms by AWS service infoServicesEC2simole vueue servicein alarm OInsufficient data 0OK2Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboardApplication InsightsGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it works1nSupport Daily - in 4h 3m1w100% C2"8 Tue 14 Apr 10:57:53United States (Ohio) *Account ID: 4387-4037-0364STAGE]Custom !UTC timezoneActionsview recentalarms casnooarei•(1)(1)Recent alarms info• meeting-bots-ec2-cpu-utilizationPercent50%Cruurilizarion > b0 Tor carapoins Witnin • minures - (50).®27%4.04%05:0005:3006:0006:3007:0007:30• Cruutilization• meeting-bot-sqs-alarmLount8.7E-34.42-304:0005:00- vumperorvesscceskecelveo• NumberOfMessagesReceived (expected)06:0007:00Configure Application InsightsCloudShellFeedback9 2026, Amazon Web Services, Inc, or its arhliates.PrivacyTermscookie preterences...
|
Slack
|
Aneliya Angelova, Nikolay Yankov, Steliyan Georgie Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev (DM) - Jiminny Inc - 1 new item - Slack...
|
NULL
|
9922
|
|
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Jiminny Inc
Jiminny (Staging)
Add workspaces
Home
Home
DMs
DMs
Activity
Activity
Files
Files
Later
Later
More…
More
Unreads
Threads
Huddles
Drafts & sent
Directories
platform-inner-team
ai-chapter
alerts
backend
confusion-clinic
curiosity_lab
engineering
frontend
general
infra-changes
jiminny-bg
platform-tickets
product_launches
random
releases
sofia-office
support
thank-yous
the_people_of_jiminny
Aneliya Angelova
,
Nikolay Yankov
,
Steliyan Georgiev
Steliyan Georgiev
Adelina Petrova
,
Ilian Kyuchukov
,
Steliyan Georgiev
Adelina Petrova
Galya Dimitrova
Vasil Vasilev
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Nikolov
Galya Dimitrova
,
Nikolay Yankov
Nikolay Yankov
Jira Cloud
Toast
Google Calendar
Messages
Messages
Add canvas
Add canvas
Add and Edit Channel Tabs
Canvas
List
Folder
Jump to date
Steliyan Georgiev
Apr 8th at 4:12:14 PM
4:12 PM
Все още кодът не e в master, защото ПРът не е одобрен, но ето така изглежда един примирен рекуест за Panorama report:
curl -X 'POST' \
'
http://localhost:9080/ask-anything-on-demand/request-report
http://localhost:9080/ask-anything-on-demand/request-report
' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-d '{
"userQuestion": "What are the most common topics in these calls?",
"history": [
],
"attemptNumber": 1,
"callIds": [
"77332439",
"74714697",
"34525304",
"2574920"
],
"teamId": 1,
"request_id": "test_req_q_2",
"callback_url": "
https://localhost:8080
https://localhost:8080
",
"reportPeriod": "Apr 1 - Apr 8"
}'
Lukas Kovalik
Apr 8th at 4:12:58 PM
4:12 PM
ще го наглася
(edited)
1 reaction, react with +1 emoji
1
Add reaction…
Jump to date
Nikolay Yankov
Today at 10:19:59 AM
10:19 AM
като създам дефиниция daily, веднага ли трябва да създаде репорт?
Nikolay Yankov
Today at 10:32:27 AM
10:32 AM
10 мин минаха, още не идва репорт
Lukas Kovalik
Today at 10:34:10 AM
10:34 AM
не само daily но трябва да се пусне команда
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:35:08 AM
10:35
php artisan automated-reports
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:35:39 AM
10:35 AM
значи не създава веднага по принцип, в някакъв час на деня ли стъздава?
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:36:11 AM
10:36 AM
това ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:36:27 AM
10:36
крон го пуска през нощ
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:37:19 AM
10:37
така че мануално пусни при тестване
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Today at 10:38:26 AM
10:38
ако трябва да тестваме други репорти може да променя команда за тестване да приема параметър за report template и д си пускаме определен когато тестваме
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Nikolay Yankov
Today at 10:41:03 AM
10:41 AM
можеш ли да я ръннеш ти командата
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
More actions
Lukas Kovalik
Today at 10:43:05 AM
10:43 AM
да
React with white_check_mark
React with eyes
React with raised_hands
Add reaction…
Reply in thread
Forward message…
Save for later
+SlackFileEDHomeDMsEditViewGoActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelp< →0 lhl§ Support Daily • in 4h 3 m100% <7Tue 14 Apr 10:57:55→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+NMOTOY TARNOY X0OLAI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешNewLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за среди9910:53 пуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev+Aa...
|
Slack
|
Aneliya Angelova, Nikolay Yankov, Steliyan Georgie Aneliya Angelova, Nikolay Yankov, Steliyan Georgiev (DM) - Jiminny Inc - 1 new item - Slack...
|
NULL
|
9923
|
|
FirefoxPlatform Sprint 1 Q2 - Platform Tea& Co FirefoxPlatform Sprint 1 Q2 - Platform Tea& Configure SSH access to multiple@ Console Home | Console Home | usSecurityGroup | EC2 | us-east-2JY-20543 add AJ reports User pilcSRD-6779 | JY-20632 | Unable to |( Jy 19798 evaluation for ai activity(8) Jiminnyg Ask Jiminny test report - 8 Apr 201- Service-Desk - Queues - PlatformC JY-20543 add AJ reports User pilc(x) Configure SSH access to multipleCa CloudWatch | us-east-2+ New TabHistoryBookmarksProfilesToolsWindow Helpus-edslz.console.dws.dmdzon.com/clouawd.cm/nome.reelon=us-edstLtnome.aws• search[Option+S]©0 EC2© Elastic Container ServiceG 53 € CodeDeployCo CloudWatchElasticache (03) Aurora and RDS ill Amazon OpenSearch Ser...© CloudFront MediaLiveCloud WatchlCloudWatchFavorites and recentsmlgestiomDashboardsAlarms Ao O27 ©o• Al Operations• GenAl Observability• Application Signals (APM)• Infrastructure Monitoring+ LogsLog ManagementLog Analytics PreviewLog AnomaliesLive TailLogs InsightsContributor Insights• Metrics• Network Monitoring• SetupOverview infoOverviewFilter by resource group•)Alarms by AWS service infoServicesEC2simole vueue servicein alarm OInsufficient data 0OK2Default DashboardName any CloudWatch dashboard CloudWatch-Default to display it here. Create a new default dashboardApplication InsightsGet started with Application Insights infoSet up monitors and dashboards to detect issues and resolve problems with enterprise applications, databases, and workloads.• How it works1nSupport Daily - in 4h 3m1w100% C2"8 Tue 14 Apr 10:57:55United States (Ohio) *Account ID: 4387-4037-0364STAGE]Custom !UTC timezoneActionsview recentalarms casnooarei•(1)(1)Recent alarms info• meeting-bots-ec2-cpu-utilizationPercent50%Cruurilizarion > b0 Tor carapoins Witnin • minures - (50).®27%4.04%05:0005:3006:0006:3007:0007:30• Cruutilization• meeting-bot-sqs-alarmLount8.7E-34.42-304:0005:00- vumperorvesscceskecelveo• NumberOfMessagesReceived (expected)06:0007:00Configure Application InsightsCloudShellFeedback9 2026, Amazon Web Services, Inc, or its arhliates.PrivacyTermscookie preterences...
|
NULL
|
NULL
|
NULL
|
9924
|
|
+SlackFileEDHomeDMsEditViewGoActivityFiles..•More+ +SlackFileEDHomeDMsEditViewGoActivityFiles..•More+Jiminny ...= UnreadsThreadsHuddlesDrafts & sentDirectoriesExternal connections* Starredplatform-inner-teamChannels# ai-chapter# alerts# backend# confusion-clinic# curiosity_lab# engineering# frontend# general# infra-changes# jiminny-bg# platform-tickets# product _launches# random# releases# sofia-office# support# thank-yousHistoryWindowHelp< →0 lhl§ Support Daily • in 4 h 3 m100% C→Search Jiminny IncAneliya Angelova, Nikolay Yankov, Steliyan Georgiev84• MessagesAdd canvas+MHOTQY TOHRUY XUOL AI10 мин минаха, още не идва репортToday ~Lukas Kovalik 10:34 AMне само daily но трябва да се пусне командаphp artisan automated-reportsNikolay Yankov 10:35 AMзначи не създава веднага по принцип, в някакьв час на деня ли стъздава?Lukas Kovalik 10:36 AMтова ще гледа всичко applicable за днес (ако не понедлник или начало на месец е само daily)крон го пуска през нощтака че мануално пусни при тестванеако трябва да тестваме други репорти може да променя команда за тестване да приема параметьр за report template и д си пускамеопределен когато тествамеNikolay Yankov 10:41 AMможеш ли да я рьннеш ти командатаLukas Kovalik 10:43 AMдаNikolay Yankov 10:45 AMпиши кат оя рьннешLukas Kovalik 10:52 AMзабавих се че ми се разбазикаха settings за средипуснах и мина и fail-наима result нo e failedMessage Aneliya Angelova, Nikolay Yankov, Steliyan Seorgiev+AaTue 14 Apr 10:57:56New...
|
NULL
|
NULL
|
NULL
|
9925
|